Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing Excel formats in VBA date variables
I have a start date in my spreadsheet model that is formatted as follow
(m/d/yyyy h:mm). I have named the cell "xlStartDate" I have a VB variable that is called StartDate. I pass the excel variable to th 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA - passing Variables to subroutines | Excel Discussion (Misc queries) | |||
Passing Variables | Excel Discussion (Misc queries) | |||
VBA passing variables through a function | Excel Discussion (Misc queries) | |||
Passing Variables | Excel Programming | |||
passing variables from excel to word | Excel Programming |