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

akika

New member
Joined
Aug 5, 2018
Messages
7
Reaction score
0
Points
1
Excel Version(s)
2016
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???
 

Attachments

  • Capture.PNG
    Capture.PNG
    15.7 KB · Views: 11
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.
 

Attachments

  • test_date.xlsm
    181.6 KB · Views: 13
Back
Top