View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Memphis[_2_] Memphis[_2_] is offline
external usenet poster
 
Posts: 6
Default Locking all text, combo and check boxes

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