To show a messagebox
Hi,
Try this
Dim MyMessage As String
MyMessage = "Open the rebate.xls before macros" & Chr(13) & _
"In Rebate.xls, there should be two page Item and discount" & Chr(13) & _
"The result will be given from current cell upto the end of the item details"
response = MsgBox(MyMessage, vbInformation)
Mike
"pol" wrote:
Thanks lot for the reply.
Also Please let me know to give that insturction line by line
For example
The instruction should be in message box as follows
1. Open the rebate.xls before macros
2. In Rebate.xls, there should be two page Item and discount
3. The result will be given from current cell upto the end of the item details
Please help to show the above instruction in a messagebox . as seperate line
With many thanks
Pol
"Mike H" wrote:
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
|