S
Sky
Is there a way in a worksheet to tie a combobox based on a list range
to a specific cell data entry and use the autoexpand property which MS
Access and Outlook use, ie (quoted from MS help):
"You can use the AutoExpand property to specify whether Microsoft
Access automatically fills the text box portion of a combo box with a
value from the combo box list that matches the characters you enter as
you type in the combo box. This lets you quickly enter an existing
value in a combo box without displaying the list box portion of the
combo box."
I found the validation feature in Excel, but it doesn't jump to the
closest match like the autoexpand. Would I need to use some VBA code
or is it built in?
to a specific cell data entry and use the autoexpand property which MS
Access and Outlook use, ie (quoted from MS help):
"You can use the AutoExpand property to specify whether Microsoft
Access automatically fills the text box portion of a combo box with a
value from the combo box list that matches the characters you enter as
you type in the combo box. This lets you quickly enter an existing
value in a combo box without displaying the list box portion of the
combo box."
I found the validation feature in Excel, but it doesn't jump to the
closest match like the autoexpand. Would I need to use some VBA code
or is it built in?