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 Mike Lewis 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
0
0
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