grouped controls

  1. richh

    VBA Loop Through Groups of Option Buttons on User Form

    Excel 2016 Windows 10 I'm trying to loop through all my controls on a user form to ensure they've been completed; I'm confused on how to check to see if one option button has been selected in a group of buttons. Each button is coupled with only one other button per group name, so if either one...
  2. P

    Macro command button gets Deleted

    I am new to this forum. I have an excel file with macros.I group all the shapes on a sheet.The command button and check boxes also gets included in it.When I delete the shape group the command button gets deleted.I just want to delete the shape group without the button and check boxes Any...
  3. M

    Using OLEObjects with grouped controls

    Hi Everybody. I am trying to set all checkboxes and radio buttons on a spreadsheet to False every time a drop down list value changes and I am using the following code: Dim ole As OLEObject For Each ole In ActiveSheet.OLEObjects If ole.progID = "Forms.CheckBox.1" Or ole.progID =...
  4. M

    OLEObjects will not work with grouped controls?

    Hi Everybody. I am trying to set all checkboxes and radio buttons on a spreadsheet to False every time a drop down list value changes and I am using the following code: Dim ole As OLEObject For Each ole In ActiveSheet.OLEObjects If ole.progID = "Forms.CheckBox.1" Or ole.progID =...

This Week's Hot Topics

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
Top