Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I have a user form with several text, combo and checkboxes, as well as command buttons. I would like for the user to check a check box and lock all txt,cmb and chk boxes in the form once they are entering the data, but I want to keep the cmd buttons enabled, so I do not need to lock the whole userform. I would like to see if there is a way to do this in a "batch", for example If chkbox1= True then "All txtboxes".Locked=True I would hate to name every single one. Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Drag and drop text in userform text / combo boxes | Excel Programming | |||
Getting Combo boxes to change options based on other Combo boxes. | New Users to Excel | |||
How can I sum up several check boxes conditioned by a combo box? | Excel Discussion (Misc queries) | |||
locking check boxes using a macro | Excel Programming | |||
filling text boxes from a combo box | Excel Programming |