brockk
Board Regular
- Joined
- Jul 1, 2006
- Messages
- 170
- Office Version
- 2013
- Platform
- Web
Greetings and Happy Holidays Excel Gurus,
I am trying to achieve something I feel is way over my head as I am a total nube in VBA. I have a sales dashboard with several KPI's (6 in total). Each are represented by a rectangular object. Each object has a default color of a Black background with Magenta Text; and I would like it to be user friendly and to somewhat impress my boss. I have the need to be able to assign 2 macros to each of the objects, that is, if this can't be done all in one UDF. This is what I am trying to accomplish with the macro(s):
1- I would like it to change the colors of the active object in reverse ( to Background in Magenta with text being black) when HOVERING OVER the object while all others remain in tact, and once its not hovered over for it to go back to its default colors of Background in black and text in Magenta. This is the part that has me mentally challenged.
2- I would like to LINK it to other worksheets if the active object is CLICKED. (This part I think I can manage on my own if it can't all be done in one UDF as it may require individual macros.)
KPI links in the workbook are: Sales, UPT, DPT, APC, Max_Base, Attach. Hope this helps. Thanks in advance for any help that can be given.
I am trying to achieve something I feel is way over my head as I am a total nube in VBA. I have a sales dashboard with several KPI's (6 in total). Each are represented by a rectangular object. Each object has a default color of a Black background with Magenta Text; and I would like it to be user friendly and to somewhat impress my boss. I have the need to be able to assign 2 macros to each of the objects, that is, if this can't be done all in one UDF. This is what I am trying to accomplish with the macro(s):
1- I would like it to change the colors of the active object in reverse ( to Background in Magenta with text being black) when HOVERING OVER the object while all others remain in tact, and once its not hovered over for it to go back to its default colors of Background in black and text in Magenta. This is the part that has me mentally challenged.
2- I would like to LINK it to other worksheets if the active object is CLICKED. (This part I think I can manage on my own if it can't all be done in one UDF as it may require individual macros.)
KPI links in the workbook are: Sales, UPT, DPT, APC, Max_Base, Attach. Hope this helps. Thanks in advance for any help that can be given.