MrExcel Publishing
Your One Stop for Excel Tips & Solutions

combo box write in option


Posted by Ania on January 11, 2002 9:10 AM

in forms, is there a way to leave a blank cell in the source for the combo box for the case when none of the options provided in the box match the user's answer to a question, which would allow the entry of data?
thanks


Posted by Juan Pablo G. on January 11, 2002 9:20 AM

One way to go would be with formatting, format the cell as

0;-0;

Juan Pablo G.

Posted by Ania on January 11, 2002 9:31 AM

i am not exactly sure what you mean. can you please explain?
thanks

Posted by Juan Pablo G. on January 11, 2002 9:40 AM

Wait... now i'm not sure what you have. What kind of ComboBox are you using ? where is it placed ? is it linked to a cell ?

Juan Pablo G.

Posted by Ania on January 11, 2002 9:43 AM

i am not exactly sure what you mean. can you please explain?
thanks

Posted by Ania on January 11, 2002 10:25 AM

i am not exactly sure what you mean. can you please explain?
thanks

Posted by Juan Pablo G. on January 11, 2002 10:38 AM

Wait... now i'm not sure what you have. What kind of ComboBox are you using ? where is it placed ? is it linked to a cell ?

Juan Pablo G.

Posted by Ania on January 11, 2002 12:13 PM

the combo box is in an excel form. it has a source on a separate "code" worksheet and linked to a cell in a worksheet. then it is used in formulas and other excel forms.
the problem is i am not sure how to enable the user to type in information into the drop box without giving the access to the "code" worksheet.

Posted by Juan Pablo G. on January 11, 2002 3:19 PM

I think i understand what you mean. Basically you want a ComboBox that also acts as a TextBox, right ? user can choose, but he can type whatever he want as well.

Well, this can be done with the "other" comboboxes, the one from the Control toolbar, and setting the property "MatchRequired" to 2 (MatchEntryNone). That way, it'll act as a ComboBox but the user can still type what he needs.

Juan Pablo G.