Hi Norman

Thanks worked perfectly first time

Once again Thank you

Cheers -- Mully

"Norman Jones" wrote:

Hi Mully,

Private Sub CheckBox1_Click()
Me.TextBox1.Enabled = Not Me.CheckBox1.Value
End Sub


---
Regards,
Norman



"mully" wrote in message
...
Hi Norman

Thanks for quick response --- should have put this in 1st question --
could
I place a check box next to the 3 text boxes and just click on it and the
boxes would be greyed out.

"Norman Jones" wrote:

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