Option Button Macro

[gerald24]

Hi Guys,

Anyone who knows how option buttons work in excel macro?

So what I want to happen is I have two option buttons (for example, option A = with tax, option B = without Tax)
Then, I will hit a button (let's say a trigger button) to compute a certain amount that is affected whatever option I selected.

Thanks, Guys.

 

[MrKowz]

After you record/program your macros. Go into developer mode, right click on an option button. There, you can choose "Assign Macro" and choose the macro you want associated from the list.

 

[gerald24]

After you record/program your macros. Go into developer mode, right click on an option button. There, you can choose "Assign Macro" and choose the macro you want associated from the list.

Hi MrKowz,

what I would like to do is not the option buttons to trigger my macro, I want another macro button to do the job, the option buttons are much more like parameters.

 

[My Aswer Is This]

Normally you would not need two Option Buttons.

Create one Option Button. Named OptionButton1

Now if you want to tax the person click the option button if not then do not select the option button.

Put this script in a command button:

This is a example:

If you click the option button and then click the command button the word "Tax" will be put in Range("A1")

Put this script in the command button:

Private Sub CommandButton1_Click()
If OptionButton1.Value = True Then
Cells(1, 1).Value = "Tax"
OptionButton1.Value = False
End If
End Sub

 

[My Aswer Is This]

If you just insist on having two Option Buttons that fine. When user clicks on second Option Button the script will still run when you click Command button but no other action like adding tax will happen

 

[gerald24]

Normally you would not need two Option Buttons.

Create one Option Button. Named OptionButton1

Now if you want to tax the person click the option button if not then do not select the option button.

Put this script in a command button:

This is a example:

If you click the option button and then click the command button the word "Tax" will be put in Range("A1")

Put this script in the command button:

Private Sub CommandButton1_Click()
If OptionButton1.Value = True Then
Cells(1, 1).Value = "Tax"
OptionButton1.Value = False
End If
End Sub

Here's what I have. But it's not working

Private Sub OptionButton21_Click()

End Sub
Private Sub CommandButton1_Click()
If OptionButton21.Value = True Then
Cells(1, 3).Value = "Tax"
OptionButton1.Value = False
End If
End Sub

Can you tell me what's wrong?

 

[My Aswer Is This]

You put my script in your option Button.
You said you wanted the script to run when you clicked the command button.
Here is your quote:
"Hi MrKowz,

what I would like to do is not the option buttons to trigger my macro, I want another macro button to do the job, the option buttons are much more like parameters."


You need to put my script in a command button

Here's what I have. But it's not working

Private Sub OptionButton21_Click()

End Sub
Private Sub CommandButton1_Click()
If OptionButton21.Value = True Then
Cells(1, 3).Value = "Tax"
OptionButton1.Value = False
End If
End Sub

Can you tell me what's wrong?