| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell validation prefill
I do not have the Match option in the properties of the control toolbox in
Excel 2003 - does this mean I cannot type a letter or two and have the combo box auto fill? Nor do I have the font option. Are these options Excel 2007? Thanks! -- Sue |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell validation prefill
Are you sure you inserted a combobox from the Control toolbox toolbar? Or did
you use a dropdown from the Forms toolbar? Sue wrote: I do not have the Match option in the properties of the control toolbox in Excel 2003 - does this mean I cannot type a letter or two and have the combo box auto fill? Nor do I have the font option. Are these options Excel 2007? Thanks! -- Sue -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell validation prefill
I have those options in Properties of a ComboBox from Control ToolBox in 2003.
See Debra's sitr for changing the properties. http://www.contextures.on.ca/xlDataV...tml#ChangeProp Gord Dibben MS Excel MVP On Wed, 9 Apr 2008 12:06:00 -0700, Sue wrote: I do not have the Match option in the properties of the control toolbox in Excel 2003 - does this mean I cannot type a letter or two and have the combo box auto fill? Nor do I have the font option. Are these options Excel 2007? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
| Automatic cell validation prefill by entering first letter | Excel Discussion (Misc queries) | |||
| How can I prefill a text field with leading 0s? | Excel Worksheet Functions | |||
| Prefill cust info from drop list into other cells | Excel Worksheet Functions | |||
| How do I convert dollars and cents to text, and prefill the cell . | Excel Worksheet Functions | |||
Hybrid Mode
