Capitalize first letter with VBA conditional formatting

**Rob K** · 06-26-2015, 06:20 AM

Can anyone tell me the syntax to capitalize the first letter of a word using conditional formatting using VBA please.

**S O** · 06-26-2015, 06:21 AM

Not sure how you would use it with CF, but the =PROPER() method will convert a string to proper case

In VBA you can use

Please Login or Register  to view this content.

**Rob K** · 06-26-2015, 10:41 AM

Hi, here, if I have done this correctly, is the workbook.

**Rob K** · 06-26-2015, 10:45 AM

posted workbook to wrong thread sorry

**S O** · 06-26-2015, 10:49 AM

np - did the above work for you?

Re: Capitalize first letter with VBA conditional formatting