chuckcoleman
Registered User.
- Local time
- Today, 16:29
- Joined
- Aug 20, 2010
- Messages
- 363
I have a Combo Box that its "Limit to List" is Yes. If the user attempts to enter something that isn't in the list, I produce a MsgBox that tells them that. For that same Combo Box there is an "On Change" event that runs a big macro. When I look at the Event Order, it is: KeyDown, KeyPress, Change, KeyUp, Not-In-List, Error. Since the Not-In-List occurs after the Change, the macro runs but since the Combo Box has a value that is not in the list, I get a Macro Single Step dialog box and the user has to click on "Stop All Macros".
How can I prevent the macro in the On Change event from running if the user types something in the Combo Box that isn't in the list?
Thanks,
Chuck
How can I prevent the macro in the On Change event from running if the user types something in the Combo Box that isn't in the list?
Thanks,
Chuck