Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA pop-up message
I'd like to have a pop-up message that says "Did you remember to mark-up your
quote?", and if they have they click "Yes" and can move on, and if not "No" forces them to stay on that tab. There are 8 total tabs, and I simply need it when the go from the tab labled "Pricing" to any of the other 7 tabs.. Any idea how I might accomplish this? I'm not finding any information on how to do this, just information that says you can enter pop-up messages. Any help would be greatly appreciated! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA pop-up message
Hey Nango, it's me again, lol. Try something like this
This one could get a little complicated... first off Go to Tools--- Macro--- Visual Basic Editor To the left you'll see a project explorer, if not select View---Project Explorer Then find your workbook, double click on the Sheet "Pricing" A module will pop up, and the top left corner will have a drop down box that says "(General)". Change this to worksheet. You should see this pop up Private Sub Worksheet_SelectionChange(ByVal Target As Range) End Sub In the top right corner, select from the drop down list "Deactivate" So now you'll see this Private Sub Worksheet_Deactivate() End Sub In between those lines... enter the code Response = MsgBox("Did you remember to mark-up your quote?", vbYesNo) If Response = vbYes Then GoTo GoodToGo Sheets("Pricing").Activate GoodToGo: End Sub "NANGO" wrote: I'd like to have a pop-up message that says "Did you remember to mark-up your quote?", and if they have they click "Yes" and can move on, and if not "No" forces them to stay on that tab. There are 8 total tabs, and I simply need it when the go from the tab labled "Pricing" to any of the other 7 tabs.. Any idea how I might accomplish this? I'm not finding any information on how to do this, just information that says you can enter pop-up messages. Any help would be greatly appreciated! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA pop-up message
Thank you so much, those were wonderful directions!
"AKphidelt" wrote: Hey Nango, it's me again, lol. Try something like this This one could get a little complicated... first off Go to Tools--- Macro--- Visual Basic Editor To the left you'll see a project explorer, if not select View---Project Explorer Then find your workbook, double click on the Sheet "Pricing" A module will pop up, and the top left corner will have a drop down box that says "(General)". Change this to worksheet. You should see this pop up Private Sub Worksheet_SelectionChange(ByVal Target As Range) End Sub In the top right corner, select from the drop down list "Deactivate" So now you'll see this Private Sub Worksheet_Deactivate() End Sub In between those lines... enter the code Response = MsgBox("Did you remember to mark-up your quote?", vbYesNo) If Response = vbYes Then GoTo GoodToGo Sheets("Pricing").Activate GoodToGo: End Sub "NANGO" wrote: I'd like to have a pop-up message that says "Did you remember to mark-up your quote?", and if they have they click "Yes" and can move on, and if not "No" forces them to stay on that tab. There are 8 total tabs, and I simply need it when the go from the tab labled "Pricing" to any of the other 7 tabs.. Any idea how I might accomplish this? I'm not finding any information on how to do this, just information that says you can enter pop-up messages. Any help would be greatly appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
replace VBA run-time error message with custom message | Excel Programming | |||
Replace Excel Message w/Custom Message | Excel Programming | |||
Intercept/replace standard 'cell protected' message with my own message? | Excel Programming | |||
Opening an attachment of a message that has a message as attachmen | Excel Programming | |||
Displaying a message in a message box without requiring user to click anything to proceed | Excel Programming |