Thanks very much Trevor.
You have given me the breakthru that I needed.
Brian Tozer

Trevor Shuttleworth wrote:
Brian

just select one of the cells in column B and then cursor down. The
formulae are in the cells. These are the examples of using the
function. I guess the more VBA you know, the further you can take
this. There is more explanation in the VBA code itself.

So, if for some reason you want to create a formula that is dependent
on the colour of the text in a cell, you could test it using Chip's
GetInfo function.

For example:

=IF(getinfo(A1,"font.bold"),"text is bold","text is NOT bold")

Beware though that the value does not seem to be recalculated
automatically even though "Application.Volatile True" is included.

Regards

Trevor


"Brian Tozer" wrote in message
...
As I wrote, I have run the file.
I have examined the result.
I think you may find it hard to think like a newbie.

Presumably it is intended to be used in conjunction with an existing
workbook.
How exactly?

Brian Tozer

Bob Phillips wrote:
Brian,

Chip gives you a workbook that gives you all of the information that
you ask. What more do you need?


"Brian Tozer" wrote in message
...
I have downloaded, unzipped, and run, the GetInfo file from Chip
Pearson's page at:-

http://www.cpearson.com/excel/download.htm

The explanation on the above page states:-

"The GetInfo function, written in VBA, allows you to retrieve
nearly any property of any object in the Excel object model
directly from a worksheet cell. Using this one function, you can
eliminate dozens of custom UDFs to get application and object
properties."

I am a newbie struggling to upskill somewhat in Excel.
I am using Excel 2002.

Could someone please give me a brief comment on just exactly how I
could use the above in practice.
I have been doing a lot of background research and printed
gazillions of pages of help info, and think that I can flesh out
the details once I have a pointer in the right direction.

TIA
Brian Tozer