View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default To show a messagebox

Try this

Dim MyMessage As String
MyMessage = "You have to do these things to run my macro"
response = MsgBox(MyMessage, vbInformation)

Mike

"pol" wrote:

While running a macro , I need to show a message box with some instruction
to the users for the successful running of that macros. So please advice me
with a sample code to write a macro to show a messagebox with some
instruction.

With thanks

Pol