Results 1 to 3 of 3

Thread: Excel VBA... Quick Add Note Macro

Threaded View

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Feb 2014
    Posts
    74

    Question Excel VBA... Quick Add Note Macro

    Problem: the note section of a flat database is located about 17 columns from the name of the item being looked up. The notes sometimes get placed in the wrong file and to mitigate this I need something that will be as close to fool proof as possible.

    I was thinking something simple that would take the selected cell (the item being looked up)(any cell in column C in the picture below) and through the macro a box or form would appear asking you to add a note to the file... the trick is that I do not want to erase any of the notes currently in the notes cell for that particular record; also a date stamp of when the note was entered would be much appreciated as everybody seems to use their own formatting and it gets really annoying.

    Example:
    Name:  delete200.jpg
Views: 376
Size:  32.8 KB

    Thanks for your help.
    Last edited by IGPOD; Apr 16th, 2015 at 11:29 AM. Reason: changed "not" to note in first sentence

Tags for this Thread

Posting Permissions

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



Click Here to Expand Forum to Full Width