Disabling a text entry box on a userform

[tonygg9]

I have a user form with 4 text boxes which are prepopulated on initialisation. Depending on the data at initialisation either 3 or 4 text boxes get filled. If it is only 3 boxes I would like to disable/grey out the last text box so people don't try to enter data in it. Is there a simple way to do this? Many thanks

[cytop]

Perhaps

Please Login or Register  to view this content.

... at an appropriate point in the code?

You might also like to disable any associated label to make it obvious the textbox is not available

Please Login or Register  to view this content.

[tonygg9]

Sorry to be dumb but I put the first suggestion in and I can still enter data into the text box. What I would really like is it to be greyed out and no data can be entered. Any ideas? Many thanks

[tonygg9]

Ah. I realised. TextBox4.Enabled = False does the trick.