Log In
Register
Home
July 7, 2016
Offline
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
VIP
Trusted Members
December 7, 2016
Offline
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.
https://msdn.microsoft.com/en-.....ject-excel
https://msdn.microsoft.com/en-.....ject-excel
Br,
Anders
July 7, 2016
Offline
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
VIP
Trusted Members
June 25, 2016
Offline
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
July 7, 2016
Offline
That's a clever way.
1 Guest(s)
