Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Comments Boxes

Status
Not open for further replies.

FJAY

Programmer
Apr 23, 2003
106
CA
Good Afternoon - I have a workbook with about 30 worksheets. Each worksheets have numerous comments in it. When I created the comments boxes that sized to specific width and lenght based on the text contents. But, for some reason the comments boxes seems to have a mind of their own and shrink or stretch too long. How do I fix this? Thanks.
 
Maybe when you created the comment with something filtered? Usually when I added a comment for a specific cell, I would make sure Auto filter is NOT ON. This way, I would know where the comment is referencing the exact cell position instead of being streth out.

Zabrina from the SF BayARea
Just another humble analyst & VBA newbie~
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top