WELCOME TO THE BOARD!
How can I make sure that numerical entries in a textbox on a user form are recognized as percents?
There are a couple of ways to do this. For instance, if the value entered into the TextBox is going to a cell in the spreadsheet, you could do something like this:
Range("A1").Value = TextBox1.Value/100
Then the formatting of cell A1 should be as percentage.
Is there a way to deactivate a user form after it pops up so that one can scroll on the worksheet in the background?
There are two ways to deactivate a UserForm. One of the ways is:
Me ALWAYS refers to the current UserForm. This will actually "turn off" the UserForm. Here is another method:
This only hides the UserForm rather than "turning it off".
I hope that this helps.