Excel Drop Down Menu linked?

[Guest]

Excel Drop Down Menu linked?

I have 12 worksheets which represent each month of the year. Being in
January (or any other month), I would like to use a Drop Down Menu which
would link me to any other month. Is is possible?
Could you guys guide me please.

Is there any way I can use VB's drop down menu?
I would use it if I have to.
I am not that good at Vb, but I am willing to learn.

Thanks.

 

[MartinW]

Hi,

If by linked you mean that you want to step to another month,
then Excel already has one built in. Just right click on the
navigation arrows at the bottom left of your screen.

HTH
Martin

 

[Guest]

Hi Martin,
thank you, but I would like to know another way besides the navigation
arrows at the bottom left of my screen.

Regards.

 

[Guest]

Hi Martin,
thank you, but I would like to know another way besides the navigation
arrows at the bottom left of my screen.

Regards.

 

[MartinW]

Did you read my post properly. I didn't say to use the
navigation arrows, I said to right click on them.
It brings up a dropdown menu (or fly-up menu in this case)
just as you asked.

HTH
Martin

 

[Guest]

Im so sorry Martin,
Thank you for your help. I did not read yor post properly.
Thank you. That will work.

Now, I am curious, is there any other way to do it?
How would I do it?
Do you guys know any good tutorial available about my curiosity?

Regards.

 

[MartinW]

No need to apologise,

Check out Debra Dalgleish's site http://www.contextures.com/tiptech.html
Look under N for Navigation toolbar.

You'll also find enough other stuff there to keep your curiosity sated
for quite a while.

Regards
Martin