how do I get radio buttons in excel

[Jammings]

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

 

[Kevin B]

Click VIEW/TOOLBARS and select the CONTROL TOOLBOX toolbar. It has option
buttons, check boxes, list boxes, etc...

 

[Jammings]

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]

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.

 

[Jammings]

thanks. it works like magic.

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.