ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ActiveX Option Buttons all act as one group (https://www.excelbanter.com/excel-programming/326490-re-activex-option-buttons-all-act-one-group.html)

augustus

ActiveX Option Buttons all act as one group
 
Try this:
Select option buttons that mean to form a group, then right-click and click
Properties, then change GroupName properties to something unique. Do this
again for the other two sections.

Also, when you say "They are arranged into three sections on a form."
someone might interpret as userform. ( i have made this mistake in the past.)

Hope this work.


"quartz" wrote:

I have several option buttons on a sheet entered from the "Control Toolbox"
(ActiveX controls). They are arranged into three sections on a form. The
problem is, when I click an option button in one cluster, ALL other option
buttons in all clusters get blanked.

How can I group the option buttons so that they correspond to only other
buttons in their cluster?

Thanks much in advance.



All times are GMT +1. The time now is 04:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com