How do I create list validation from code without the text being converted into date format?
I have a cell whose validation is dynamically changed. I delete and
create it from code. Some of the text that could be used is in the
format of x-y (e.g. 5-7), which sometime is converted into a date (e.g.
7-May). This happens in the Validation.Add function, which means I
can't solve it by just formatting the cell to contain Text.
|