Getting VBA to choose which macro to run

[G_Force]

Users select one of two options in a cell, and then click a button. I want different macros run on pressing the button depending on what was selected in the cell

Thanks

[mangesh_yadav]

Sub Button1_Click()

If Worksheets("Sheet1").Range("A1") = 1 Then
Call Macro1
ElseIf Worksheets("Sheet1").Range("A1") = 2 Then
Call Macro2
Else
MsgBox "Choose a correct value"
End If

End Sub



- Mangesh

[G_Force]

Thanks, thats great stuff