tony.reynolds
Board Regular
- Joined
- Jul 8, 2010
- Messages
- 97
I have part of my userform code below that enters the valuse into a sheet
i need the values Company and contact to be proper case regardless of how the user enteres it.
can someone help me make it proper case when this runs or even better can it change it at the time the user enters it using the code for the Company_change ()
any help would be greatly app.
i need the values Company and contact to be proper case regardless of how the user enteres it.
can someone help me make it proper case when this runs or even better can it change it at the time the user enters it using the code for the Company_change ()
any help would be greatly app.

Code:
Private Sub Company_Change()
End Sub
Code:
With wb.Sheets("Sheet1")
lr = .Range("A" & Rows.Count).End(xlUp).Row + 1
.Range("A" & lr).Value = Company.Value
.Range("B" & lr).Value = Contact.Value
.Range("C" & lr).Value = Phone.Value
.Range("D" & lr).Value = Fax.Value
.Range("E" & lr).Value = Email.Value
.Range("F" & lr).Value = Freight.Value
End With