Don't know what to call what I need?
 

Ok. I have created the spreadsheet, etc. Now, they want me to set it
up so that before you close the sheet a box will "pop up" and ask you
to confirm if the information you've entered is correct before closing.
I'm sure that I'll feel stupid after I find out how it's done, however
at this moment I'm at a loss...<sigh

Any help would be appreciated!

Thanks so much!

Chandra


--
chanwando
------------------------------------------------------------------------
chanwando's Profile: http://www.excelforum.com/member.php...o&userid=27123
View this thread: http://www.excelforum.com/showthread...hreadid=466339

On Fri, 9 Sep 2005 12:58:42 -0500, chanwando
wrote:


Ok. I have created the spreadsheet, etc. Now, they want me to set it
up so that before you close the sheet a box will "pop up" and ask you
to confirm if the information you've entered is correct before closing.
I'm sure that I'll feel stupid after I find out how it's done, however
at this moment I'm at a loss...<sigh

Any help would be appreciated!

Thanks so much!

Chandra

Use the Workbooks "BeforeClose" event and stick a Message box in the
Workbook_BeforeClose procedure

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

right click sheet tabview codeleft box select worksheetright box select
deactivateput in your code.

--
Don Guillett
SalesAid Software

"chanwando" wrote
in message ...

Ok. I have created the spreadsheet, etc. Now, they want me to set it
up so that before you close the sheet a box will "pop up" and ask you
to confirm if the information you've entered is correct before closing.
I'm sure that I'll feel stupid after I find out how it's done, however
at this moment I'm at a loss...<sigh

Any help would be appreciated!

Thanks so much!

Chandra


--
chanwando
------------------------------------------------------------------------
chanwando's Profile:
http://www.excelforum.com/member.php...o&userid=27123
View this thread: http://www.excelforum.com/showthread...hreadid=466339

"Richard Buttrey" wrote:

On Fri, 9 Sep 2005 12:58:42 -0500, chanwando
wrote:


Ok. I have created the spreadsheet, etc. Now, they want me to set it
up so that before you close the sheet a box will "pop up" and ask you
to confirm if the information you've entered is correct before closing.
I'm sure that I'll feel stupid after I find out how it's done, however
at this moment I'm at a loss...<sigh

Any help would be appreciated!

Thanks so much!

Chandra

Use the Workbooks "BeforeClose" event and stick a Message box in the
Workbook_BeforeClose procedure

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________


Based on the posters subject line: Don't know what to call what I need?, and
on the wording of their post, what are the chances of them knowing what this
means:

Use the Workbooks "BeforeClose" event and stick a Message box in the
Workbook_BeforeClose procedure

Something to think about. And no, I don't know how to do it.

Press the Alt-F11 key combination to open the VBA editor.
Press Ctrl-R to open the Project Explorer on the left
Double-click the This Workbook node for the workbook in question
Paste in this code



Private Sub Workbook_BeforeClose(Cancel As Boolean)

If MsgBox("Is all your input correct?", vbYesNo, "Confirm") = vbNo Then _
Cancel = True

End Sub



"chanwando" wrote:


Ok. I have created the spreadsheet, etc. Now, they want me to set it
up so that before you close the sheet a box will "pop up" and ask you
to confirm if the information you've entered is correct before closing.
I'm sure that I'll feel stupid after I find out how it's done, however
at this moment I'm at a loss...<sigh

Any help would be appreciated!

Thanks so much!

Chandra


--
chanwando
------------------------------------------------------------------------
chanwando's Profile: http://www.excelforum.com/member.php...o&userid=27123
View this thread: http://www.excelforum.com/showthread...hreadid=466339

I really appreciate the help and suggestions!

Duke Carey - I'm sorry that you had to do my work for me, but you did
it GREAT!!! It did exactly what I needed it to and now I have a happy
boss.....

(...and you're right "Lookin", I have virtually NO experience with
VB...just Excel.)

Thanks again for all the help and I even learned something new out of
the deal!

Chandra


--
chanwando
------------------------------------------------------------------------
chanwando's Profile: http://www.excelforum.com/member.php...o&userid=27123
View this thread: http://www.excelforum.com/showthread...hreadid=466339