| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| drop-down menu in an excel spreadsheet | Excel Worksheet Functions | |||
| Excel Script for Drop Down Menu | Excel Discussion (Misc queries) | |||
| Cross-referenced drop-down menu (nested drop-downs?) | Excel Worksheet Functions | |||
| How do u insert a drop down menu in a Excel | Excel Worksheet Functions | |||
| how do i create drop down menu in excel | Excel Worksheet Functions | |||
Linear Mode
