Another worksheet open corrupts userform listbox

Hi,

I have a userform with a listbox that displays columns of information based on a worksheet of that workbook. If I were to have the workbook open [WORKBOOK A] on the said worksheet and then open another workbook's sheet [WORKBOOK B] and then open the userform with the listbox from workbook A, the listbox is corrupted and pulls it's information from the columns of WORKBOOK B. Is there some way to tell the userform's listbox to only pull it's information from the correct worksheet and ignore other workbooks that may be open on the same time?

Thanks Mike but it does not work. I am getting a compile error.

You need to fully qualify whatever reference you are using to load the .List property of the ListBox.
For example, if the list is populated from the Range A1:A6 in a sheet named "Sheet1" in myWorkbook then you need to reference like:

Please Login or Register  to view this content.

How are you populating the list?

Thanks cool blue but an error came up when I tried. I am populating the listbox currently with the below code:

Please Login or Register  to view this content.

coolblue, thanks - this worked!

Noted; thanks

Hi coolblue or anyone else, instead of starting a new thread I decided to reply to this. My problem was solved whereas my first listbox pulled its information from the correct worksheet without being corrupted and pulling information from another sheet which is open. However in my second listbox, I have a combobox [cboFilter] and a search button [cmdFilterSearch], where I can select an item in the box, click search and the listbox will be filtered to show the records containing the item searched for which is in column D. If I have another worksheet open and perform a filtered search, the listbox is blank because it is not finding the column D information it is supposed to find. My code is below. Can you help me point this code to my sheet1 which is called "Main"?

Please Login or Register  to view this content.

Please can someone help me with my above post? Thanks!