How to use for loop to extract records from the excel sheet one by one using command button in VBA

[karthi5565]

Hi,

I'm stucking in the middle of my code. I hope anyone can help me on this..

I've 4 rows named "S#, EmpName,Date,ID" in a seperate excel sheet. I'm using the using the userform and placed 4 label & 4 textbox and 1 command button. My issue is, i want to retrieve data from that seperate excel one by one whenever i click the command button.

Please help me on this.

Thanks

Karthi