mgsbox question

[Wu]

In my marco, I want to show a message box to ask " do you have open the
1244.xls file" and to show two button " yes" and "no" for user select.

If user select "yes", my marco will go on,

select "no", it will quit the marco

 

[Wayne-I-M]

Hi

I am not really sure if you can have Ye No in a macro. I think you could
have IIF False type answer but it's really imple to do this OnClick

Have a look at this and if you have problems post back with another quetion
and I'm sure someone will answer

http://msdn.microsoft.com/en-us/library/aa445083(VS.60).aspx

 

[Ken Snell \(MVP\)]

Actually, this can be done using the Condition part of a macro action:

Condition: MsgBox("Your Message", 4, "Your Title") = 7
Action: StopMacro