Populate listbox with current date value

**Khaos176** · 02-24-2009, 10:10 AM

I am trying to populate a listbox in a userform with only certain data. Currently I am able to populate all rows in a worksheet but I need to have only rows with the current date to show. In col A is the date and col B is a persons name.

Please Login or Register  to view this content.

Thanks for any help.

**protonLeah** · 02-25-2009, 01:34 AM

The code below fills an array with data from rows with dates then initializes the list box with the array data:

Please Login or Register  to view this content.

**Khaos176** · 02-25-2009, 10:13 AM

Thank you protonLeah it works exactly as I said I needed it. I thought once I understood how to accomplish this I could use it to complete a form. I have run into a couple of problems that have me currently stumped. For simplicity I said 2 columns DATE and NAME actually there are 8 columns and 2 of them are time. This is where my first problem occurs the list box is giving decimal values instead of time values. The second problem is I wanted to use heading and they no longer are working. I have attached a NEW workbook to show my progress and I will continue to try and make it work. Any help is appreciated.

Please Login or Register  to view this content.

**Khaos176** · 02-25-2009, 12:27 PM

Ok I figured it out. I substituted the code "Format(testVal.Offset(0, 2), "h:mm AM/PM")" to fix the format issue and for the column headings I just used labels instead. Thanks again for the help.