How to make Text in a Merged Cell of different Font(s) & Font Size Programmatically?

How to make Text in a Merged Cell of different Font(s) & Font Size Programmatically?

Dear Forum,

I have a particular Form which is basically a Blank Template and which is going to be used with Dynamic Names and then further for Printing.

The names are going to be selected from a Drop-Down and that is concatenated in the Template TEXT..

TO make it look more Authentic I want to haev this Text in a Different Font and Larger Font Size than the remaining text..

Ex:-

Cell B6 =

Received with thanks from MR. SACHIN RAMESH TENDULKAR a return of income and/or return of fringe benefits in Form No. ITR … for assessment year 2009-10, having the following particulars.

AS you can see the reamaining text is of normal Times New Roman Font and regular Font Size.

This TExt is Pulled from a DropDown connected to a List Names in the cell U1.

U1= MR. SACHIN RAMESH TENDULKAR

="Received with thanks from"& MR. SACHIN RAMESH TENDULKAR &"a return of income and/or return of fringe benefits in Form No. ITR … for assessment year 2009-10, having the following particulars."

So ,how DO i manage this difference in Font(s) and FOnt Size in a single cell which is Merged.

Warm Regards
e4excel

Try this

Please Login or Register  to view this content.

Run the macro FormatText.

If you need help with colour indeces run the macro GetColorIndex, this will fill ColumnA with the available colours and their index number.

Hope this helps

There are only a few colours with names
0 Black
1 White
2 Red
3 Green
4 Blue
5 Yellow
6 Magenta
7 Cyan

The remainder can have names in html but this varies and only complicates things.

That can often be because there are different pallettes and theme colours involved. As I recall only the first 8 are consistantly and uniquely numbered.