I have been beating at this all day. Have a data validation cell, say C13, and the validation data on a different sheet. Everything is pretty much working, it can search the array just fine, except if I click in the C13 and enter a couple letters to search, the pull down does nothing. But, if I click to another cell, and then back to C13, I can pull down the arrow and see the appropriate filtered results. I made other simplified test cases and works fine. Difference here, perhaps, is I have a clear macro using "Selection.ClearContents" to clear C13 along with other fields. I am also using "Worksheet_Change(ByVal Target As Range)" on that C13 cell and using VBA to fill some other fields from that array when a data base selection is chosen (that part seems to work also). It's just the focus issue on C13 that has my dander up. Thanks for reading.
Jed
Jed