Display data in listbox from hidden excel sheet

[Abhinav]

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]

Hi !​

​

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

​

 

[Abhinav]

Thank you Marc!