View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Kaku Bob Kaku is offline
external usenet poster
 
Posts: 7
Default 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