MrExcel(s)
I'm stuck and need some help. I need to change the tooltip of a cell dynamically based on the contents and I'm struggling with this. I'll give you a example
I've 2 Sheets- Sheet A and Sheet B
Sheet A has a column Product with a dropdown
Sheet B has more details of the products like
A001 - Brakes
A002 - Headlights
A003 - Wipers
If the user selects or hovers on A001 in the dropdown the tool tip should display Brakes.
(It is fine if the tooltip is displayed after the selection is made as long as it changes dynamically based on the contents)
Is this too much to ask from excel?
I know how to set static tooltip using the Data Validation, but this is not something that will help me for obvious reasons.
Regards
Paresh
I'm stuck and need some help. I need to change the tooltip of a cell dynamically based on the contents and I'm struggling with this. I'll give you a example
I've 2 Sheets- Sheet A and Sheet B
Sheet A has a column Product with a dropdown
Sheet B has more details of the products like
A001 - Brakes
A002 - Headlights
A003 - Wipers
If the user selects or hovers on A001 in the dropdown the tool tip should display Brakes.
(It is fine if the tooltip is displayed after the selection is made as long as it changes dynamically based on the contents)
Is this too much to ask from excel?
I know how to set static tooltip using the Data Validation, but this is not something that will help me for obvious reasons.
Regards
Paresh