Hi Mully,
To disable the textbox, the enabled property can be set to False:
Me.TextBox1.Enabled = False
Alternatively, the textbox can be hidden:
Me.TextBox1.Visible = False
---
Regards,
Norman
"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
|