Assign macro to Excel Symbols

0

Hi all

I need some help. Here's the situation:

GOAL

Assign macro to Excel Symbols in Header of monthly evaluation report(See picture).

CONTEXT

- Excel Symbols(Wingdings 3) Left arrow(C3), Right arrow(E3) will be used as Time navigator. NO SHAPES or BUTTON.

- Down arrow(L3) will be used to transfer Data from Month Table in sheet "Month 1"  to master Table in sheet "MasterData".

QUESTION

1. Can I avoid shapes or macro button?

2. What formula or code would be best for the "Time arrows" ?

Any suggestion will be appreciated.

Regards

Carlo

Answer
Discuss

Discussion

Carlo

You say "...(See picture)" but we can't- you can only attach Excel files to your Question.

The constraint "NO SHAPES or BUTTON" makes your question feel like a schoolwork exercise (since in business a working solution is often the sole goal, such a constraint wouldn't be imposed to prevent that). What's the origin of your constraint please?
John_Ru (rep: 1557) Jul 21, '21 at 3:23 am
Look at the Selection_Change event. The Target (clicked-on cell) can be examined as to the characters it contains which, therefore and thereby, can be made to function like buttons.
Variatus (rep: 4864) Jul 21, '21 at 9:06 am
John

I forgot I could lock the Shapes. I wanted to try something that won't move...

Thank you.
Carlo (rep: 2) Jul 21, '21 at 8:59 pm
Variatus.

I'm gonna try your suggestion.

Thank you
Carlo (rep: 2) Jul 21, '21 at 9:01 pm
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login