Sending cursor to TextBox

[dave8]

I created several textboxes using the forms control. The textboxes are on a worksheet. I also have a command button that evaluates each of the entry in the textbox. When the code encounters an empty textbox, I want to bring the cursor [focus] back to the empty textbox. I don't have a setfocus property in any of the textbox that I'm using. So, how to accomplish this?

 

[id107]

I've never used forms on a sheet before, this works on a userform, but nor sure if it'll be of any use to you

    If TextBox1.Value = "" Then
        TextBox1.SetFocus
        Exit Sub
    End If

 

[dave8]

Thanks, but this does not work for me. I believe this works using the Textbox in ActiveX control. I'm using the Textbox in Forms control, which does not have a Focus property.