J
jimec74
Hi
I have a UserForm with several text boxes embedded into frames (used only as
a visual aid for grouping the text boxes).
I am using AfterUpdate to validate the user input, eg:
'---------------------------------------
Sub Txt_StartValue_AfterUpdate()
Dim Msg, Title, Response
If IsNumeric(Txt_StartValue.Value) = False Then
Msg = "You must enter a number"
Title = "Non-numeric Value"
Response = MsgBox(Msg,16,Title)
Txt_StartValue.SetFocus
End If
End Sub
'-----------------------------------------
Problem is, when Txt_StartValue is embedded within a Frame, the SetFocus
doesn't work & the next textbox is selected.
Any ideas as to how to get the correct textbox selected via the SetFocus?
Thanks,
James
I have a UserForm with several text boxes embedded into frames (used only as
a visual aid for grouping the text boxes).
I am using AfterUpdate to validate the user input, eg:
'---------------------------------------
Sub Txt_StartValue_AfterUpdate()
Dim Msg, Title, Response
If IsNumeric(Txt_StartValue.Value) = False Then
Msg = "You must enter a number"
Title = "Non-numeric Value"
Response = MsgBox(Msg,16,Title)
Txt_StartValue.SetFocus
End If
End Sub
'-----------------------------------------
Problem is, when Txt_StartValue is embedded within a Frame, the SetFocus
doesn't work & the next textbox is selected.
Any ideas as to how to get the correct textbox selected via the SetFocus?
Thanks,
James