Date fuction in Excel 2000

[Q]

I've developed a spreadsheet on a WindowsXpOfficeXP platform.
The platform it is being used on is NT4Office2K. (I know, I know....I like to develop on the same platform that it will be used on too, but I didn't have an extra computer to install the platform on.)
The problem is the DATE function in VB. On WinXPOffXP it works fine, but I get a compile error on the DATE on NTWin2K. Can someone please tell me the function for current date in Off2K.
This message was edited by Q on 2002-05-13 07:21

 

[Ivan F Moala]

On 2002-05-13 07:20, Q wrote:
I've developed a spreadsheet on a WindowsXpOfficeXP platform.
The platform it is being used on is NT4Office2K. (I know, I know....I like to develop on the same platform that it will be used on too, but I didn't have an extra computer to install the platform on.)
The problem is the DATE function in VB. On WinXPOffXP it works fine, but I get a compile error on the DATE on NTWin2K. Can someone please tell me the function for current date in Off2K.
This message was edited by Q on 2002-05-13 07:21

The Date Function should operate the same ?
How have you coded it and what is the Error
You say you are getting a compile error
have you got all your references right ?

 

[Q]

Ivan,
Thanks for the speedy response. The code is for a command button that brings up a calendar (using a calendar control) on a userform. The line is just to default the date to the current date when it is accessed.

frmInput.Show
frmInput.calInput.Value = DATE

As for the specific error I have asked to have a screenshot sent to me, I am waiting on it.
This message was edited by Q on 2002-05-13 07:34

 

[Ivan F Moala]

On 2002-05-13 07:32, Q wrote:
Ivan,
Thanks for the speedy response. The code is for a command button that brings up a calendar (using a calendar control) on a userform. The line is just to default the date to the current date when it is accessed.

frmInput.Show
frmInput.calInput.Value = DATE

As for the specific error I have asked to have a screenshot sent to me, I am waiting on it.
This message was edited by Q on 2002-05-13 07:34

I suspect you have a missing reference.
probably for the calendar control ocx ?
But this is a guess.

 

[Q]

Thanks, It's a place to start looking.