Macro Run when OptionButton enabled

[nidhipatel]

my userform contians

OptionButton1
OptionButton2
Command Button
macro 1
macro2

i need when OptionButton1 is Enabled and click on commandButton than Macro1 is run Or when OptionBUtton2 is Enabled and click on CommandButton than macro2 is run
how it works

 

[Yongle]

This works with active-x contols
Code goes in sheet module (right-click sheet tab\ View Code \ paste code in window on right)

Private Sub CommandButton1_Click()
    If OptionButton1.Value = True Then
        Call macro1
    ElseIf OptionButton2.Value = True Then
        Call macro2
    End If
End Sub

Private Sub OptionButton1_Click()
    If OptionButton1.Value = True Then OptionButton2.Value = False
End Sub

Private Sub OptionButton2_Click()
    If OptionButton2.Value = True Then OptionButton1.Value = False
End Sub

[COLOR=#008080][I]Place macro1 & 2 codes into either sheet or standard modules[/I][/COLOR]
Sub macro1()
    MsgBox "A"
End Sub

 Sub macro2()
    MsgBox "B"
End Sub

 

[dmt32]

my userform contians

OptionButton1
OptionButton2
Command Button
macro 1
macro2

i need when OptionButton1 is Enabled and click on commandButton than Macro1 is run Or when OptionBUtton2 is Enabled and click on CommandButton than macro2 is run
how it works

By enabled I assume you mean user has selected the optionbutton if this is so then try

Private Sub CommandButton1_Click()
      If Me.OptionButton1.Value Then Macro1 Else Macro2
End Sub

and see if this does what you want

Dave