| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I get radio buttons in excel
I want to set up botton with labels that when I click on the respective
buttons a maco is run which filters the range I want. eg daily sales for Jan. or dailysales for february. I am using excel 2003 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I get radio buttons in excel
Click VIEW/TOOLBARS and select the CONTROL TOOLBOX toolbar. It has option
buttons, check boxes, list boxes, etc... -- Kevin Backmann "Jammings" wrote: I want to set up botton with labels that when I click on the respective buttons a maco is run which filters the range I want. eg daily sales for Jan. or dailysales for february. I am using excel 2003 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I get radio buttons in excel
Thanks kevin. This was what I wanted. I got the macro to run the filter
however I dont remember how to link the macro to the button I have created. "Kevin B" wrote: Click VIEW/TOOLBARS and select the CONTROL TOOLBOX toolbar. It has option buttons, check boxes, list boxes, etc... -- Kevin Backmann "Jammings" wrote: I want to set up botton with labels that when I click on the respective buttons a maco is run which filters the range I want. eg daily sales for Jan. or dailysales for february. I am using excel 2003 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I get radio buttons in excel
Turn you CONTROL TOOLBOX back on if necessary. The button on the toolbar
that has a ruler, triangle and pencil is the design button. Click this to turn design mode back on. Point your mouse to your option button and right click and then select View Code in the menu. You can either place all your macro code in the worksheet module or you can reference you sub/function that's in a code module. When done, close the Visual Basic Module, turn design mode off so you can test drive your macro and save your work before running the code. Hope this helps. -- Kevin Backmann "Jammings" wrote: Thanks kevin. This was what I wanted. I got the macro to run the filter however I dont remember how to link the macro to the button I have created. "Kevin B" wrote: Click VIEW/TOOLBARS and select the CONTROL TOOLBOX toolbar. It has option buttons, check boxes, list boxes, etc... -- Kevin Backmann "Jammings" wrote: I want to set up botton with labels that when I click on the respective buttons a maco is run which filters the range I want. eg daily sales for Jan. or dailysales for february. I am using excel 2003 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I get radio buttons in excel
thanks. it works like magic.
"Kevin B" wrote: Turn you CONTROL TOOLBOX back on if necessary. The button on the toolbar that has a ruler, triangle and pencil is the design button. Click this to turn design mode back on. Point your mouse to your option button and right click and then select View Code in the menu. You can either place all your macro code in the worksheet module or you can reference you sub/function that's in a code module. When done, close the Visual Basic Module, turn design mode off so you can test drive your macro and save your work before running the code. Hope this helps. -- Kevin Backmann "Jammings" wrote: Thanks kevin. This was what I wanted. I got the macro to run the filter however I dont remember how to link the macro to the button I have created. "Kevin B" wrote: Click VIEW/TOOLBARS and select the CONTROL TOOLBOX toolbar. It has option buttons, check boxes, list boxes, etc... -- Kevin Backmann "Jammings" wrote: I want to set up botton with labels that when I click on the respective buttons a maco is run which filters the range I want. eg daily sales for Jan. or dailysales for february. I am using excel 2003 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set up radio buttons in excel 2007? | Excel Discussion (Misc queries) | |||
| How to add either radio buttons or checkboxes to an excel sheet? | Excel Worksheet Functions | |||
| How do I set up radio buttons and slider bars in excel? | New Users to Excel | |||
| add radio buttons to an excel document | Excel Worksheet Functions | |||
| VBA: Disable Frame and Radio Buttons based on Another Radio Button Being True | Excel Worksheet Functions | |||
Linear Mode
