txtbox focus

Hi all!

Well im trying to make the users of a form obliged to type into a textbox.

i wrote a code in a exit event of the textbox like this:

Private Sub txtbox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)

if txtbox1.value = "" then

txtbox1.setfocus

end if

End Sub

but when i hit "TAB" it does not "setfocus" on the txtbox.

What am i doing wrong? how do i make this??

any help appreciated!

Hello. Change:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

HTH

Jason

Private Sub TextBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)

If KeyCode = 9 Then
MsgBox "Tab"
TextBox1.SetFocus
End If

End Sub

Jason,

tyvm it worked just fine!!!

thx you all for the tips!

MP

No problem, MP.