You can create a custom function with relevant conditions and get desired results in no time. Open a VBA editor in Microsoft Excel (check the steps above). Create a new module from the Insert menu.

In a powerpoint vba script, I'd like to play a sound from my local computer triggered by an IF statement. Currently I've got a messagebox in place of the alarm sound, as follows: If varTime < Now ...

Why use Select Case and Like together? Select Case is an excellent and efficient tool for setting specific instructions when you have a multiple different conditions (like saying "Congratulations" if ...

When a conditional formatting rule is overkill, use these VBA procedures to highlight duplicates and then remove the highlighting in Microsoft Excel.

There’s no need to keep unused styles in a Microsoft Word document, especially if there are a lot of them. Instead, use this VBA procedure to remove them.

In this post, we will use some Excel VBA code that will help us work back and forth between this format and the regular, two column format recognized by AdWords Editor.