Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Combobox Affix to Cell
Hello. Is there a way to affix ComboBox from the forms toolbar to a given
cell? |
#2
|
|||
|
|||
The Dropdown/combobox from the Forms toolbar floats over the worksheet
cells--just like every other shape. But if you put the dropdown completely in the cell, you can right click on it, then choose Format|Control|properties tab and make sure "Move but don't size with cells" is checked. Have you thought about using Data|Validation? It might be easier to get what you want done. Debra Dalgleish has some nice notes about data|validation at: http://www.contextures.com/xlDataVal01.html D.Parker wrote: Hello. Is there a way to affix ComboBox from the forms toolbar to a given cell? -- Dave Peterson |
#3
|
|||
|
|||
Thank you very much David!
"Dave Peterson" wrote: The Dropdown/combobox from the Forms toolbar floats over the worksheet cells--just like every other shape. But if you put the dropdown completely in the cell, you can right click on it, then choose Format|Control|properties tab and make sure "Move but don't size with cells" is checked. Have you thought about using Data|Validation? It might be easier to get what you want done. Debra Dalgleish has some nice notes about data|validation at: http://www.contextures.com/xlDataVal01.html D.Parker wrote: Hello. Is there a way to affix ComboBox from the forms toolbar to a given cell? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create a variable column in cell reference | Excel Worksheet Functions | |||
How can I get a cell locked if the condition is false? | Excel Worksheet Functions | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |