Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a form with some text boxes used to capture some
text input. After the input box is updated I test the value in a Function called DataOwnerNameValid. If I fail the validation test I give the user a message. I then want to return the cursor to the Input box so the user can reenter the data. To do this I use the following command: DataOwnerForm.DataOwnerInputBox.SetFocus But it doesn't work. The next input box or other control on the form is selected. What is the right way to do this? Thank you Private Sub DataOwnerInputBox_AfterUpdate() If DataOwnerForm.DataOwnerInputBox = "" Then Exit Sub OwnerOK = DataOwnerNameValid (DataOwnerForm.DataOwnerInputBox) If OwnerOK = False Then MsgBox "Not Valid Name", vbExclamation, "Data Owner Name Invalid" DataOwnerForm.DataOwnerInputBox.SetFocus End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Highlight/Select text in User Form? | Excel Discussion (Misc queries) | |||
Adding a new text box to user form | Excel Discussion (Misc queries) | |||
User Form: Cannot Update Text Box | Excel Discussion (Misc queries) | |||
How to set focus back to sheet after showing a user form | Excel Programming | |||
How to set focus back to sheet after showing a user form | Excel Programming |