formatting to Proper Case for text box enrty on user form

I googled the problem but I'm still coming up with some errors... basically, I have a simple user form where a name gets input, and on execution gets written to the next empty cell in column B (and adds a record number), and I want to ensure the name is recorded in proper case. Here's my current code:

Please Login or Register  to view this content.

1) When you refer the object with "With" statement, you need to add period "." in from of related object.

2) Use StrConv function for ProerCase conversion.
i.e

Please Login or Register  to view this content.

Yep... thanks!