| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referring to Option Button in If then statement
I'm sure this is a very basic question, but I can't seem to find the answer
in Excel Help. How to I reference an option button in an if then formula? Any help would be appreciated. Mike |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Referring to Option Button in If then statement
You can link the optionbutton to a cell and then use that cell in your formula.
If the optionbutton is from the Forms toolbar: rightclick on it choose Format Control|Control Tab and type in an address into that Cell link box. If the optionbutton is from the Control toolbox toolbar, then go into design mode (also on that same toolbar). Then rightclick on it and choose properties and change the LinkedCell property. Mike wrote: I'm sure this is a very basic question, but I can't seem to find the answer in Excel Help. How to I reference an option button in an if then formula? Any help would be appreciated. Mike -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Referring to Option Button in If then statement
"Dave Peterson" wrote: You can link the optionbutton to a cell and then use that cell in your formula. If the optionbutton is from the Forms toolbar: rightclick on it choose Format Control|Control Tab and type in an address into that Cell link box. If the optionbutton is from the Control toolbox toolbar, then go into design mode (also on that same toolbar). Then rightclick on it and choose properties and change the LinkedCell property. Mike wrote: I'm sure this is a very basic question, but I can't seem to find the answer in Excel Help. How to I reference an option button in an if then formula? Any help would be appreciated. Mike -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Referring to Option Button in If then statement
It worked!
Thanks Dave. "Dave Peterson" wrote: You can link the optionbutton to a cell and then use that cell in your formula. If the optionbutton is from the Forms toolbar: rightclick on it choose Format Control|Control Tab and type in an address into that Cell link box. If the optionbutton is from the Control toolbox toolbar, then go into design mode (also on that same toolbar). Then rightclick on it and choose properties and change the LinkedCell property. Mike wrote: I'm sure this is a very basic question, but I can't seem to find the answer in Excel Help. How to I reference an option button in an if then formula? Any help would be appreciated. Mike -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| option button ? | Excel Discussion (Misc queries) | |||
| Option Button | New Users to Excel | |||
| keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
| Option Button | Excel Discussion (Misc queries) | |||
| option button | Excel Discussion (Misc queries) | |||
Hybrid Mode
