Solved: How to populate listbox

[Digita]

Hi everyone,

Hope you had a good weekend. I'm trying to modify an example provided by Charlize in the following thread without success

http://www.vbaexpress.com/forum/showthread.php?t=13082&highlight=filter

As the thread has been marked as solved. I now start a new one and attach a sample file in the hope that someone would come to the rescue.

What I'm trying to achieve is to select a date in the listbox to filter the data accordingly. My 2 problems are:

1/ The listbox shows the first entry only.
2/ The date shown in the listbox is in mm/dd/yyyy format.

Thank you for your time & kind assistance.

Regards


KP

[Bob Phillips]

You need a combobox.

[Digita]

Thanks XLD for the reply. Any idea how to fix the date format issue?

Thanks again & regards


KP

[Bob Phillips]

I thought I had.

[Digita]

Hi XLD,

Indeed you had. My apology. Thanks for the quick reply.

Regards

KP:hi:

[Charlize]

Remove this one

[Charlize]

Problem with one entry showing can be solved like this.
1. In the gotfocus event of every listbox you specify the height of the listbox to 24.75
2. In the workbook_open event of your file you put following lines.With Worksheets(1)
.listbox1.activate
.listbox2.activate
.listbox3.activate
.listbox1.activate
End With