Select ALL fields on UserForm and make them read only in VBA

[adambc]

I have a UserForm with ~25 fields (TextBoxes and ComboBoxes) ...

Some are set to Read Only through their properties, but I want to make ALL fields Read Only if a particular TextBox <> "" ...

i) how do I select ALL fields and
ii) make them all Read Only

... in VBA

(I'm going round in circles!)

Thanks ...

 

[RoryA]

You don't select them all, you loop through them all and set each one - e.g. For each ctl in me.controls

 

[adambc]

You don't select them all, you loop through them all and set each one - e.g. For each ctl in me.controls

@RoryA

Duh!!!

Thank you ...