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.

Don't know if this will be what you want, but we can force a cell to
become text by putting an apostrophe in front. This becomes invisible
in the cell.
eg.
'- put an apostrophe to force cell to text
Range("A1").Value = "'" & "5-7"


--
BrianB


------------------------------------------------------------------------
BrianB's Profile: http://www.excelforum.com/member.php...info&userid=55
View this thread: http://www.excelforum.com/showthread...hreadid=487878

Thanks, Brian, it is a progress. The problem is that I see the
apostrophe in the dropdown, before the value...