control box

  1. K

    Hide a Control Box

    I have some radio buttons in Excel (2011 Mac), and they are grouped by a Group Box. I want to make the Group Box invisible. I searched on the internet and found that I could do that with VBA by entering: ActiveSheet.GroupBoxes.Visible = False in the VBA window that corresponds to the...
  2. E

    lookup in subform

    I am designing a data entry form with a subform. In the subform, I have a list box control that has an inherit value list from a lookup table. On the main form I have a combo list that I am using as a record selector that filters the record on the subform. How can I filter the list box with...
  3. D

    Make a Macro only run on unhidden columns

    Hey guys- I want to be able to hide and show every other column on a sheet (B, D, F, H, J, L, N, P, R, T, V, X, ect.) but only within the range that I am currently viewing. In other words, let's say I click the "Show" macro that will show every other column, from A to the end of the sheet. But...
  4. A

    All Control Toolbox Objects greyed out; properties box empty

    Hi, I am trying to add an option button on excel sheet but when I do, I see it greyed out. If I right click to choose properties, it opens an empty window (no options/text is seen in the property window). Can anyone help?

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