Hello, I am trying to use a combo box to autocomplete validated lists in a worksheet. I have included a macro which works well with text, however there is a problem when the combo box is used to autocomplete list of dates. How can I make sure that the combo box works for both the lists of text and the list of dates?
Solved by G. H. in 15 mins