• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Display data in listbox from hidden excel sheet


New Member
Hi All,

Need an urgent help on this.

I have created on userform, with textbox and combobox. By using this some data is getting saved in the excel sheet named "Database". I am able to display this data in the listbox in the same userform only when that "database" sheet is active or reflecting behind the userform.

Problem statement: I am not able to display data in the listbox when I am hiding that database sheet.

Can anyone help me with the vba code or any process so that, even if the database sheet is hidden, I should be able to show that data in the listbox.

attaching the snapshot of the file for reference

Thank you!


Marc L

Excel Ninja
Hi !​
Just qualify each cell / range with the appropriate worksheet whatever by its CodeName, its Name or its Index …​