drop down run macros

[kingcashandcarry]

I am working with that code
[Sub DropDown1_tameio()
Dim a As ControlFormat
Set a = Sheet2.Shapes("Drop Down 2").ControlFormat
Select Case a.Value
Case 2: Application.Goto Worksheets("sheet").Range("A1")
Case 3: macro1
End Select
End Sub]

case 2 is just a hyperlink to move between sheets and cells
case 3 is a call of macro

is there any way to put yes or no before case 3 so when it is to run a macro to ask for confirmation?

 

[vletm]

kingcashandcarry
just before macro1-text add

if msgbox("run a macro?",vbyesno,"confirmation") = vbyes then

 

[kingcashandcarry]

thank you very much
i had that code but i was putting above the case 2.that was my wrong and vletm just help me a lot