Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Option Buttons

  Asked By: Cory    Date: Feb 18    Category: MS Office    Views: 896
  

I'm trying to convert a complicated workbook from PC to Mac. I have to change
all my
ActiveX option buttons to those from the forms toolbar. I'm having some trouble
understanding how this works.

I've set up 6 option buttons. When the user comes onto this particular
worksheet, I want
the sixth option button to be the active one.

In the pc version I could set them in VB, but I'm having no luck doing that in
the mac
version. This is what I think should work.

Worksheets("Life & Health").OptionButton18.Value = True

But I get runtime error 438 -- Object doesn't support this property or method

So, I'm not understanding the methods of Option buttons, or I have not got this
named
right. If I cntl click on the object and choose assign macro, the default is
OptionButton18_Click, so I figured it was named OptionButton18. In the Name box
it just
says Option Button for all the buttons as if the group were one item (which it
may be, I
guess). Can I get control of individual option buttons? I'm even having
trouble selecting
more than one so I can group and ungroup them.

Can anyone help?

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on Option Buttons Or get search suggestion and latest updates.




Tagged: