Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Date fuction in Excel 2000

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    20 Minutes outside Manhattan
    Posts
    64
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ?


    Kind Regards,
    Ivan F Moala From the City of Sails

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Location
    20 Minutes outside Manhattan
    Posts
    64
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  4. #4
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.
    Kind Regards,
    Ivan F Moala From the City of Sails

  5. #5
    Board Regular
    Join Date
    Apr 2002
    Location
    20 Minutes outside Manhattan
    Posts
    64
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks, It's a place to start looking.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •