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

adambc

Active Member
Joined
Jan 13, 2020
Messages
384
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
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 ...
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
You don't select them all, you loop through them all and set each one - e.g. For each ctl in me.controls
 
Upvote 0
Solution

Forum statistics

Threads
1,216,503
Messages
6,131,020
Members
449,615
Latest member
Nic0la

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top