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

A

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.
Sort by date Sort by votes
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
You must log in or register to reply here.

Similar threads

J
  • Question
File opening as Read Only
Replies
5
Views
354
rlv01
R
S
  • Solved
Help Required With Barcode Being Read Into A Userform...
Replies
3
Views
1K
NoSparks
N
R
  • Question
Help needed to decide if I should use AfterUpdate or Exit on my UserForm Combobox
Replies
1
Views
75
rlv01
R
M
  • Solved
Display textbox from listbox - getting 381 error
Replies
4
Views
380
maiatanaka
M
R
  • Question
Can you help with this code please?
Replies
3
Views
191
rlv01
R

Forum statistics

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

Share this page

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