Hello all...I have the following code, which works Great, assigned to a Text box on my userform...
This keeps people from doing:
The QuisK BRown FOX juMPs
To
The Quick Brown Fox Jumps
But as usual Users keep putting a Space at the end..
I need to remove that extra SPACE at the end of the Value so that:
The Quick Brown Fox Jumps_
"_" = Space bar strike
to
The Quick Brown Fox Jumps
PLease
VBA Code:
Private Sub txtClientDoor_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)
txtClientDoor.Value = StrConv(txtClientDoor.Value, vbProperCase)
End Sub
This keeps people from doing:
The QuisK BRown FOX juMPs
To
The Quick Brown Fox Jumps
But as usual Users keep putting a Space at the end..
I need to remove that extra SPACE at the end of the Value so that:
The Quick Brown Fox Jumps_
"_" = Space bar strike
to
The Quick Brown Fox Jumps
PLease