Populate ListBox From VeryHidden Sheet

[AbodeOfFelicity]

Hello, I need urgent help on this. I want to populate a listbox from an xlVeryHidden sheet. I looked online and found a few threads but could not get it to work with the way I've written the code. I've been trying for 2 days. Thanks!

Please Login or Register  to view this content.

[AlphaFrog]

Qualify the sheet for the range of cells.

Please Login or Register  to view this content.

[AbodeOfFelicity]

Qualify the sheet for the range of cells.

Please Login or Register  to view this content.

Thanks for the reply, I'm not sure what you meant by this. Set wkse = Sheets("Employee_List") - i already qualified the sheet. The code is working perfectly fine when the sheet is not xlVeryHidden, it only stops working when it's hidden or very hidden.

[AlphaFrog]

Did you try my suggestion?

This doesn't qualify a cell reference. Set wkse = Sheets("Employee_List"). It sets a variable.

The line below will work if Employee_List is the active sheet because the Cells reference is not qualified and it will reference the Active Sheet by default.

Please Login or Register  to view this content.

If Employee_List is hidden, it cannot be the Active sheet. So if you qualify the Cells reference as I previously suggested, it will reference the hidden Employee_List instead of the Active sheet.

[AbodeOfFelicity]

Did you try my suggestion?

This doesn't qualify a cell reference. Set wkse = Sheets("Employee_List"). It sets a variable.

The line below will work if Employee_List is the active sheet because the Cells reference is not qualified and it will reference the Active Sheet by default.

Please Login or Register  to view this content.

If Employee_List is hidden, it cannot be the Active sheet. So if you qualify the Cells reference as I previously suggested, it will reference the hidden Employee_List instead of the Active sheet.

In the second code you quoted the only difference I see is the removal of wkse. I tried this and nothing changed. I'm not sure what you mean by qualifying cell reference. How do I do that? Thanks!

[AlphaFrog]

Is "Employee_List" the hidden sheet?

Did you try this and did it work?

Please Login or Register  to view this content.

[AbodeOfFelicity]

Is "Employee_List" the hidden sheet?

Did you try this and did it work?

Please Login or Register  to view this content.

Oh god my bad!!! It's 2AM here I thought you put the wkse after lastrow! Thank you very much, such a simple fix!!! I really need to learn vba better and stop my trial and error style :P

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Please don't mark threads as urgent in future - the help you get here is for free and provided by unpaid volunteers in their free time, so don't try to have your queries prioritised - just be patient and wait your turn.