Assume cells a1:a3 the rowsource for LISTBOX1 contain
01/01/2008
02/01/2008
03/01/2008
I can code-
userform1.listbox1.value=range("a2").value
This wokks just fine.
If, however, I change the format of cells a1:a3 to a date format, the above
code will now fail. The failure also holds true if I use text instead of
value in the above line of code. The failure persists with any formatting
other than "General".
Any suggestions would be appreciated. I want to show my user a formatted
date, not a date serial number.
Thanks.