VBA create box with some possibilities

[mrmaso]

Hi
I would like ask how is possible to write macro which will open (create) some "box" or bracket with two possibilities. This two possibilities will be conected to different macros. Then when I will choose one option this box will disapear.




On next time when I will activete this kind of macro again will appear box ....

Thank you

 

[MickG]

Perhaps something like this:-
NB:- This Initial Code is run from CommandButton1

Private Sub CommandButton1_Click()
 Dim Ans As String
 Ans = MsgBox("NB:-" & vbLf & """Yes"" for Code 1" & vbLf & """No"" for Code 2", vbYesNoCancel + vbInformation)
    If Ans = vbYes Then
        Call Code1
    ElseIf Ans = vbNo Then
        Call Code2
    End If
End Sub