You will need to put this bit of code:
TBox1.Enabled = False
TBox2.Enabled=False
....
....
TBox4.SetFocus
Into the code where the decision to disable the Textboxes is made. The last
line will give TBox4 the focus and should put the cursor into it.

HTH
Dean

"mully" wrote in message
...
Hi All

I have a UserForm with 20 Text Boxes and some times TBox1,TBox2,TBox3, do
not need information to be entered is it possible to disable these 3
TBoxes
and the others to run as the code dictates.

Any much appreciated

Cheers -- Mully