Add Items to List Box Problem

[DreamerZ]

I have a user form in Excel with a list box that I fill with data based on visible rows on a sheet. This form is opened based on data from another form. I have to do it this way because it's possible there will be multiple rows found from the data entered in the first form.

So, in form 1 data is entered. The sheet is searched. If data is not found, it's added to the sheet from form 1. If data is found, form 2 opens showing all found data using the list box. The data can either be added as new or an existing row can be updated with the new data.

My problem: if data is not found the second form is not displayed. If the next entry is then found, the list box on the second form shows all rows instead of just the ones with equal data (it's a date and name found).

Any reason why this happens? I'm filtering rows based on data from the first form (filtering sheet for name and then for date). The list box is supposed to fill with just visible rows then.

Thoughts? Thx,


DreamerZ
simplesolutions@prodigy.net
[ignore]

http://www.geocities.com/simplesolutions@prodigy.net

[/ignore]

 

[SkipVought]

DreamerZ,

Might be helpful if you posted the code that runs the filter.

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[DreamerZ]

I figured it out. I wasn't unloading the form properly so it was retaining variables. It works now.


DreamerZ
simplesolutions@prodigy.net
[ignore]

http://www.geocities.com/simplesolutions@prodigy.net

[/ignore]