Proper Case not working

Hi,

I am trying to force the input of a text box to be changed to Proper Case (First letter of each word capitalised) but for some reason it is not working. I am using the fucntion below, can anybody see what I am doing wrong?

Please Login or Register  to view this content.

Thanks,
David

text boxes do not have a lostfocus event, so that will be a normal routine in your userform class that requires a call.

is the code from a vb example?

This works for me, change the textbox name

Please Login or Register  to view this content.

Originally Posted by duckboy1981

RoyUK - Works a treat thank you.

Andy Pope - The code came from another forum as a solution for the same problem.

Thanks to you both.

Best stick to this forum then (LOL)