userForm listBox being double-loaded

**bstubbs** · 07-16-2009, 02:18 PM

Howdy, Folks:

I'm having problems loading data into a listbox. When the form first opens, it loads the data twice. I can then kill the form and restart it and the data is in there three times. I can't see any loading problems with the userForm_initialize routine. How can I ensure that the listBox is empty before I start adding data? This would also seem to be necessary prior to loading a different set of data into the form - correct?

Any ideas?

TIA.

Bob

**Palmetto** · 07-16-2009, 02:23 PM

Any ideas?

Probably, once you post your workbook with the code.

**bstubbs** · 07-16-2009, 02:32 PM

Here's the concerned code:

Please Login or Register  to view this content.

Here's then initialize section:

Please Login or Register  to view this content.

The data is in the "lookupData" sheet, within the "cedarHillDriverList" range. The range is defined by:

Please Login or Register  to view this content.

It appears to be working correctly as well.

Any ideas now?

Bob

**bstubbs** · 07-16-2009, 03:05 PM

Isn't the critical point about how to empty the list. Something like
"Me.lbSelectDriver.removeAll".

How can I accomplish that sort of thing?

Thanks.

**Palmetto** · 07-16-2009, 03:12 PM

I don't see why you dont just set the RowSource property to the named range inside the property sheet.

As stands now, the list loads as follows:

Upon initialization of the form
Every button click while the form is open - which duplicates the items in the list with every click.

I think it is simpler and cleaner to just assign the RowSource property. Since you're using a DNR, the list will always update per changes. Why go to the trouble of using code to loop through the cells in the range?