98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Comments box
Comments box
Resolved · High Priority · Version 2007
Thu 8 Apr 2010, 16:07Delegate Adrian said...
Adrian has attended:
Excel Intermediate course
Excel Advanced course
Project Intro Intermediate course
Excel Advanced course
Comments box
Does anyone know how can you link a Comments box to more than one cell. Often a comment (eg "error corrected") can apply to more than one cell, and you don't want to keep replicating or copying the same comment box each time. In essence there should be an option to "link" the Comments box to as many cells as needed. But where is it? If not, can be created?
Tue 13 Apr 2010, 10:45Trainer Nafeesa said...
RE: Comments box
Hi Adrian,
Thank you for your question regarding comments.
As I mentioned during the class I believe this is something Excel itself is unable to do, however VBA may provide the answer.
I am in conversation with a couple of collegues about this so endeavour to get an answer to you as soon as possible.
Sorry for the delay.
Have a great day.
Regards,
Nafeesa
Microsoft Office Specialist Trainer
Tue 20 Apr 2010, 11:56Trainer Stephen said...
RE: Comments box
Hi Adrian
Thanks for your question
It is indeed possible to enter comments into multiple cells using VBA code. In the code snippet below a comment is added into cell B1
Range("B2").Select
Range("B2").AddComment
Range("B2").Comment.Text Text:="This is a test"You would need to modify this and place it within a loop so that it repeats it for each cell. The skills to do this are covered on the VBA introduction course.
Regards
Stephen
Tue 27 Apr 2010: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Formst Excel to display leading zeroesSelect the cells that you want to have displaying leading zeroes. |
