What I want to do is for when the user selects a cell, a combo box based on
the field name pops up for better viewing and autocomplete, after a couple of
keystrokes the selection is complete and a {Tab} or {Enter} key will populate
the cell and it will be validated and move to the next cell. I have the data
validation and movement working OK but the ComboBox is driving me batty.

The data validation formula is ="=INDIRECT(VLookup(" & Place & ", lookup1,
2))" Where place is the Field title. This works in Data validation, but when
I try to place in a combobox, I continue to get the formula in text form and
not the value (name of the validation list) that I need.

Anyone have sugestions?

--
Glen