Insert Comment Macro needed
Insert Comment Macro needed
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Insert Comment Macro needed

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    rejdus@hotmail.com
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have an invoice sheet.
    In the cell I4 i have a heading JobDetails.
    What I need now is
    in next cells bellowI4: I5 I6 I7 ...TO INSERT A COMMENT BOX wheer i can type description of the job. I need to write a macro so it will open automatically while iam entering new invoice and move my cursor to the following cell.
    I hope this is possible and explains fully wot i am looking for.
    Plz could any1 suggest something.
    (if required i can send this part of the project via attachment in email,please)

    Big up London City

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Do a search on this site for "insert comment", this problem is well documented.
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi

    If you want a code tha adds a cool comment ie clods or some other than boaring box to the active cell on command button please email me on my profile and ill email you it or ask for sheet set up if you want and ill mail it to you, all you do is ckick and edit the data reqd, get you started and loads of guys have had this code.

    PLEASE i do request if i supply the code you post it on this feed so everyomne can see itm i dont have much of my VBA stuff at home and ill forget.

    Im sure you understand!

    A big thanks

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com