Good afternoon,
I have found this piece of code, but instead of calling a message box I would like it to call a macro, I have 4 macros, when I select an option button then click the command button, I would like the corresponding macro to be called.
any help would be great.
DeeK
Private Sub CommandButton1_Click()
Dim x As Control
For Each x in Frame1.Controls 'Loop through the option buttons
'within the Frame
If x.Value = True Then
MsgBox x.Caption 'Display the name of the selected
End If 'option button
Next
End Sub
Bookmarks