Get date from listbox column and distribute day/month/year to comboboxes

**ElStar** · 11-07-2018, 03:16 AM

Currently, I am using a combo box for DOB. Now, I have a problem with - from the list box how to make it appear in the combo box? I want to edit the data so I want it to appear at the combo box.

Day - Emp17
Month - Emp18
Year - Emp 19

12.JPG

This is my coding

Please Login or Register  to view this content.

**6StringJazzer** · 11-07-2018, 09:38 AM

It depends on how you populated the listbox to begin with. I will assume that the data in that column is a string. I can't tell for certain what column the date is in so I will use column index 11 as an example. Consider attaching your file next time you have this type of question.

Please Login or Register  to view this content.

**ElStar** · 11-07-2018, 07:57 PM

Its work! Thank you so much

Get date from listbox column and distribute day/month/year to comboboxes

LinkBack

Thread Tools

Rate This Thread

Display

Get date from listbox column and distribute day/month/year to comboboxes

Re: Appear date in different combo box

Re: Appear date in different combo box

Thread Information

Users Browsing this Thread

Similar Threads

Help with COUNTIF date is in specified month/year but date column has blank cells

Sum Quantities by Year and Month of a date in another column

CONCATENATE Day column, month column, and year column to make a date column

Need to convert Month/Date/Year to Year/Month/Date so excel will recognize

Return True if date in cell is between a month and year in drop down comboboxes

If Column A Month and Year = ColumnB Todays Month and Year then send email

Counting month and year from a date column

Bookmarks

Bookmarks

Posting Permissions