Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
am trying to convert date info into it's serial date value with following
code (month and year provided by user): acctmon = Application.InputBox("Please enter month value between 1 and 12", "Enter month", Month(Now), , , , , 1) acctyr = Application.InputBox("Please enter year", "Enter year", Year(Now), , , , , 1) Dim date As Integer date = Application.DateSerial(acctyr, acctmon, 1) however, get the error message: run-time error '438': object doesn't support this property or method what does this mean, and what do i have to do to return a serial value? (is there another function i can use to accomplish this?) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Recreating the DateSerial()/Date() function | Excel Worksheet Functions | |||
DateSerial Troubles | Excel Programming | |||
Remove Holidays as DateSerial using Case | Excel Programming | |||
Time/DateSerial Numeric Value | Excel Worksheet Functions |