can not reference objectbuttons within frame

**Langston** · 09-02-2009, 02:43 PM

On an Excel 2003 spreadsheet I already have two option buttons. I need to add two additional optionbuttons. I placed them within a frame so that they will function independently of the other buttons. Specifically, I created Frame1, selected Frame Object-->Edit, select Toolbox, add Optionbutton3 and Optionbutton4, exit Design mode.

The new Optionbuttons correctly toggle their values when out of design mode . When I re-enter design mode and double-click to take me to the VBA code, it however only shows me Frame1_Click(). Within Frame1_Click() I have tried adding the code

Please Login or Register  to view this content.

, but when it is triggered I get the error message "Object doesn't support this property or method". When I look in Object Browser, I see Frame1 and Frame1_Click, but not Optionbutton3 or Optionbutton4. How do I reference these optionbuttons within the frame?

Thanks,
Cory

**romperstomper** · 09-02-2009, 03:25 PM

If they are on a worksheet, you should be able to just use:

Please Login or Register  to view this content.

**Langston** · 09-02-2009, 03:31 PM

I tried your suggestion, but when I use

Please Login or Register  to view this content.

I get an error message "Object required".

**romperstomper** · 09-02-2009, 04:01 PM

Oh, I see what you did. You could use:

Please Login or Register  to view this content.

though personally I would either skip the frame and just set the GroupName property, or use Forms controls instead which are generally more stable on worksheets anyway.

**Langston** · 09-02-2009, 04:53 PM

Thanks. I did not realize that assigning a different GroupName caused the optionbuttons to function separately from the other optionbuttons. I thought I had to put them within a frame to accomplish this. Though I still wonder why I could not reference them within the frame, your solution solves my problem. I appreciate the help!