I have a data validated cell where users can select from 5 options for the cell value. I'd like to know how I can change the cell comment based on what the users selects. I'd like to know if in doing this, I can also control the size of the comment displayed.
You'd need a Worksheet Change Event handler monitoring the cells(s) with Data Validation and, when the cell value is changed, probably lookup the DV list and return a matched comment.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks