Focus/Tab return to Textbox 2

[mudstuffin]

I have a form in Excel, and if the user does not enter a numeric in a particular textbox, a message box pops up to advise that the entry needs to be a number.

How can I then take the focus back to that textbox so that the user can re-enter it correctly. At the moment, as soon as the message box is clciked, it switches to the next textbox as per the index.

Many Thanks.

Greg.

 

[ide]

insert into the code of form something like this:

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
If TextBox1.Text = "" Then MsgBox "blabla"
SendKeys "+{TAB}" 'Sending SHIFT+TAB
End Sub

 

[mudstuffin]

Thanks Ide for the quick response.

It has been buggin me all day and I didn't think of going down that route.

Works a treat.

Thanks again.

 

[SkipVought]

ide,
Thanx for that straight-forward solution.. Skip,
metzgsk@voughtaircraft.com

 

[llamaman]

Is there any way to send a left arrow key in a similar manner to the way you sent the SHIFT+TAB?
Is there a resource for all special keys?
thanks,
llamaman

 

[SkipVought]

Do you mean that you want to move the selected cell to the LEFT?

ActiveCell.Offset(0, -1).Select

Skip,
metzgsk@voughtaircraft.com

 

[llamaman]

Whoops .. using Word, but was applying this thread to my situation.

I do Excel VBA in my sleep, but with Word, I do not have a good handle on all of the objects.

What I'm trying to do is to come up with some obscure way to not allow a user to hit <enter> inside my text box on a word 97 form.

Thanks for the try!
llamaman