How do I do this? I only want the user to use the mouse when one of my yes/no msgboxs comes up in the code. Some just enter through without realising.
The below lines work for a workbook, but need it to work only when the msgbox is up so the user cant press ENTER.
e.g.
Help, this should be simple??
Application.DataEntryMode = True MSGBOX Application.DataEntryMode = False
I reckon you'd need api calls to do that but you could use a userform instead of a msgbox statement or add a non-functioning Help button and make it default
MsgBox "my message", vbDefaultButton2 + vbMsgBoxHelpButton
Josie
if at first you don't succeed try doing it the way your wife told you to
Second person to suggest using a help button as a default trap. Tried it.........and it actually works quite well. Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks