How to focus on a specific control (TextBox1) on a user-form in MS-Excel
Barbara from Mumbai sent us this email:
I just created a user-form to calculate the perks and total salary package based on the entry of a basic salary. The form works fine but when I run the form the command box to calculate the perks and package is highlighted and I have to click in the textbox against the label name to start my entries. How can I avoid this situation so that the cursor appears inside the textbox against the label name automatically?
This problem has two solutions and you can use any one you like. You can watch the training video below (15.2 MB) before diving into the macro code.
The macro code for the various controls is given below:
Private Sub CommandButton1_Click()
TextBox3 = TextBox2.Value * (60 / 100) + TextBox2.Value * (15 / 100)
TextBox4 = Val(TextBox3) + Val(TextBox2)
Private Sub CommandButton2_Click()
TextBox1 = “”
TextBox2 = “”
TextBox3 = “”
TextBox4 = “”
Private Sub CommandButton3_Click()
End ‘You could also use Unload Me
Private Sub UserForm_Activate()