View Full Version : [SOLVED:] Multiple fonts in excel forms textbox
ccRider246
01-28-2010, 06:25 AM
Is it possible to use more than one font in an Excel Forms textbox? Specificly, I would like to use a bold font on a few lines of text within a single Forms textbox while leaving the balance of the text normal.
I am using XP with Excel 11.
nst1107
01-28-2010, 12:02 PM
You will need a rich text control for utilizing multiple sizes, fonts, etc.. Alternatively, you may be able to get away with using a combination of labels and textboxes to give a comparable effect.
ccRider246
01-28-2010, 12:20 PM
Thanks for your reply, Nate. In this case I can't use the combination of controls. The textbox holds results of a product quotation that varies every time a new quote is assembled. My users have requested that I bold the heading text in each section of the printed quote. I will just separate the sections with a dashed line. That will probably satisfy them. This is a forms based quotation tool using spreadsheets for the database.
I think I am going to have to build a db in access and write the app in vs to get the richtext controls needed for multiple fonts.
Thanks for your help.
nst1107
01-28-2010, 12:23 PM
Glad to help. Here's microsoft's take: http://support.microsoft.com/kb/838010
ccRider246
01-28-2010, 12:37 PM
Thanks. I should spend more time reading MS documentation. Very useful.
Chris
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.