There's nothing wrong with using a userform, but a MsgBox might
suffice. E.g.,
Dim Result As VbMsgBoxResult
Result = MsgBox("Do you want to cancel?", vbYesNo)
If Result = vbYes Then
' user clicked Yes
Else
' user clicked No
End If
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
On Tue, 17 Feb 2009 14:23:01 -0800, wpiet
wrote:
Excellent. Both suggestions will do what I want.
As an initial step for Cancel, I'm thinking of showing another Userform to
verify the Cancel operation, with a label such as "Are You Sure You Want To
Cancel?" and possibly 2 OptionButtons, labeled "Return To Login" & "Abort."
Do you think that is too messy? This is the first I've ever used UserForms,
so it's a complete learning curve for me. The help you guys give here is
invaluable & greatly appreciated. Thanks.