Register
Log In
Unanswered
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
Members
Dashboards
Power Query
Power Pivot
Power BI
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-us/vba/excel-vba/articles/characters-object-excel
https://msdn.microsoft.com/en-us/vba/excel-vba/articles/font-object-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
Dashboards
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.
Most Users Ever Online: 57
Currently Online: Mynda Treacy
20 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
sugi gunawan
janja mesec
John DiMartino
lizette acosta
eric johnson
Kim Bond
Nichelle Stevens
Manuel Rodriguez
peter wang
Amit Kanekar
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
