+ Reply to Thread
Results 1 to 3 of 3

Checkbox code for email and timestamp

  1. #1
    Registered User
    Join Date
    03-25-2020
    Location
    new york
    MS-Off Ver
    google drive
    Posts
    2

    Question Checkbox code for email and timestamp

    Can someone help me with a code for a checkbox. I need it to send a blanket email (to the same internal emails) AND put a date/time stamp in the cell next to it. I was able to get the date/time and make an email button, but I can't get them to work together. Id rather not have the button at all. I'm using google sheets on a chrome book.

    Thanks for the help
    Last edited by Pepe Le Mokko; 03-26-2020 at 03:31 AM. Reason: Title shortened. We know you need help

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Help Please! Checkbox code for email and timestamp

    Doesn't Google Sheets use GAS (Google Apps Script) instead of VBA ? I was under the impression that VBA is not compatible with Google Sheets.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  3. #3
    Registered User
    Join Date
    03-25-2020
    Location
    new york
    MS-Off Ver
    google drive
    Posts
    2

    Re: Checkbox code for email and timestamp

    Right, it does use Google App Script. I was just hopeful that someone knew how to make it work

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA Code to email multiple people and code to go to the next email if error occurs
    By pmeltzers in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-17-2018, 12:31 PM
  2. [SOLVED] Checkbox to deselect another checkbox, shorter code
    By JamesT1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-27-2013, 09:59 AM
  3. [SOLVED] VBA code to uncheck checkbox 2 & 3 if checkbox 1 is checked
    By hydz1213 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-25-2013, 03:10 AM
  4. [SOLVED] How do I change a checkbox to unchecked without running the code within the checkbox
    By jsunnb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-27-2012, 09:28 PM
  5. Checkbox to trigger email via CDO
    By killersoap in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-21-2011, 05:47 PM
  6. Static Timestamp linked to checkbox
    By ChipPA in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-26-2007, 10:30 AM
  7. Code for a timestamp.
    By Zirus in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-15-2007, 01:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1