View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal Robert Crandal is offline
external usenet poster
 
Posts: 309
Default Textboxes on userforms

I have a couple textboxes on my userform, but I am mostly
interested in Textbox3. Once a user enters string data
into Textbox3 and presses the Enter key I would immediately
like to check the string. If the string is NOT valid, I would
like the clear out the invalid string from Textbox3. This will
tell the user that the typed data was invalid and that they
need to re-type the data again. If the data IS valid, I would
like the focus to leave Textbox3 (and possibly go to Textbox1)

Does this involve using "TextBox3_AfterUpdate",
"TextBox3_Exit", and the Setfocus() function??? I'm not
sure how to set this up. Please help.

thank you