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?
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
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
