I got some help here to solve a problem using a modeless userform.
This form opens and displays info telling the user to look at the data starting in Column C and correct any errors before continuing. I used it to "pause" the macro to make these corrections.
Now, the userform opens, the cursor is on C2 but when you start typing, you're entering data into the text box of the userform instead of C2
Is there a way to "activate" the sheet so after the userform opens, you start typing into the Cell that is selected without having to click into it?
Lots of google searches indicate this is a common question but I have yet to find a solution that works.