Hi BDB,
You could use something like the following to determine which routine to run:
Sub bdb1974()
Dim ans As String
ans = MsgBox("Import New Yard Inventory?", vbYesNoCancel + vbQuestion, "Question...")
Select Case ans
Case vbYes
Call macro1
Case vbNo
Call macro2
Case Else
Exit Sub
End Select
End Sub
Sub macro1()
MsgBox "Hello Macro1!"
End Sub
Sub macro2()
MsgBox "Hello Macro2!"
End Sub
Clicking Yes to the message box triggers macro1, while clicking No triggers macro2. Clicking Cancel ends the code altogether.
Hope that helps!
Bookmarks