Naming Grouped Form Objects

tx12345

Board Regular
Joined
Aug 28, 2006
Messages
165
I have an easy question i think (hope). When designing a form that has a number of objects, all with unique names, to move them around on the form as a groyp and position them where needed, they can all be selected by draggung the mouse over them, and then you can go to the format menu and group them.

now, if all of these items are option controls (i.e. radio buttons and checkboxes) you can create a group name, whereupon you can 'conveniently' make one group disappear and another appear, etc.

*but* if there are names, combobxes, text boxes, list boxes, etc, the option to name the group disappears.

so, unfortunately because such a simple feature does not exist, i have to ask if there is a way to, after highlighting all the objects on the form template (or any number of them) one can give a name to that group, no matter what is included, and then be able to say:

group.x.visible = True or
group.x.visible = False


many thanks as always

tx
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Hi,

are you talking about forms on a userform or a sheet ?

anyway: you can loop through the objects to make them visible or not
if there is some logic in your layout this shouldn't be to difficult
you can f.i. loop through all controls in a certain range (if on a sheet) ...

kind regards,
Erik
 
Upvote 0
If you want to group controls, place them within another control such as a frame or image.
 
Upvote 0

Forum statistics

Threads
1,223,719
Messages
6,174,089
Members
452,542
Latest member
Bricklin

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