Hi,
I don't know if it is possible to do what I want but I will ask anyway.
On my spreadsheet I have a column with dropdown boxes. Users can select Tier 1,2,3 or N/A for that column. What I want is an instruction box that tells them what those Tiers represent so that they know which one to pick. Ideally I would like that explanation box to appear when they hover the mouse over cells in that column.
If further explanation is needed, please ask!
Thanks in advance
I don't have Excel 2010 here at the moment, but in later versions you can add a comment to the cell which appears on hover: right click and add comment. I think it's in 2010 as well.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
The ability to add comments to cells has been in most versions of excel, i think to at least 2000
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks... I guess I was thinking that there was a function that was different to the comments function. But that works just as well and is simple to use so I'll use that.
Cheers
Glad you got this resolved and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks