PC Review


Reply
Thread Tools Rate Thread

Cell validation prefill

 
 
Sue
Guest
Posts: n/a
 
      9th Apr 2008
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
 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      9th Apr 2008
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
 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      9th Apr 2008
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 <(E-Mail Removed)> 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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Validation -> Validation list is larger than the cell width Barb Reinhardt Microsoft Excel Programming 1 4th Mar 2010 08:24 PM
Validation Data using Validation Table cell range..... =?Utf-8?B?RGVybW90?= Microsoft Excel Misc 16 5th Jan 2010 09:35 PM
Automatic cell validation prefill by entering first letter =?Utf-8?B?SkI=?= Microsoft Excel Misc 4 11th Apr 2007 06:48 PM
Custom Column Validation or DataGrid Cell Validation Stanislav Nedelchev Microsoft ADO .NET 0 15th Dec 2005 10:28 AM
How do I convert dollars and cents to text, and prefill the cell . =?Utf-8?B?SmFuIEJ1Y2tsZXk=?= Microsoft Excel Worksheet Functions 1 20th Jan 2005 07:22 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:58 AM.