Results 1 to 3 of 3

Thread: how to populate a cell when choose a date dropdown from combo box

  1. #1
    Seeker akika's Avatar
    Join Date
    Aug 2018
    Posts
    7
    Articles
    0
    Excel Version
    2016

    how to populate a cell when choose a date dropdown from combo box



    Register for a FREE account, and/
    or Log in to avoid these ads!

    hi,
    In excel V16 forms,
    I've added combo boxes for date of entry & date of last payment set as DD / MM / YYYY defaulted with values:
    DD (01 to 31)
    MM (01 to 12)
    YYYY (2000 to 2020)

    User can input a studentID and click on search its retrieve the data from sheet1 and fill in the form with the required values.

    Pls help i'm Getting below issues:
    1. after the search for existing record the combo boxes DD/ MM/YYYY are not being loaded with the data stored in cell Q date of entry & cell X date of last payment.
    2. when updating the date (DD/MM/YYYY) data, it's not replicating in the cells Q & X.

    How can i do it???
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Capture.PNG 
Views:	8 
Size:	15.7 KB 
ID:	8327  

  2. #2
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    769
    Articles
    0
    Excel Version
    Excel 2010 64bit
    How can i do it???
    Try with an Excel file rather than a picture.

  3. #3
    Seeker akika's Avatar
    Join Date
    Aug 2018
    Posts
    7
    Articles
    0
    Excel Version
    2016

    form date

    hiya,
    excel sheet added.

    pls help.
    Instead of inputing date in text boxes for date of entry and date last payment, i need to include combo box or date pricker to choose.
    The highlighted cells in red should be updated or populated when click on search btn.
    Combo box values DD/MM/YYYY are added.
    Attached Files Attached Files

Posting Permissions

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