Excel Drop Down Menu linked?
 

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.

Excel Drop Down Menu linked?
 

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


"Willing to learn" wrote in
message ...
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.

Excel Drop Down Menu linked?
 

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" wrote:

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


"Willing to learn" wrote in
message ...
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.

Excel Drop Down Menu linked?
 

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" wrote:

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


"Willing to learn" wrote in
message ...
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.

Excel Drop Down Menu linked?
 

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


"Willing to learn" wrote in
message ...
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" wrote:

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


"Willing to learn" wrote in
message ...
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.

Excel Drop Down Menu linked?
 

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" wrote:

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


"Willing to learn" wrote in
message ...
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" wrote:

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


"Willing to learn" wrote in
message ...
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.

Excel Drop Down Menu linked?
 

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



"Willing to learn" wrote in
message ...
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" wrote:

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


"Willing to learn" wrote in
message ...
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" wrote:

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


"Willing to learn" wrote in
message ...
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.