Typing in a Combo Box
 

I have a worksheet that I have created some Combo boxes
on. They call to other worksheets in the same workbook. I
need to have the ability to type in text that is not
present in the table that my combo box calls from. It
would be GREAT if there was a way to update the table
with the text that was typed in also, but I would just
for now be happy with the ability to type in free form
text.
I am very frustrated and lost and do NOT know VBA. PLEASE
HELP ME!!! Thank you VERY VERY VERY much!!

Typing in a Combo Box
 

What type of combobox - from the control toolbox toolbar? Then you can go
into the properties

Style should be fmStyleDropDownCombo (value is zero)

MatchRequired property should be False

Those settings allow you to enter a value by typing it in and it doesn't
have to match the list.

--
Regards,
Tom Ogilvy

"Matt" wrote in message
...
I have a worksheet that I have created some Combo boxes
on. They call to other worksheets in the same workbook. I
need to have the ability to type in text that is not
present in the table that my combo box calls from. It
would be GREAT if there was a way to update the table
with the text that was typed in also, but I would just
for now be happy with the ability to type in free form
text.
I am very frustrated and lost and do NOT know VBA. PLEASE
HELP ME!!! Thank you VERY VERY VERY much!!