Some developers (but certainly not all) have found the immediate window in VBA difficult to use because:
To address this, we are providing the following simple code for free. A form opens that displays your desired text. There are three commands that you can put in your VBA code:
To use this program, download the following zipped file to your desktop, and extract the folder. Open Excel -> VBA and import the following three files from the extracted folder into your Excel workbook:
For an example of running the program, go to the modTestMsg module and run testmsg.
Note: msg is short for message, a shorter form of msgbox.
*Please note that not all programmers find this to be an issue or something that is helpful. But if you do, you are free to use this code provided original credit to Office Expander (www.OfficeExpander.com) is maintained and conveyed.
© 2001- Office Expander