Combining Font Types

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to combine two different font styles for display as the
Label.Caption on a user form? I need to concatenate a character from the
'Symbol' set with a standard letter (A-Z) and display the combination as the
..Caption for a form label. But the font description (Arial) for the label
replaces the 'Symbol' character with the Arial equivalent. Is there any way
to display two different font styles together?
 
Try this.
Type abcdefg in a cell
Now highlight just the D and change the font to symbol
You should see abs<delta>efg; where ,delta. is the Greek D looking like a
triangle.

best wishes
Bernard
 
That works fine in a cell on a worksheet.

But apparently on a User Form (in VBA), the Font selection controls all of
the characters in the Caption. If a 'Symbol' character is part of the string
that makes up the Caption, the font style replaces the 'Symbol' character
with the font equivalent.

Any other suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top