Disabling Text Boxes in UserForm

[Master_G]

Hopefully a quick question for you guys:

I have a userform with 3 tick boxes, I want the choice of which box is ticked to disable inappropriate text boxes for the user. Ticking one box also disables the other tick boxes.

To do this I currently have the code:

If Tick1 = True Then:
 
Tick2.Enabled = False
Tick3.Enabled = False
Box2.Enabled = False
Box3.Enabled = False
 
Else
 
Tick2.Enabled = True
Tick3.Enabled = True
Box2.Enabled = True
Box3.Enabled = True
 
End If

When I check one of the tick boxes the other tick boxes are disabled but the text boxes remain

Any help appreciated!

G

 

[OfficeUser]

Using:

TextBox1.Enabled = False

should not allow the user to select the textbox to enter data. Does it absolutely need to be greyed out?

 

[OfficeUser]

You can grey it out using:

TextBox1.Enabled = False
TextBox1.ForeColor = SystemColorConstants.vbGrayText

I don't see the difference in the textbox when its greyed out, unless there was text already in it.

 

[Master_G]

Ah, I thought they would automatically be greyed out like the tick boxes are (shoddy testing on my part means I didn't even test whether you could select them or not!)
It doesn't absolutely have to be greyed out, although would be nice to do so to guide the user.
What I will do instead is use Box1.Visible = False to hide them if they aren't to be used.
Thanks for reply, apologies for being so dim as to not actually try using the boxes!

G