I have created a Frame in Excel spreadsheet, and added a few Optionbuttons to it using frame object edit property. but i wouldnt be able to use VBA to find those optionbuttons and control them.
may i know how to do that?
I have created a Frame in Excel spreadsheet, and added a few Optionbuttons to it using frame object edit property. but i wouldnt be able to use VBA to find those optionbuttons and control them.
may i know how to do that?
Re: Optionbutton
Would you mind clearing something up? Which Toolbar are the OptionButtons from? What do you mean by control them?
Thanks,
Mac
Re: Optionbutton
Thanks for replying.
I want to have a form which contains option group so that i can choose one of them. later i want to use VBA to do different things according to the option i have chosen on that form.
i created the Frame from "Control Toolbox", and under "More Controls" -- Microsoft Forms 2.0 -- Frame".
then i edit the Frame Object by right clicking on it and add optionbuttons to it.
Hope this would be clearer.
Re: Optionbutton
Well, admittedly, I'm no expert with that particular type of control. However, I don't think you'll get what you're looking for with it. I would suggest using the Label in the Control Toolbox to create a frame and use OptionButtons from the Control Toolbox or perhaps a Userform. These can be easily manipulated through code, whereas I don't think the ones you are trying to use can. I could be wrong. I'm sure someone will tell us if I am.
If you do decide to use the other controls, I will be more than glad to help you with them.
Regards,
Mac
Re: Optionbutton
spoonjiang,
[thread title]*[/thread title]
Also, if you have a question then just ask it. What "things" do you want to do with VBA, OptionButtons and Frames.
Don’t have an account yet? Register yourself now and be a part of our community!