Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create OptionButton at run time
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create OptionButton at run time
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 wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create OptionButton at run time
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" wrote: 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 wrote: 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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create OptionButton at run time
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. James wrote: 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" wrote: 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 wrote: 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 . -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run-time 438 - OptionButton troubles | Excel Programming | |||
how do I create a formula to add up time on a time sheet | Excel Worksheet Functions | |||
want to create a time card to add time | Excel Worksheet Functions | |||
Create dictionary of terms, create first time user site | New Users to Excel | |||
OptionButton | Excel Programming |