How can I write code that will capitalise the First Letter in two names that
will be typed in to a single cell? I want this to be performed automatically
without user intervention. I can use the 'Proper' function but this has to
be typed in to the cell first as part of a formula, don't want to do that

I assume it will be a Private Sub within the Worksheet triggered by an event
i.e. a value in the appropriate cell

Thanks