Forms Toolbar - Textbox

I'm using forms toolbox to add textboxes on an user input sheet for my workbook.

There would be 3 textboxes included in the group box added to the user input sheet.

I'm struggling with the code to accomplish the following:

Textbox1 - is a % input. I would like the input to be formatted to 2 percentage points. In other words, if someone enters 2, it will show as 2.00% and I want the 2.00% to be recognized as such in the spreadsheet calculations. In other words, the input is used in the calculations in another sheet.

Code thus far (and I may be offbase on this):


Private Sub TextBox1_Change()
Sheets("Sheet2").Range("rate").Value = TextBox1.Value
End Sub
Problem - the cursor is not moving and the result of the input is not showing. I would like the cursor to move from textbox1 to textbox2 to textbox3 by tab or enter button.

Textbox2 - is decimal input. I would like the input 5, it will formatted to show as 5.0. This input is used in the calculations in another sheet.


Private Sub TextBox2_Change()
Sheets("Sheet2").Range("multiple").Value = TextBox1.Value
End Sub

Textbox3 - is a result box based on the inputs from textbox1 and textbox2. I would like the result to be shown to the user in this textbox3 and for it to be greyed out and not to accept any inputs from the user.
That is, it is not an input box but rather a results box.