Can I accomplish multiple objectives using VBA in a dashboard (1) hovering over objects (2) upon clicking objects

[brockk]

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.

 

[bebo021999]

Pls post screenshot / worksheet by XL2BB (or image at least)

 

[brockk]

Greetings! In the attahced photo will show what I am trying to accomplish. These are the 6 KPI objects and what effect I want to achieve. Among the 6 objects given, if you HOVER over it I would like it to invert the colors of both the background, as well as, the color of the text. Then if he CLICKS on it, I would like it to Hyperlink/Link to its corresponding named worksheet. HTH.

 

[Jaafar Tribak]

The thing is, shapes do not have a mouse move event so trapping the hover operation is not possible

There are some workarounds one of them is by using ActiveX commandbuttons instead of shapes. Another workaround is by keeping the shape but placing it within a transparent ActiveX label so the label can intercept the mouse hover before reaching the shape.

You should be able to find some code examples on this site if you do a search.