Pop-up message macros

Beckwa

New Member
Joined
Mar 12, 2002
Messages
33
I'm designing a booking system and have created a macro to clear the form so it's ready for the next data entry. The problem is the booking needs to be printed and added to the database from the form first. What i'm wondering is how would i get a pop up message which reminds the user of this where it is possible for an "OK" and a "cancel" style option. At the moment all that happens is the message pops-up asking if the booking has been saved and added and the user can only click ok which will then clear the form regardless of whether it's been added or printed.
Copy of what i'm using at the moment is below:

MsgBox "Have You Printed and added this booking before clearing?", vbInformation
Thanx for any help, BEX :)
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
Hey Beckwa, perhaps the code below will help:

Select Case MsgBox("Have You Printed and added this booking before clearing?", vbYesNo)
Case vbYes
'your code
Case vbNo
'your code
End Select


Hope so. Cheers,

Nate
This message was edited by NateO on 2002-03-13 12:07
 
Upvote 0
Could you please explain more? How to "Select Case MsgBox("Have You Printed and added this booking before clearing?", vbYesNo) "

Thanks
 
Upvote 0
Bex, me, showing off? :eek: Three good smileys deserve some more (as I always say)!

I can certainly explain more WYTT, what would you like to know?

Cheers y'all,

Nate
This message was edited by NateO on 2002-03-13 15:20
 
Upvote 0

Forum statistics

Threads
1,213,528
Messages
6,114,154
Members
448,553
Latest member
slaytonpa

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top