ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Embeded Cell / Object reference (https://www.excelbanter.com/excel-worksheet-functions/32451-embeded-cell-object-reference.html)

gilbert

Embeded Cell / Object reference
 

How can we refer to an object in Excel. For example, I have created an
equation in an object. How can I refer to the result of the equation?
Pls advise. :confused:

The excel worksheet is enclose herewith for clearer picture.

Thank you.

Rgds,
gilbert


+-------------------------------------------------------------------+
|Filename: MicrosoftEquation.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3535 |
+-------------------------------------------------------------------+

--
gilbert

An eager learner for Excel
------------------------------------------------------------------------
gilbert's Profile: http://www.excelforum.com/member.php...fo&userid=4686
View this thread: http://www.excelforum.com/showthread...hreadid=382157


Damon Longworth

You are not very specific about this object, but normally you can get the
text or value from an "object" with:

YourObjectReference.value
YourObjectReference.text

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"gilbert" wrote in
message ...

How can we refer to an object in Excel. For example, I have created an
equation in an object. How can I refer to the result of the equation?
Pls advise. :confused:

The excel worksheet is enclose herewith for clearer picture.

Thank you.

Rgds,
gilbert


+-------------------------------------------------------------------+
|Filename: MicrosoftEquation.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3535 |
+-------------------------------------------------------------------+

--
gilbert

An eager learner for Excel
------------------------------------------------------------------------
gilbert's Profile:
http://www.excelforum.com/member.php...fo&userid=4686
View this thread: http://www.excelforum.com/showthread...hreadid=382157





All times are GMT +1. The time now is 10:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com