A while back someone showed me how to force Proper formatting onto the contents of a UserForm TextBox with:
This works with one TextBox.
TextBox1.Text = Application.Proper(TextBox1.Text)
When I tried to apply this to multiple TextBoxes with:
I keep getting an error telling me that it can not find Me.Controls("TB" & iArg), which with iArg = 1 should be TB1 which is a valiid control.
Sub FormatAll(iArg As Integer)
Select Case iArg
Case 1, 5, 6, 7, 9, 11, 18
Me.Controls("TB" & iArg & ".Text") = Application.Proper(Me.Controls("TB" & iArg & ".Text"))
Can anyone see why debug can't see TB1 and what I can do to fix this code?
Any help is appreciated.