Interactive User Form

[AmirSoft]

Hi.

I have a code in following excel file

When I open a user form. It works better but only work in current sheet.

Can anyone have the solution.
I want this should work in Sheet1 not in active sheet.

So Please check this.

Thanks

[BadlySpelledBuoy]

Have a look at the attached. I presume what you mean is you'd like the UserForm to call from and record to Sheet1 rather than Sheet2(?).

BSB

[AmirSoft]

Yes. I got

Thank you so much