Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pull down menus in spread sheet
I was able to make the box that i wanted the pull down menu to go into by
making sure "show developer" tab is selected.clicked developer tabcontrolsinsert combo box from the active x controlsright clicked the drop down and select properties,highlighted my list in the list fill range. And nothing happened. I can make a drop down without the box by going to dataclick data validationunder all clicked listunder source highlighted my listhit ok and all is good. Can't figure out how to combine the 2 things. Help! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
pull down menus in spread sheet
To use the combo box, it takes a little more work, but not much. In the
format control box, you put your input range in (which it sounds like you successfully did) and then place a cell link location into the Cell link box. The cell link will contain the result of the user's interaction with the box. If, for example, they choose the 4th item in the list, the number 4 will appear in your cell link. So if you chose $z$1 as your link, Z1 would now have a 4 in it. This is the number you'll need to continue with your formulas, code, or whatever. After you're done modifying the box, click the Design Mode icon to turn design mode back off again. My guess is that's the part you missed. -- Happy calculating! If you like this answer, please click ''Yes.'' "Julies?s" wrote: I was able to make the box that i wanted the pull down menu to go into by making sure "show developer" tab is selected.clicked developer tabcontrolsinsert combo box from the active x controlsright clicked the drop down and select properties,highlighted my list in the list fill range. And nothing happened. I can make a drop down without the box by going to dataclick data validationunder all clicked listunder source highlighted my listhit ok and all is good. Can't figure out how to combine the 2 things. Help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pull Down Menus | Excel Discussion (Misc queries) | |||
pull down menus | Excel Worksheet Functions | |||
hyper links in pull down menus | Excel Programming | |||
Pull down menus possible in excel? | Excel Discussion (Misc queries) | |||
how do I set up pull down menus within a cell; excel | Excel Discussion (Misc queries) |