Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forcing Correction of User Input Errors
Thanks Tom. Your advice works like a charm.
Bob Kaku "Tom Ogilvy" wrote in message ... Use the exit event and if you want it to remain in the combobox, set the argument Cancel = True -- Regards, Tom Ogilvy Bob Kaku wrote in message news:3dI8b.434513$o%2.196711@sccrnsc02... I have a form with a number of combo list box controls. I have establish a TabIndex sequence from one combo box to the next. The problem I want to edit for a null entry. In other words, the entry into the combo box should be made to be mandatory. I have an If-Else code block that traps the null entry and issues an error message. Then, I use the .SetFocus property to try to force the cursor to the combo box with the null entry. But, then the TabIndex seems to take over and moves the cursor to the next control, which I don't want. How can I keep the cursor in the combo box to get the user to correct the entry? -- Bob Kaku Email: http://www.majesty.org |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forcing User inputs | Excel Discussion (Misc queries) | |||
Forcing All Caps in input cells | Excel Discussion (Misc queries) | |||
Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
Forcing Input from a user | Excel Worksheet Functions | |||
Forcing the user to make entries in a specified worksheet | Excel Discussion (Misc queries) |