Preventing data entry non-conformity

[Big Lar]

UserForm adds data to my worksheet
TextBox13 is “City”
TextBox14 is “State”

If a user inputs lowercase letters into the TextBox13, can the target cell be formatted to UpperCase the first letter?

And, if lowercase letters are entered into TextBox14, how can the target cell be formatted to all UpperCase?

I’ve attempted several methods without success. For example, this line results TRUE in the target cell

ws.Cells(iRow, 19).Value = FormatCells = (UpperCase)

 

[RoryA]

Convert the value when assigning it to the cell:

ws.Cells(iRow, 19).Value = UCase$(Textbox14.Text)

for example.

 

[Big Lar]

RoryA,
Excellent! Thank you.

Any suggestion for capitalizing the first letter in "City"?
ws.Cells(iRow, 18).Value = ???

This would allow users to enter data without having to use the Shift key.

 

[RoryA]

You can use either StrConv:

strconv(TextBox13.Text, vbProperCase)

or the Proper worksheet function:

Application.Proper(TextBox13)

 

[Big Lar]

RoryA,
Thanks for the assistance. It works beautifully.

Can you explain Application.Proper(TextBox13) worksheet function?
I'm not sure where to add this to my project.
But, since strconv works so well, I've added it for each TextBox where appropriate.
Now, users are not required to use the Shift Key for entering Names, Streets, City, etc.
That makes things work soooo much better.

Thanks, again!