S
simpleMod
Hello,
I have a userform where i validate if the text entered can be formatte
to a number (double). When the check is false, a msgbox pops up sayin
"text entered is a number." [retry] [cancel]
If Not IsNumeric(wtStr) Then
If MsgBox(wtStr & " is not a weight value.", 5) = vbRetry Then
Me.BoxWeightTextBox.Text = ""
Me.BoxWeightTextBox.SetFocus
End If
End If
This is the code fragment. I expected the focus to go back text box
but instead shifts to the next tabstop.
Am I doing something wrong? or is this a newbie mistake? HELP!!
Thanks in advance
I have a userform where i validate if the text entered can be formatte
to a number (double). When the check is false, a msgbox pops up sayin
"text entered is a number." [retry] [cancel]
If Not IsNumeric(wtStr) Then
If MsgBox(wtStr & " is not a weight value.", 5) = vbRetry Then
Me.BoxWeightTextBox.Text = ""
Me.BoxWeightTextBox.SetFocus
End If
End If
This is the code fragment. I expected the focus to go back text box
but instead shifts to the next tabstop.
Am I doing something wrong? or is this a newbie mistake? HELP!!
Thanks in advance