How to execute a macro when user selects radiobutton

Hi,

I have a button named "Convert" that performs some formatting. I have few radio buttons below in which the user can select his option.

When user selects radiobutton1 and click the Convert button radiobutton1 function should execute. similarly if radiobutton 2 is selected i want that function to excute on clicking the convert button.

I tried assigning macro to radiobutton it excutes on radio button click.

But i want it to execute only after clicking on the convert button.

Try something like the following code (tested using Excel 2003):

In the UserForm1 code module:

Please Login or Register  to view this content.

In an ordinary code module:

Please Login or Register  to view this content.

Thanks. Is it possible to user the optionbutton on cells without the userform

No, you can't use 'Option Buttons' on cells without the Userform to the best of my knowledge.

However, You can SIMULATE 'Option Buttons' by using Shapes, and assign macros to the shapes.
See the attached workbook written and tested using Excel 2003, which I expanded to 3 Simulated Option Buttons, and uses code very
similar to what existed with the Userform.


In the 'ThisWorkbook' module an optional initialization can be used:

Please Login or Register  to view this content.

I arbitrarily divided the rest of the code into two modules:
ModSimulatedOptionButtons - which simulates the Option Buttons and interfaces with the Worksheet.
ModConvert - which contains code similar the original.

Code for ModSimulatedOptionButtons follows:

Please Login or Register  to view this content.

Code for ModConvert follows:

Please Login or Register  to view this content.

I added another sheet to the Workbook, which has 'Shapes' that have the
look and feel of UserForm Option Buttons. See the attached workbook.

I did this by adding two Oval 'Shapes' that look like circles for each
simulated Option Button required. The name of each 'outer circle' is irrelevant.
The name of each 'inner (filled in) circle' is IMPORTANT because it is used by
the 'Event Handler' (Macro) to make the 'inner circle' visible or NOT visible.
I assigned the same Macro to each inner/outer circle pair.

I had to rename a couple of the 'Shapes' from their original names which looked
like "Oval 8" to "SimulatedOptionButton1B". The following code is included in
'ModZTest' in the workbook.

First I had to identify all the 'Shape' names:

Please Login or Register  to view this content.

Then I had to rename the 'inner circle' 'Shapes'.

Please Login or Register  to view this content.