Don't know what to call what I need?

C

chanwando

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
 
R

Richard Buttrey

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
Click to expand...

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

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
D

Don Guillett

right click sheet tab>view code>left box select worksheet>right box select
deactivate>put in your code.
 
L

Lookin for a job

Richard Buttrey said:
Use the Workbooks "BeforeClose" event and stick a Message box in the
Workbook_BeforeClose procedure

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
Click to expand...

Based on the posters subject line: Don't know what to call what I need?, and
Use the Workbooks "BeforeClose" event and stick a Message box in the
Workbook_BeforeClose procedure
Click to expand...

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

Duke Carey

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
 
C

chanwando

I really appreciate the help and suggestions!

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

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

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

Chandr
 
Top