Right now, I am doing date of birth (DOB) using three combo box which is a day, month and also a year. From the combo box, how to make all the three combo box will appear in just one column?
12.JPG
This is coding for edit command button. And also I already attach the sample of workbook so that you can see clearer.
Please Login or Register to view this content.
Last edited by ElStar; 11-08-2018 at 03:23 AM.
If you attach a working file, the first error is that the form you want to open doe not exist.
I suggest you check that your file works and explain it in better words so that anyone that does not know what you want understands it.
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
I already check the attach, and also already explain in different way. Is that okay?
This is the error when I try to Edit the DOB
Like I said, TEST the file first then attach, this happens when you copy a file or part of a file for a forum
Why don't you use a calendar?
Actually, that is the errorI want to use that coding, but it did not works.
Because I prefer using a combo box instead using date picker.
What is it Exactly that you need?
You have the ComboBox and form there? What?
Right now, i already add the data. So from the data i want to change the DOB. I dont know how to make from the combo box and transfer it to the column using edit button.
Perhab
Change this
Change toPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by daboho; 11-08-2018 at 04:03 AM.
Okay, NOW it's clear.
What you need to do so is simple, When you press Edit you create a date from the data in the combobox
the idea is simple
Please Login or Register to view this content.
Syntax error
Originally Posted by daboho
Perhab
Change this
Change toPlease Login or Register to view this content.
Please Login or Register to view this content.
Where to put this code ?
Okay, NOW it's clear.
What you need to do so is simple, When you press Edit you create a date from the data in the combobox
the idea is simple
Please Login or Register to view this content.
Here's the file again with the correction
Thank you so much!
You're welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks