Ok. haha.
So, I have two sheets in this workbook that I am playing with.
I put a date, Thursday, December 15, 2005, in Sheet1 and cell A1.
I put a combobox on sheet two.
In the combobox properties, I populate the ListFillRange with 'shee
1'!A1
When I pull the menu down, the date shows properly. When I click it an
the combobox collapses again, a numerical value of 38701 shows up. An
thoughts?
Thank you,
Barr
--
Barry Clar
-----------------------------------------------------------------------
Barry Clark's Profile:
http://www.excelforum.com/member.php...fo&userid=3526
View this thread:
http://www.excelforum.com/showthread.php?threadid=55102