Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Apr 2002
    Busselton, Western Australia, Australia
    Thanked 2 Times in 2 Posts

    Thumbs up

    I have developed a spreadsheet application that includes the use of the Microsoft Date & Time Picker control.
    All runs sweet on my development PC, but when I went to run it on another PC it came up with an error to do with an unknown identifier (DATE).
    When I checked the "Tools" - "References" on the second PC, I noticed that the control "Microsoft Windows Common Controls-2 6.0(SP4)" was not available.
    I copied the file "mscomct2.ocx" to C:\Windows\System32\ on the target system and registered the control without problem.
    The question now arises to me...
    Using VBA, how can I check that this control is either present (or not) on the target system and how can I register the control if it is not?

    Thanks in advance,

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts
    It can be quite difficult to make code with missing reference work.

    As an alternative, you could use a calendar created as a userform - see for example Userform Calendar Control or Orlando's VBA and Excel Site (free download of popup calendar for Excel).

Posting Permissions

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