Hi, I messed around with some code I found on the site but I'm not able to put togheter two "Worksheet_Change" macros. Probably needless to say but I'm new to VBA.

I have one cell that has to be forced into uppercase (B9) because it's a last name and another cell on the same sheet that has to be forced into proper because it's a given name.
I found code for forcing one kind of case (upper, proper or lower) but I cannot make it work to do what I need, two kinds of cases.

Thanks for any help.