Consulting

Results 1 to 3 of 3

Thread: Help : Date Picker in VBA user form and view data from data entry wb

  1. #1
    VBAX Mentor
    Joined
    Nov 2020
    Location
    Cochin, Kerala
    Posts
    314
    Location

    Help : Date Picker in VBA user form and view data from data entry wb

    Dear Experts,

    Request your help on the below-

    I have a user form wherein three places I need to fill dates from a calendar. I have included a Calendar Control Class downloaded from here and I managed to use it in one text box (colord in green). Request your help in using the same calendar in rest of two places (colord in yellow).

    Screenshot 2021-04-17 011433.jpg
    Screenshot 2021-04-17 011518.jpg

    I would also request, if you can support me in viewing the results from Data entry sheet based on the criteria selection in report section.

    Really appreciate any support
    Thanks!
    Attached Files Attached Files
    Last edited by anish.ms; 04-16-2021 at 02:11 PM.

  2. #2
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    Dim SelectedBox As MsForms.Control 'Or something like that
    Sub ReviewDate_Click() 'Repeat for each Box.
    'something like this
    Set SelectedBox = ReviewDate
    Show Calendar Control
    End Sub
    Calendar_Click
    'something like this
    Selected Box.Value = Calendar.Value
    Set SelectedBox = Nothing
    Calendar.Close
    End Sub
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

  3. #3
    VBAX Mentor
    Joined
    Nov 2020
    Location
    Cochin, Kerala
    Posts
    314
    Location
    Thanks Sam for your time and response!
    Let me try and revert.

Posting Permissions

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