Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: DTpicker on 64bit

  1. #1
    Board Regular
    Join Date
    Oct 2010
    Posts
    172
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default DTpicker on 64bit

    I'm using a userform where a date is selected from DTpicker. I developed it initially on 32bit so I didn't encounter this issue.
    In an attempt to make it work on 64bit I downloaded add-in from Date Picker Add-in for Excel for Windows

    But an error comes up when calling the procedure in a userform. plus I don't how to make the value of the selection affect a textbox in the userform.
    Code:
       call ronaddin
       textbox1.value = selectedDate
    I tried another workaround solution by creating a list of dates that are linked to a combobox but I've got another problem and now it's with the date format. whenever the combobox is changed the date converts to a number and error comes when using the format property

    Code:
    combox.value = format(combobox.value,"mm/dd/yy")
    I would prefer if I can get Ron's add-in to work but if there is no chance then what is the equivalent for the FORMAT property in 64bit office 2016.

    thank you

  2. #2
    Board Regular
    Join Date
    Oct 2010
    Posts
    172
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: DTpicker on 64bit

    I was able to resolve the issue by installing office 2010 on 64bit computer .

User Tag List

Tags for this Thread

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
  •  


DMCA.com