MrExcel Publishing
Your One Stop for Excel Tips & Solutions

To print a variable in a Dialogue Box?


Posted by yogesh k. potdar on October 31, 2001 8:44 AM

Hi,

I want to print value of X in the following statement which opens a dialogue box: X will be an integer, calculated earlier in the macro.

MsgBox " File cleanUp successful, X cars found"


Posted by Joe Chin on October 31, 2001 10:07 AM

It would be like this:

Dim X as Integer

X = 12
Msgbox "File Cleanup Successful, " & X & " cars found."

Posted by yogesh k. potdar on October 31, 2001 12:34 PM