setfocus after a msgbox

  • Thread starter Thread starter simpleMod
  • Start date Start date
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
 
It works for me if I have that code in a button click event.

Where are you calling it from?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top