ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cell validation prefill (https://www.excelbanter.com/excel-discussion-misc-queries/183107-cell-validation-prefill.html)

Sue

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

Dave Peterson

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

Gord Dibben

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!




All times are GMT +1. The time now is 07:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com