Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Pedro Gilbert   on Jan 24 In MS Office Category.

  
Question Answered By: Giovanna Silva   on Jan 24

That's just the kind of info I needed.

Using it, I was able to get the buttons  to go on and off.

Worksheets("Sheet1").OLEObjects("OptionButton1").Visible=False

for example.

All was well until I tried to also control  the Value for the buttons.

It should have been so easy.

Worksheets("Sheet1").OLEObjects("OptionButton1").Value=False

But I get an error telling me Value is not a property of the object.

I think the two kinds of OptionButtons from the Form and Control
toolboxs are getting mixed up or something. Is this discussed
anywhere that you know of?

Should we always use the controls from the forms toolbox even if the
books only talk about the buttons from the Control Toolbox?

This is probably something simple that I'm just missing.

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Question about objects and OptionButtons Or get search suggestion and latest updates.


Tagged: