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

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

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

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

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