How to Show record from Sheet2 not Sheet 1 in the UserForm ListBox1.

Hello,

I have got a UserForm. In the UserForm I have got a ListBox1 to catch Data from my WorkSheet by using enrollment number and display it on the Userform ListBox1.

The problem is that When I try to display the Data in the UserForm ListBox1. It shows me Data from my Sheet1 (name"Main") But I want to display

Only Data from Sheet2 (name"Payment Records")...I do not want to display Data from Sheet1 ...I just need to catch Data only from Sheet2 (name "Payment Records")

I have used Sheet2 "Payment Records" in my code but I could not understand where is the problem.

Note: My UserForm icon is on my Sheet1.....From Sheet1 I open my UserForm...But I think this should not be the problem

Here is my code.

Please Login or Register  to view this content.

Hope you guys will be understanding what I mean.

I will be very thankful.