+ Reply to Thread
Results 1 to 3 of 3

Add Note Button

  1. #1
    Registered User
    Join Date
    10-15-2015
    Location
    Huntington Beach, CA
    MS-Off Ver
    2016
    Posts
    14

    Add Note Button

    Hi All,

    So I told my boss I was good at Excel... And now he expects me to generate this planner for him. I'm close, but cannot seem to write the correct code for the button.

    In the attached spreadsheet I want to generate simple notes by the click of a button, while also time stamping the note.

    For example, The Word in C1, "pop" should appear in C3; along with a time stamp in D3. The cell C1 should then be cleared. Upon additional notes, I'd like them to be stored below, so C4, C5, C6...

    (I'd like to have an identical format and button on each new sheet I create)

    Thanks for the help guys. This is the best learning tool I've found so far for Excel VBA.

    Gblack686DGA Add Note ButtonExcel Help .xlsm

  2. #2
    Valued Forum Contributor Gatti's Avatar
    Join Date
    06-08-2015
    Location
    Brasil, São Paulo, Ribeirão Preto
    MS-Off Ver
    365
    Posts
    346

    Re: Add Note Button

    Well... some advices:

    Start recording the macros exactly how you want and what you want them to do
    Check them and debug the code one by one (pressing F8)
    Try to replace the "Activate", "Select", "Selection" stuff with the object itself

    Another advice: do the macros on a Module... not inside Worksheet Page (instead you are doing a worksheet event), and try not to use ActiveX objects in Worksheet... use the other kind of objects

    Anyway, this time I'll keep your button and the event into the Worksheet Page

    Try this:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    10-15-2015
    Location
    Huntington Beach, CA
    MS-Off Ver
    2016
    Posts
    14

    Re: Add Note Button

    Gatti,

    That code worked great for my first sheet. However, when I tried to copy it over to my next sheet an error popped up saying something like "Cannot run macro, because they are either disabled or not found in open workbooks."

    This is weird because the button still works on the first sheet, so the macro is still active. I changed the sheet name in the code correctly for the new sheet, and enabled macros in Trust Center Settings (maybe not a good idea). I also changed the code from private sub to sub.

    Need a bit of help troubleshooting this. The new file is attached.

    Thanks!
    GBDGA Add Note ButtonExcel Help .xlsm

+ 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. Find Email in Lotus Note and export its content to Excel (VBA & Lotus Note)
    By mortphil in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-21-2014, 05:53 AM
  2. Credit note log
    By Phil Walters in forum Excel General
    Replies: 19
    Last Post: 09-23-2010, 09:44 AM
  3. Replies: 1
    Last Post: 04-12-2007, 09:33 PM
  4. Note to Admin
    By Sweetie in forum Excel General
    Replies: 0
    Last Post: 05-26-2006, 07:27 PM
  5. I want to insert a note
    By Sam in forum Excel General
    Replies: 3
    Last Post: 11-23-2005, 07:10 AM
  6. [SOLVED] How can I return a thank you note
    By Cactus in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2005, 12:05 AM
  7. [SOLVED] How can I return a thank you note
    By Cactus in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-05-2005, 11:05 PM
  8. On a PDF Note --- Check this out..
    By BigT in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-31-2005, 03:06 PM

Tags for this Thread

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