Hello ---
I am rather desperate to receive help with Option Buttons using VBA.
#1 -- Form Control Option Box
I was not using these objects within a form, but rather in a worksheet. Perhaps that should not be done?
I need about 50 sets of Option Boxes. My goal was to create 50 Form Control Group Boxes and place three Option Buttons within each Group Box . Once I linked the Group Box to a cell, it would provide values of 1, 2, or 3 depending which Option Button was selected. Fantastic!!!
Also, I was able to to change the fill color of an Option Button. Using VBA, I could l look at each Option Button and determine which ones were colored.
This seemed to go well, but after creating 7-8 Group Boxes with three Option Boxes inside, the Option Buttons were out of control, acting as if they were not confined by their Group Box. I was getting values greater than 3. This appears to be an obvious error, but I did this VERY CAREFULLY several times with the same frustrating results.
#2 -- ActiveX Controls Option Box
These are very different, but I am able to link the Option Button values to a cell and again determine which Option Button was selected.
However, I need to discover the BackColor of each Option Button.How can I do this?
Looking forward to your insights.Thank you!
Bookmarks