Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
XLL Formula Reference
You gave VBA code, but I need to know IN THE XLL (C++) how to do it.
Also, what you wrote is backword - is there is a formuale currently evalutaing, I need to know what cell that formula is in; not what you gave which is what formula is in a certain cell. thanks! Peter Huang [MSFT] wrote: Hi Matthew, You may try to use the range.formula. Here is my code. Sub f() Msgbox ActiveSheet.Range("F4").Formula End Sub Did this answer your question? Regards, Peter Huang Microsoft Online Partner Support Get Secure! www.microsoft.com/security This posting is provided "as is" with no warranties and confers no rights. -------------------- Date: Thu, 18 Sep 2003 16:56:27 -0400 From: Matthew Wieder User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en, he MIME-Version: 1.0 Subject: XLL Formula Reference Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Message-ID: Newsgroups: microsoft.public.excel.programming NNTP-Posting-Host: 207.106.112.178 Lines: 1 Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftn gp13.phx.gbl Xref: cpmsftngxa06.phx.gbl microsoft.public.excel.programming:417179 X-Tomcat-NG: microsoft.public.excel.programming We inherited an xll which provides a formula that can be used in a cell in Excel. If someone uses that formula on a spredahseet (let's say in cell F4) and then they recalc, is there some way for us in that xll code to know that the formula is in cell F4? thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
XLL Formula Reference
Hi Matthew,
I am sorry for confusion. I don't think there is such function to achieve your aim. Did Rob Bovey answer your question? Regards, Peter Huang Microsoft Online Partner Support Get Secure! www.microsoft.com/security This posting is provided "as is" with no warranties and confers no rights. -------------------- Date: Fri, 19 Sep 2003 09:59:11 -0400 From: Matthew Wieder User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en, he MIME-Version: 1.0 Subject: XLL Formula Reference References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Message-ID: Newsgroups: microsoft.public.excel.programming NNTP-Posting-Host: 207.106.112.178 Lines: 1 Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftn gp13.phx.gbl Xref: cpmsftngxa06.phx.gbl microsoft.public.excel.programming:417361 X-Tomcat-NG: microsoft.public.excel.programming You gave VBA code, but I need to know IN THE XLL (C++) how to do it. Also, what you wrote is backword - is there is a formuale currently evalutaing, I need to know what cell that formula is in; not what you gave which is what formula is in a certain cell. thanks! Peter Huang [MSFT] wrote: Hi Matthew, You may try to use the range.formula. Here is my code. Sub f() Msgbox ActiveSheet.Range("F4").Formula End Sub Did this answer your question? Regards, Peter Huang Microsoft Online Partner Support Get Secure! www.microsoft.com/security This posting is provided "as is" with no warranties and confers no rights. -------------------- Date: Thu, 18 Sep 2003 16:56:27 -0400 From: Matthew Wieder User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en, he MIME-Version: 1.0 Subject: XLL Formula Reference Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Message-ID: Newsgroups: microsoft.public.excel.programming NNTP-Posting-Host: 207.106.112.178 Lines: 1 Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftn gp13.phx.gbl Xref: cpmsftngxa06.phx.gbl microsoft.public.excel.programming:417179 X-Tomcat-NG: microsoft.public.excel.programming We inherited an xll which provides a formula that can be used in a cell in Excel. If someone uses that formula on a spredahseet (let's say in cell F4) and then they recalc, is there some way for us in that xll code to know that the formula is in cell F4? thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
XLL Formula Reference
he's working on it.
thanks. Peter Huang [MSFT] wrote: Hi Matthew, I am sorry for confusion. I don't think there is such function to achieve your aim. Did Rob Bovey answer your question? Regards, Peter Huang Microsoft Online Partner Support Get Secure! www.microsoft.com/security This posting is provided "as is" with no warranties and confers no rights. -------------------- Date: Fri, 19 Sep 2003 09:59:11 -0400 From: Matthew Wieder User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en, he MIME-Version: 1.0 Subject: XLL Formula Reference References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Message-ID: Newsgroups: microsoft.public.excel.programming NNTP-Posting-Host: 207.106.112.178 Lines: 1 Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftn gp13.phx.gbl Xref: cpmsftngxa06.phx.gbl microsoft.public.excel.programming:417361 X-Tomcat-NG: microsoft.public.excel.programming You gave VBA code, but I need to know IN THE XLL (C++) how to do it. Also, what you wrote is backword - is there is a formuale currently evalutaing, I need to know what cell that formula is in; not what you gave which is what formula is in a certain cell. thanks! Peter Huang [MSFT] wrote: Hi Matthew, You may try to use the range.formula. Here is my code. Sub f() Msgbox ActiveSheet.Range("F4").Formula End Sub Did this answer your question? Regards, Peter Huang Microsoft Online Partner Support Get Secure! www.microsoft.com/security This posting is provided "as is" with no warranties and confers no rights. -------------------- Date: Thu, 18 Sep 2003 16:56:27 -0400 From: Matthew Wieder User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en, he MIME-Version: 1.0 Subject: XLL Formula Reference Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Message-ID: Newsgroups: microsoft.public.excel.programming NNTP-Posting-Host: 207.106.112.178 Lines: 1 Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftn gp13.phx.gbl Xref: cpmsftngxa06.phx.gbl microsoft.public.excel.programming:417179 X-Tomcat-NG: microsoft.public.excel.programming We inherited an xll which provides a formula that can be used in a cell in Excel. If someone uses that formula on a spredahseet (let's say in cell F4) and then they recalc, is there some way for us in that xll code to know that the formula is in cell F4? thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set a formula, that add next cell reference in a Formula | Excel Worksheet Functions | |||
Reference formula | Excel Discussion (Misc queries) | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Look Up Reference Formula | Excel Discussion (Misc queries) | |||
Is it Possible in a formula to have a formula for cell reference? | Excel Worksheet Functions |