Consulting

Results 1 to 2 of 2

Thread: Simple Macro to add Comments

  1. 01-27-2008, 06:36 AM #1
    ssinghal
    ssinghal is offline
    VBAX Regular
    Joined
    Jan 2007
    Posts
    28
    Location

    Simple Macro to add Comments

    I want to have a macro that will simply copy the text in the current cell to a comment in that same cell. Can someone help me out?

    Thanks,

    Sanjeev
    Reply With Quote Reply With Quote
  2. 01-27-2008, 07:41 AM #2
    Carl A
    Carl A is offline
    VBAX Tutor
    Joined
    Dec 2006
    Posts
    220
    Location
    [VBA]Range("A1").Comment.Text Text:=Range("A1").Text[/VBA]
    "Intellectual passion occurs at the intersection of fact and implication."

    SGB
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules