I think VB can still handle what you want, although things might bog down
some if you have a wide-ranging number of formulas (not cell references for
a particular formula "shape", but rather, in the number of formula
"shapes"). Can you give me a list of the characters that would need to be
subscripted and those that would need to be superscripted; also, if there is
any other formatting you would want, tell me the characters and type of
formatting for those as well; and show me one or two formulas that you need
to handle. With them, I'll try to dummy-up some examples so you can see the
type of approach I am thinking about.

--
Rick (MVP - Excel)


"Neil Cash" wrote in message
...
That example was certainly a simplification, and I need the formatting
throughout the entire worksheet. So I don't think I can narrow it down to
one range.

I'm a little familiar with VB and event programming. But not sure how you
could apply the formatting without specifying the specific cells, number
of
instances, and basically taking the result and manually applying the
formatting. Seems tedious...

I guess if you can guide me with the right method for this code, I would
appreciate it.

Some things that should be noted:

-There isn't a set range of cells that need this formatting, it's random
throughout
-The formulas can be as complex as
="L x ( ½wLL + ½w"&IF(OR(AND(E23="ˆš",E24="ˆš"),E18=0),""," + ((wp x
a)(2L - a))/(2L²)")&" )"

Where I would need a few select letters of the output to be formatted
with
the subscript.

-And I'm thinking it would need to be tied with the Dirty event, and
don't
want it to bog down data entry with multiple programming runs.

I'm probably asking for the moon, but I would like to know how this is
done
through VB.

Thanks again!

"Rick Rothstein" wrote:

No, you can't part of a cell's value be formatted differently from the
rest
when using a formula. However, there is a VB solution that will do what
you
want. However, you will need to lock down the range of cells the
functionality will apply to. In other words, when using VB event code,
there
is no "copying down" type mechanism available when extending a
functionality
across a range... you have to specify the entire range that could ever
possibly be involved before hand. So, tell us what the maximum range of
cells are where you would put your formula and how the formula is to
apply
(E18 becomes E19 in next cell down, etc?) and we will try to write the
event
code to do what you want. By the way, if the formula you posted is a
simplification for your actual formula, then you will need to tell us
your
actual formula as the code will be specific written to duplicate what it
does.

--
Rick (MVP - Excel)


"Neil Cash" wrote in message
...
I use a lot of variables with subscripts. And would like the formatting
to
follow the output when I put these in formulas.

i.e. =if(E180,"pr = 7","pr = 0")

I would like the "r" in pr be subscripted when it calculates the
formula.
So far I've noticed that it removes all formatting when the formula
calculates. Is there a way around this?

Thanks in advance!