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

[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.


*** Sent via Developersdex http://www.developersdex.com ***

 

[K Dales]

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.