Solved: keep cursor in textbox...

[av8tordude]

I have a userform textbox that requires a minimum of 4 characters. I'm able to trigger a msgbox when exiting the textbox if the textbox has less than 4 characters, but I would like the cursor to remain in the textbox with the characters highlighted. Can someone provide assistance.

Thanks

[YasserKhalil]

Try this
TextBox1.SetFocus

Excel Lover

[Bob Phillips]

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
If Not DataOK Then

MsgBox "oops!"

With Me.TextBox1

.SelStart = 0
.SelLength = Len(.Text)
.SetFocus

Cancel = True
End With
End If
End Sub

[av8tordude]

Thank you both. Works great:beerchug:

[av8tordude]

One other thing, when I close the userform, the msgbox appears. How do I do prevent the msgbox from appearing when I close the userform.

[av8tordude]

Can anyone help. Thanks

[mdmackillop]

Try the _BeforeUpdate event instead of _Exit