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
--
simpleMo
-----------------------------------------------------------------------
simpleMod's Profile:
http://www.excelforum.com/member.php...fo&userid=1572
View this thread:
http://www.excelforum.com/showthread.php?threadid=27245