Using a checkbox to trigger an email

[Chris]

I have a spreadsheet to keep track of documentation that our group
creates. The final step is for the writers to put a copy of the file
into several network directories. Can I build a checkbox inserted into
each row and when that box is checked, the row info is emailed to me?

I don't want the entire sheet emailed, just notification that 'User
Manual' or 'Load Manual' was updated.

Thanks
Chris

 

[Bill Lunney]

One solution:

1 change one of the columns to use a font showing a checkbox tick character
2 capture the Worksheet_Change event and check for a tick or no tick then
call (or not) your email functionality

The ActiveX checkbox control will make all this a little easier by providing
a change event but this probably isn't what you want given your description.

To get your checkbox:

Format the required cell range using the 'Webdings' font and insert the
letter 'a' where you want a check to appear.

http://www.billlunney.com/Excel/FAQ/DisplayFAQ.ascx?ExcelFAQID=137


There are other solutions too.

--
Regards,


Bill Lunney
www.billlunney.com