Newbie help please
 

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

Newbie help please
 

Brian,

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

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"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

Newbie help please
 

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

Newbie help please
 

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

Newbie help please
 

Brian

You can export the modGetInfo module from Chip's workbook then import it to
your Personal.xls workbook or into a blank workbook which you could then Save
AsFile TypeExcel Add-in(*.xla)

The GetInfo Function would then be available for any/all open workbooks.

Gord Dibben Excel MVP

On Sun, 14 Dec 2003 12:31:39 +1300, "Brian Tozer" wrote:

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

Newbie help please
 

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

Newbie help please
 

Thanks Gord.
Very helpful.

Brian Tozer

Gord Dibben wrote:
Brian

You can export the modGetInfo module from Chip's workbook then import
it to your Personal.xls workbook or into a blank workbook which you
could then Save AsFile TypeExcel Add-in(*.xla)

The GetInfo Function would then be available for any/all open
workbooks.

Gord Dibben Excel MVP