Posted to microsoft.public.excel.programming

external usenet poster

Posts: 46

how to add text to a comment in VBA

I have a two column table on sheet2. The first column contains cell
addresses and the second are text notes. I want to loop through the cell
address and locate that address on sheet1 and place the text in a comment. I
can do this, but there are cell address that are the same. I want the text
for each to be on a new line in the same comment object.

Can anyone help with this?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Comment Text	jwfothergill	Excel Discussion (Misc queries)	2	August 4th 09 05:27 PM
Text from a comment box into a cell	MFS	Excel Worksheet Functions	3	May 8th 09 08:43 PM
Excel Comment Text Box	Gary''s Student	Excel Discussion (Misc queries)	0	January 10th 07 01:15 AM
Comment Text Promt	Rob Hargreaves[_2_]	Excel Programming	1	June 11th 05 09:05 PM
Fecthing comment text	Shilps[_2_]	Excel Programming	3	October 29th 04 01:52 PM

All times are GMT +1. The time now is 01:45 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us