+ Reply to Thread
Results 1 to 9 of 9

Date Picker in Multipage

  1. #1
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    696

    Date Picker in Multipage

    Hi,

    DatePicker1 on page 1 whereby Command button located is working fine while DatePicker2 on page 2 got error.
    Please Login or Register  to view this content.
    Both code below is on page 2 do not working even using full path, can anyone help me?
    Please Login or Register  to view this content.
    Last edited by Faridwahidi; 09-29-2017 at 12:07 PM.
    1. Thank those who have helped you by clicking the Star * below the post.
    2. Please mark your post [SOLVED] if it has been answered satisfactorily.

    Sincerely,
    Farid

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Date Picker in Multipage

    Hi,

    What is the error and on which line?
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: Date Picker in Multipage

    Quote Originally Posted by xlnitwit View Post
    Hi,

    What is the error and on which line?
    Dtpicker.jpg

    Hi,

    See attachment above.

    When I search on Google, I found that it was a common problem and need workaround to solve it.
    Have you tried to use DatePicker in MultiPage before? It will not populate data if the page is not on current page (inactive page).

  4. #4
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Date Picker in Multipage

    Quote Originally Posted by Faridwahidi View Post
    Have you tried to use DatePicker in MultiPage before?
    No, I try to avoid non-standard controls whenever possible.

  5. #5
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: Date Picker in Multipage

    Quote Originally Posted by xlnitwit View Post
    No, I try to avoid non-standard controls whenever possible.
    The code above is a standard for MultiPage. Otherwise, what else?

  6. #6
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Date Picker in Multipage

    A Multipage is a standard control, but a DTPicker is not.

  7. #7
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: Date Picker in Multipage

    okay.. but can you help me to solve the above problem?

  8. #8
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Date Picker in Multipage

    Since I don't have it available I'd have to speculate based on what you said earlier- either activate the page first, or don't put the control actually on the Multipage.

  9. #9
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: Date Picker in Multipage

    Not really help. if the control button not placed on 1st page or any pages, all DatePickers will not work. Activate it first, will lead to current page not activated consequently not resolve the issue.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Date Picker Error in another page using Userform Multipage
    By Faridwahidi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-07-2017, 06:24 AM
  2. Replies: 5
    Last Post: 04-06-2016, 06:58 AM
  3. Add Date to User Form Without Access to Add Date Picker Control
    By kaleonard08 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2016, 12:06 PM
  4. Date picker used to populate text box. Date changes back to original value on opening.
    By Stratfordoaks in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-07-2016, 09:42 AM
  5. [SOLVED] file-picker thinks it is a folder-picker if the folder picker runs first?
    By brucemc777 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-01-2016, 01:14 PM
  6. Replies: 0
    Last Post: 08-01-2015, 12:29 AM
  7. Replies: 7
    Last Post: 12-08-2013, 06:11 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1