[RESOLVED] .SetFocus

[Fonty]

I have a textbox which is enabled after clicking some checkbox. Those controls lie in a workshet of an Excel book. I've been trying to use .SetFocus, so that the cursor goes to the textbox just after clicking the checkbox. But it doesn't work...
Is it possible to do this in a worksheet? or does it only work in a userform?

[Siddharth Rout]

Hi

Lets say you have a Textbox say Textbox1 in a worksheet, then this should help...

Private Sub CommandButton1_Click()
  TextBox1.Activate
End Sub