The below line of code will give you a pop-up box with the message of your choice. MsgBox(“Whatever Message You Choose”)
Turn Off Screen Updating
Turning off Screen Updating will speed up your macros by running all the steps in the background without the need to refresh your screen during the process. The line of code below should be put at the beginning of your macro. Application.ScreenUpdating=FALSE This is an Excel wide setting so you must remember to turn it…
Share this:
My Simple Loop
There are a number of ways of writing loops but I like the Do Until way of doing things. The basic structure is as follows: Do Until ‘whatever criteria you set, see below’ ‘code for the action you want’ Loop This will repeat the loop until the criteria has been met. A simple use would…
