Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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

excelmacros-vba
MS Office Version: 2016
posted by: Carlo (rep: 6) on Tue Jul 20, 2021 at 8:57 pm
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: 6142) 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: 4889) 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: 6) Jul 21, '21 at 8:59 pm
Variatus.

I'm gonna try your suggestion.

Thank you
Carlo (rep: 6) 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