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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing Excel formats in VBA date variables
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing Excel formats in VBA date variables
If I want to format it do I use a format function or a format method o
the vba variable -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing Excel formats in VBA date variables
Yes, you would use the format function when you wanted to show the date as a string. eg. Sub test() Dim dtmTemp As Date dtmTemp = Now() MsgBox dtmTemp 'automatically formats as defined by regional settings MsgBox Format(dtmTemp, "dd-Mmm-yyyy HH:mm") End Sub -- Rob van Gelder - http://www.vangelder.co.nz/excel "ExcelMonkey " wrote in message ... If I want to format it do I use a format function or a format method on the vba variable? --- Message posted from http://www.ExcelForum.com/ |
Reply |
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 |