Hi
The below code on userform in sheet1 when data is copied over to sheet2, form resets correctly but when copying over to sheet 3 and 4, the cursor jumps over to the respective sheet3/4 worksheet. The function of copying over performs correctly How can i prevent the cursor from jumping over and remain on userform in sheet1
Please Login or Register to view this content.
Remove this snippet...
One should never have to use Activate or Select in code...Please Login or Register to view this content.
Lot of skip and error code there...May I ask why?
Last edited by sintek; 09-23-2020 at 12:46 PM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
This is part of the existing code:
Please Login or Register to view this content.
Replace that with:
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks