I'm using a text box with an = formula to capture a cell label (please see attached). I want the first letter of each word in the label to be larger to simulate MS Word's Small Caps font. While I can do this manually, the label will change depending on user selection, so I need a formula that will do the formatting.
Any ideas?
Paul
Hello Paul,
As to my understanding you can do this by using VBA. I have not seen any formula that allows you to change the font size. The links below gives you more details of how to use the characters and font objects.
Br,
Anders
Thanks, Anders. I did see a post elsewhere that allowed the increase of a font size. I think it is something like this:
FontSize = .Font.Size
ActiveCell.Characters(Start:=2).Font.Size = FontSize - 3.
The trouble (for me) is recognizing within VBA when the first character of the first, second, and third words begin (if there are second and third words, that is).
Paul
Hi Paul
Instead of using a text box, you could try using a linked image instead.
I am using an Event macro to detect any change in a specific cell. via Data Validation
When you select from the list it will change the font size and will reflect in the linked image.
You may need to modify the codes to suit your situation.
Hope this helps.
Sunny
That's a clever way.
Here is another version that can also change the color of the 1st letter of each word.
This just blows me away. Thanks!
