move mouse pointer to a default button(Enter) in messagebox

X

x taol

my worksheet have a button.
i press the the button. and then appear a messagebox.

And that time, i want to move the mouse pointer to the button(Enter), in
the messagebox automatically.
Perhaps, i think.... using win32api.
but i don't know.
 
G

Guest

If using a standard VBA MsgBox you have no control: your code pauses while
the MsgBox appears and waits for an answer.

The best solution is to replace the MsgBox with a userform, then you can
design it to do whatever you want.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top