Adding Dynamic Tool-Tips whose Text is Based on the contents of the cell using a MACRO..

[e4excel]

Adding Dynamic Tool-Tips whose Text is Based on the contents of the cell using a MACRO..

Dear Forum,

I was recently helped by Artik_PL in getting Dynamic Comments whose text was based on the Target cell which worked brilliantly but due to some reasons we would like to go with Tool-Tips with the same functionality as in the Dynamics of keeping the Text flexible remains the same however the mode of display changes now instead of Comments..

http://www.excelforum.com/excel-prog...g-a-macro.html

For reference I have added the previous query..however this time I would like to want this to show up as Tool-Tip..
One more thing if this can be modified would be great, as I m not so good in VBA unable to do so..

This file which I'm uploading is just a Dummy File for representation but in my actual file i need this to be used in two different sheets with different columns and different Start and End Row nos, so how can this be made in such a way that i can simply call this as a Sub-Routine providing different Ranges as the Data to be displayed and the other Data Fetching Sheets Remain the same..

Thanks in advance..

Warm Regards
e4excel

[e4excel]

The code for the Tool-Tip:

Please Login or Register  to view this content.

The code below for getting the VLOOKUP text based on the cell content: in the COmment style..

Please Login or Register  to view this content.

The codes above need to be merged so as to get the best of both..


Thanks in advance

[mikerickson]

You can do this with a UDF.

Please Login or Register  to view this content.

The ValidationValues function will take values from formula and put the result as the message (or title) of a Validation Input Message.
The cell that gets the "tool tip" can be specified with the ActingOnCell argument.

If you have names in column A and amounts in column B, putting this in D17
=ValidationValues("Select Me for Maximum info",MAX(B17:B19), INDEX(A17:A19,MATCH(MAX(B17:B19),B17:B19,0),1))
will put the maximum value from column B and the matching name from column A into the "tool tip" of D17. (This will change as the data in A17:B19 change)

Putting this formula in D18, will put the min value and matching name as the tool tip of E18
=ValidationValues("Minmum Info >>>",MIN(B17:B19), INDEX(A17:A19,MATCH(MIN(B17:B19),B17:B19,0),1), E18)

You would just have to alter the formulas used to calculate the arguments to meet your situation.

[e4excel]

Dear Mike,

Extremely sorry for responding so late..I tried to reply but every time I did my net was so slow that the replies did not get posted..

Anyways thanks a lot for the help, but honestly I have not been able to actually understand as to how I can use it my scenario..
What I am looking for is that certain cells in a specified fixed column would randomly contain a few unique values which are like Primary Id in the Two Columns Insurance-I and Mutual Fund-M so that these unique values act as Lookup-Values and pull the other details in those tables from different worksheets..

Now as you can see i have received help already in getting them into comments but need to get the same in the Tool-Tip and also more importantly I need to get them as a Sub-Routine like I can pass the Range in the other code where I will be using it as my range starts and ends at different Row Numbers and has variable length or Row-height..

Please explain as this is slightly difficult for me to understand..

Thanks in advance

Warm Regards
e4excel

[e4excel]

Dear Mike,

Can u please advise as to how I go about using your solution and also if that can be Sub-Routined for different ranges..
My main was to get it in comments but later on it was decided to go with Tool-Tips..

Now that I have got help for Tool-Tips how do I tweak it to the specified ranges?

Thanks in advance

Warm Regards
e4excel