ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to check that a string is a valid formula ? (https://www.excelbanter.com/excel-programming/305534-how-check-string-valid-formula.html)

Adrian[_7_]
How to check that a string is a valid formula ?
 
Hi,

How do you check in VBA code that a string is a valid formula ? Thanks.
--
Regards,
Adrian

Frank Kabel
How to check that a string is a valid formula ?
 
Hi
try using Application.evaluate for this

--
Regards
Frank Kabel
Frankfurt, Germany


Adrian wrote:
Hi,

How do you check in VBA code that a string is a valid formula ?
Thanks.

Adrian[_7_]
How to check that a string is a valid formula ?
 
Hi,
Do you mind explaining in detail ?
Thanks.

--
Regards,
Adrian
"Frank Kabel" wrote in message
...
Hi
try using Application.evaluate for this

--
Regards
Frank Kabel
Frankfurt, Germany


Adrian wrote:
Hi,

How do you check in VBA code that a string is a valid formula ?
Thanks.

Frank Kabel
How to check that a string is a valid formula ?
 
Hi
e.g. try
msgbox application.evaluate("=A1+A2")

--
Regards
Frank Kabel
Frankfurt, Germany


Adrian wrote:
Hi,
Do you mind explaining in detail ?
Thanks.

Hi
try using Application.evaluate for this

--
Regards
Frank Kabel
Frankfurt, Germany


Adrian wrote:
Hi,

How do you check in VBA code that a string is a valid formula ?
Thanks.

Adrian[_7_]
How to check that a string is a valid formula ?
 
Thanks.. :-)

--
Regards,
Kok Hsing
(Guoxing)
"Frank Kabel" wrote in message
...
Hi
e.g. try
msgbox application.evaluate("=A1+A2")

--
Regards
Frank Kabel
Frankfurt, Germany


Adrian wrote:
Hi,
Do you mind explaining in detail ?
Thanks.

Hi
try using Application.evaluate for this

--
Regards
Frank Kabel
Frankfurt, Germany


Adrian wrote:
Hi,

How do you check in VBA code that a string is a valid formula ?
Thanks.

Peter T[_3_]
How to check that a string is a valid formula ?
 
Depending on what you're doing you may also want to check
that the first character is an "="

Regards,
Peter


Hi
e.g. try
msgbox application.evaluate("=A1+A2")

--
Regards
Frank Kabel
Frankfurt, Germany


Adrian wrote:
Hi,
Do you mind explaining in detail ?
Thanks.

Hi
try using Application.evaluate for this

--
Regards
Frank Kabel
Frankfurt, Germany


Adrian wrote:
Hi,

How do you check in VBA code that a string is a
valid formula ?
Thanks.

.


All times are GMT +1. The time now is 12:13 AM.

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