View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Anthony Anthony is offline
external usenet poster
 
Posts: 275
Default Run a macro within a macro

answered my own question - but thanks for looking!

Sub Oval1_Click()
i = Target
Target = Range("a1")
If Target = "1" Then
result
Else
MsgBox "nope"
End If
End Sub

"Anthony" wrote:

Hi and morning,

how do you run a macro within another macro.

eg if user inputs '1' into cell ref A1 run macro called goto1
else exit sub

thanks