Uppercase only in VBA form TextBox

[rnhutsko]

I have a form which contains a TextBox in which the users enter names. The data needs to be in uppercase. This what I tried for code to change the inputted data into uppercase. It did not work and need help to figure this out. Thanks...

Private Sub FirstNameBox_Change()
FirstNameBox.Value = Format(FirstNameBox.Value, "UPPERCASE")
End Sub

 

[Domski]

Try:

Private Sub FirstNameBox_Change()
FirstNameBox.Value = UCase(FirstNameBox.Value)
End Sub

Dom

 

[Weaver]

try:

FirstNameBox.Value = ucase(FirstNameBox.Value)

 

[rnhutsko]

Thanks to all! That works perfectly....

Regards,
R