Create popups when mouse hovers over cell
Hello to all kindly help me i'm newbie in macros please help me out. I want popup for certain fields which display certain values for that..
for ex
A1 contains Jan
A2 contains Feb
A3 contains Mar
what i want is to show popup if i move my mouse on A1 - JAN it shows A1,A2,A3,A4 etc
same goes with other fields
anyone please help me out.
Thanks in advance
Last edited by JBeaucaire; 02-23-2013 at 06:41 AM. Reason: Corrected thread title
You can insert COMMENTS into A1 with the popup text you want to see when you hover your mouse over it.
Right-click the cell and select Insert Comment.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Originally Posted by JBeaucaire
thanks for your reply mate but i've to fetch cell data from another sheet in which single field contains A,B,C,D values
i'm using =LinkComment(B1,C1) but this fetch only single field
thanks a lot my query resolved
I have marked this thread solved for you.
In the future please select Thread Tools from the menu above and mark the thread as solved. Thanks.
LinkComment function available in which version of excel ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks