Create OptionButton at run time

[James]

I their a way I can create an option button at run time using vba and place
it on a specific worksheet named "Admin" Thanks.

 

[Dave Peterson]

You could. But if you have code associated with this optionbutton, it'll get
messy really quickly.

Instead, you could create the optionbutton and hide it. Just make it visible
when you want to see it.

If you need help, what kind of optionbutton is it?

Is it from the Forms toolbar or is it from the control toolbox toolbar?

What's the name of the optionbutton?

And when should it be made visible (and when/if should it be hidden)?

 

[James]

The problem with hiding it is I do not know how many I need to make. I am
returning the names of all the worksheets from another workbook and it will
vary.
For each name retrieved I want an optionbutton (optionbutton1,
optionbutton2...)
I am using the control from the controls toolbox, thanks.

 

[Dave Peterson]

What's the largest number that you think you'd need? Double it and add some
fudge factor.

I don't know what you're doing with this, but if I wanted to select a single
worksheet, I'd use a combobox.

If I want to (possibly) select multiple sheets, then I'd use a listbox with
multiselect:=true.

Or I'd use a simple value (like X) in a column.