Use a message box to get the choice from the user, here's a sample.

Dim intYN As Integer
intYN = MsgBox("Do you want to update flags?", vbYesNo, "Update
Flags")
If intYN = 6 then
[DoIt]
Else
[Don't]
End If


--
Brett0769
------------------------------------------------------------------------
Brett0769's Profile: http://www.excelforum.com/member.php...o&userid=28217
View this thread: http://www.excelforum.com/showthread...hreadid=477638