Hi all,

I have a Userform with about 100 textboxes, in which the user has to put a certain number, formatted as 0.00%

On the first textbox, I control the valid entry with the code below. This works fine, so I'll use the code on the 99 others as well. Is there any way to automate this, rather than copying this code 99 times ?

Thanks in advance.

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
With Me.TextBox1
.Value = Format(.Value, "0.00%")
End With
End Sub