dbmathis
Well-known Member
- Joined
- Sep 22, 2002
- Messages
- 1,064
Hi all,
Consider that I have two workbooks: book1 aand book2.
Using VBA within book1, how can I add a comment to book2 sheet1 cell D7:
Example comment --> 12/1 $2.00 Blah
Then using the same VBA if a comment already exists in cell D7 then the VBA finds the next available blank line in the comment and adds data the blank line below what was already in the comment.
Maybe this is not even possible, but I am sure you all know.
Thanks.
Consider that I have two workbooks: book1 aand book2.
Using VBA within book1, how can I add a comment to book2 sheet1 cell D7:
Example comment --> 12/1 $2.00 Blah
Then using the same VBA if a comment already exists in cell D7 then the VBA finds the next available blank line in the comment and adds data the blank line below what was already in the comment.
Maybe this is not even possible, but I am sure you all know.
Thanks.