Prev: class modules versus modules
Next: Formula to copy cell in Excel from on file to another
From: Copacetic on 12 Apr 2010 15:58
Can I code a script that will, based on a selected value, format a
cell, and then fill it with a result of another cell's lookup value,
carrying the font that the code assigned based on the selected "font
choice"?

Then, my next selection would run the code again, so the code would
have to have several formatting modules that get called by the selected
drop down list value, and that value would get tested for each time the
drop down changes.

That way, I can have a result cell, that has a variable font by way of
one choice, and a variable value by way of another.

Is this possible? It should be a mere formatting script that I copy
and repeat several times, renaming each sub-module and pointing each at a
different font to be made available.



On Tue, 02 Feb 2010 16:11:25 -0600, Chip Pearson <chip(a)cpearson.com>
wrote:

>A formula can only return a result to the cell. It cannot modify
>anything else, including formatting. If you manually format part of a
>cell's content, that formatting will be deleted when the formula is
>recalculated.
>
>Cordially,
>Chip Pearson
>Microsoft MVP 1998 - 2010
>Pearson Software Consulting, LLC
>www.cpearson.com
>[email on web site]
>
>
>
>On Tue, 2 Feb 2010 13:52:01 -0800, Ayo <Ayo(a)discussions.microsoft.com>
>wrote:
>
>> I have a formular:
>>=REPT("|",(VLOOKUP($E$4,SummaryTable,6,FALSE)/200))& " " &
>>VLOOKUP($E$4,SummaryTable,6,FALSE)
>>
>>but I need to change the font of the 2nd
>>"VLOOKUP($E$4,SummaryTable,6,FALSE)" section.
>> Is this possible to do?
 | 
Pages: 1
Prev: class modules versus modules
Next: Formula to copy cell in Excel from on file to another