asked on
Message in Excel VBA
I want to show a message as below when users hit a button to trigger VBA running, but it seems that users had to click "OK" button inside the message box in oder to run VBA. Is there anyway that VBA can run and the message can stay until done? Thanks!
MsgBox ("please wait a moment, this process can take up to 15 seconds")
MsgBox ("please wait a moment, this process can take up to 15 seconds")
Microsoft ExcelMicrosoft ApplicationsMicrosoft Office
Last Comment
Alex [***Alex140181***]
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
[...]One option is to use the Message Box facility directly, via the Windows API, instead of via the VBA interface.[...]
How to do it?
Great :-(
The link, I PROVIDED (http://www.tek-tips.com/faqs.cfm?fid=4699) exactly describes HOW TO DO IT ;-) Did you even open that link?!?
I am truly not after the point, BUT this is defintely not how EE should work!
Kind regards,
Alex
ASKER
Alex,
Yes, I opened the link, but I had to spend time to figure out. But when I coped and pasted the other sample, it worked immediately. Anyway I really appreciate your helps!
Yes, I opened the link, but I had to spend time to figure out. But when I coped and pasted the other sample, it worked immediately. Anyway I really appreciate your helps!
I don't want to be too offensive now and I surely do not want to bother you, but do you really think, you're going to learn anything by just "copy & paste"?!
Anyways... I'm quite sure, you know what you're doing ;-)
Anyways... I'm quite sure, you know what you're doing ;-)
How to do it?