over-ride combo box

marley · Mar 19th, 2002, 05:50 PM

I have an quote request form that my customers can fill out. much of the form is combo lists that I have predetermined the content. I need to know if there is a way for the customer to over-ride the combo box and type their own entry into the box if the choice they desire is not in my predetermined database.
p.s. I am using MAC OS9 if that makes a difference.

Juan Pablo González · Mar 19th, 2002, 09:04 PM

If you're using a Control Toolbar ComboBox, you can set the MatchRequired to FALSE.

If you're using a Forms Toolbar ComboBox, don't know if it's possible.

If you're using Data Validation, just UNCHECK the Show Error in the third tab.

marley · Mar 20th, 2002, 08:24 AM

Thanks, I'll try those options. I am, in fact, using a Forms ComboBox, so this gives me two more options to attempt.

Dave Hawley · Mar 20th, 2002, 08:39 AM

Hi Marley

Not sure if it would be an option, but have thought about using a Validation list?

Or, if you stick with the Forms ComboBox you could use a Dynamic range and have new entries added straight to that range, which would then incorporate the new entry as part of the CombBox "Input Range:"

http://www.ozgrid.com/Excel/DynamicRanges.htm

marley · Mar 20th, 2002, 09:17 AM

I have swithced from a Forms Toolbar ComboBox to the DataValidation and UNCHECKED the show Error and it is working perfectly. This website is absolutely priceless. Thank you all who participate.

Mar 19th, 2002, 09:04 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	If you're using a Control Toolbar ComboBox, you can set the MatchRequired to FALSE. If you're using a Forms Toolbar ComboBox, don't know if it's possible. If you're using Data Validation, just UNCHECK the Show Error in the third tab. __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 19th, 2002, 05:50 PM	#1
marley Board Regular Join Date: Mar 2002 Location: tucson Posts: 94	I have an quote request form that my customers can fill out. much of the form is combo lists that I have predetermined the content. I need to know if there is a way for the customer to over-ride the combo box and type their own entry into the box if the choice they desire is not in my predetermined database. p.s. I am using MAC OS9 if that makes a difference.

Mar 20th, 2002, 08:24 AM	#3
marley Board Regular Join Date: Mar 2002 Location: tucson Posts: 94	Thanks, I'll try those options. I am, in fact, using a Forms ComboBox, so this gives me two more options to attempt.

Mar 20th, 2002, 08:39 AM	#4
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Marley Not sure if it would be an option, but have thought about using a Validation list? Or, if you stick with the Forms ComboBox you could use a Dynamic range and have new entries added straight to that range, which would then incorporate the new entry as part of the CombBox "Input Range:" http://www.ozgrid.com/Excel/DynamicRanges.htm

Mar 20th, 2002, 09:17 AM	#5
marley Board Regular Join Date: Mar 2002 Location: tucson Posts: 94	I have swithced from a Forms Toolbar ComboBox to the DataValidation and UNCHECKED the show Error and it is working perfectly. This website is absolutely priceless. Thank you all who participate.