Excel VBA Solution to Add Comment

Microsoft Office excel 2007 - upgrade
January 21, 2011 at 11:20:40
Specs: Windows 7
I have inherited an 800 row spreadsheet. I would like help with a VBA solution that allows taking the content of the active cell, copying it to a comment that is then insert that comment in the row above the cell adn deltele the orginal text in the active cell.

See More: Excel VBA Solution to Add Comment

January 22, 2011 at 19:35:38
re: "I would like help with a VBA solution"

Do you want help with something you already have tried or are you asking us to provide a solution?

Is there a specific column that you want this to happen in or do you want it happen anywhere and everywhere you select a cell?

Do you want it to be "automatic" i.e. create the comment as soon as you select a cell, or do you want to the option to run the macro only when you choose to?

Keep in mind that we can't see your spreadsheet from where we're sitting so you have to be specific about what you are trying to accomplish.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question