Using a checkbox to trigger an email

  • Thread starter Thread starter Chris
  • Start date Start date
C

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
 
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
 
Back
Top