ExcelMonkey,
StartDate is just a date variable. It contains a date and that's all - no
formatting.
The format in the tooltip you're seeing is a format defined by your regional
settings.
--
Rob van Gelder -
http://www.vangelder.co.nz/excel
"ExcelMonkey " wrote in message
...
I have a start date in my spreadsheet model that is formatted as follows
(m/d/yyyy h:mm). I have named the cell "xlStartDate" I have a VBA
variable that is called StartDate. I pass the excel variable to the
vba variable
Dim StartDate As Date
StartDate = Range("xlStartDate")
When I put my cursor over teh StartDate varible it says 01/01/2004.
Why does it not have the formatting of m/d/yyyy h:mm?
---
Message posted from http://www.ExcelForum.com/