Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox and Set Focus
Hi, Thanks for the help for my SQL question!!! I have two more questions (The application is Excel VBA. All controls are in a user form) 1. For ComboBox, how can I prevent users from entering any value other than those in the listed choices in the ComboBox? User can only select the value from the list. 2. There are several Text Boxes in my application. Users need to enter numeric data in these boxes. The function required is if users enter any character, e.g. 300k, there will be an error message and the focus should fix in that TextBox (users can't move from this box to other controls until they enter a valid value). Thanks Ming *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ComboBox and Set Focus
You can set matchrequired property so that they can only
pick from the list. You could use the keyup event to check the character just entered to display a msgbox with an error message and then delete the last character entered. Probabley easier to check the text when they leave the box (less overhead) and then set focus back to the control they just left. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
set focus | Excel Discussion (Misc queries) | |||
Set Focus | Excel Programming | |||
How do I set focus | Excel Programming | |||
Focus on combobox | Excel Programming |