Run a macro from a msg box??

[shy07014]

hey there, i want to run a macro called "macro_2" from a msg box

here the code i already have:

Response = MsgBox(prompt:="Run Macro?", Buttons:=vbYesNo)
         If Response = vbYes Then
      [COLOR=red]????????? heres were the code goes[/COLOR]
      Else
      End If

thanx alot,
shy

 

[mvptomlinson]

Try

Call macro_2

 

[shy07014]

thanx alot