Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
BeforeSave event
Hello all,
I have a Check box in my a sheet calledheckbox1. I also have an event called Workbook_BeforeSave. How do I check the value of the checkbox from this event? Thanks all, Jon |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
BeforeSave event
If Worksheets("Sheet1").CheckBoxes("Check Box 1").Value = 1 Then
Msgbox "It is set ... -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jon" wrote in message ups.com... Hello all, I have a Check box in my a sheet calledheckbox1. I also have an event called Workbook_BeforeSave. How do I check the value of the checkbox from this event? Thanks all, Jon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change a Worksheet_change event to a beforesave event? | Excel Programming | |||
Need help with BeforeSave event | Excel Programming | |||
BeforeSave Event Question | Excel Programming | |||
BeforeSave event | Excel Discussion (Misc queries) | |||
BeforeSave event | Excel Programming |