VBA Code Assistance

Hi

I have a further question concerning the attached spreadsheet.

The following code functions as expected.

Please Login or Register  to view this content.

However, I would like to introduce some code the capitalises the first letter in

Please Login or Register  to view this content.

I am not sure how to code this. I did a google search without success.

Many thanks

For proper case, you’ll need to use the StrConv function.
StrConv(.Cells(R, 2), vbProperCase)

Alternatively, you can use the worksheet function PROPER, like this
Application.Proper(.Cells(R, 2))


Regards, TMS

Hi Trevor

Many thanks for your quick response.

I will use what you have provided

You're welcome.

Hi Trevor

Sorry for getting back, but I have to put my hand up and concede defeat.

Maybe I am thick but I am struggle to get you concept to work.

Are you able to provide some more advice?

Many thanks

Hi Trevor

I have at long last got it working with this

Please Login or Register  to view this content.

and I inserted between

Please Login or Register  to view this content.

This is now the completed code

Please Login or Register  to view this content.

Thanks

Well done, but it needs to be:

Please Login or Register  to view this content.

And it needs to go before the End With otherwise the code/cells are not associated with the Member Induction List worksheet


Regards, TMS

Hi Trevor

Thanks for that. I have made the change.

You're welcome.