using dateserial in vb
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?)
|