Listbox displaying multiple dates that are the same

**brouhaha501** · 02-22-2010, 10:25 AM

I know the title is a little confusing, but i couldn't think of a better way to put it. I have a listbox connected to a combobox. the combobox acts like a filter, allowing the user to change from multiple different selections, which appear in the listbox.

the problem i am having is when two of the items that appear in the listbox are the same, then the data displayed to the right will only show the top most row. i have attached the example.

On this example, the userform is called frmEditData. if you filter claim, you'll notice that since each number appearing in the listbox is different, it will display the corresponding data in the right. If you use the date of loss search parameter, all three are the same, so it will only show the top row.

Thanks so much for all of your help in advance, i greatly GREATLY appreciate all of your time with helping me.

**brouhaha501** · 02-24-2010, 09:45 AM

I apologize that the original posting was not very well put together, let me try to re-phrase. Listbox1 automatically populates from a rowsource.When a value is clicked in the listbox, it will then populate different fields in the userform from that row. If two or more of the values in the listbox are the same, then only the highest row will be populated in the rest of the userform.

If someone could help, it would be VERY greatly appreciated. thanks again for your time.

**romperstomper** · 02-24-2010, 09:51 AM

Don't populate Listbox1 from a rowsource. Make it a 2 column listbox and populate it with the dates from the worksheet and the row numbers they are on. You can then populate the rest of the form using the row number directly rather than a VLOOKUP or Find or whatever.

**brouhaha501** · 02-24-2010, 11:03 AM

I was mistaken in saying that they are populated by rowsource, The populated data in the listbox is from different ranges, selected using a combobox:

Please Login or Register  to view this content.

In regards to adding another column to the listbox, I have changed the ColumnCount to 2, but because the information in the listbox changes, i'm not quite sure where to program the second listbox. I have never input multiple columns into a listbox before, so I have tried changing the above code to say the following:

Please Login or Register  to view this content.

Then, added another section of cases, which read

Please Login or Register  to view this content.

but received an error "Run-Time error '1004': Method 'Range' of object'_Workshet' failed." Please forgive my incompetence with this, and I feel really embarrassed because it seems that the column count should be an easy fix, i just have never done it before.

Romper, thanks again for all of your help. I really appreciate it.

**romperstomper** · 02-24-2010, 11:40 AM

Thinking about it again, it's actually easier than that since you are loading every row into the listbox. That means that you just need to add 2 to the Listindex of the listbox (since it starts at 0 for the first item in the list and your data starts at row 2). So your Listbox click event becomes:

Please Login or Register  to view this content.

**brouhaha501** · 02-24-2010, 11:45 AM

Works perfect!! Thanks so much for your help!!!

Listbox displaying multiple dates that are the same

LinkBack

Thread Tools

Rate This Thread

Display

Listbox displaying multiple dates that are the same

Re: Listbox displaying multiple dates that are the same

Re: Listbox displaying multiple dates that are the same

Re: Listbox displaying multiple dates that are the same

Re: Listbox displaying multiple dates that are the same

Re: Listbox displaying multiple dates that are the same

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions