How to check that a string is a valid formula ?

[Adrian]

Hi,

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

 

[Frank Kabel]

Hi
try using Application.evaluate for this

 

[Adrian]

Hi,
Do you mind explaining in detail ?
Thanks.

 

[Frank Kabel]

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

 

[Adrian]

Thanks..

--
Regards,
Kok Hsing
(Guoxing)

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

 

[Peter T]

Depending on what you're doing you may also want to check
that the first character is an "="

Regards,
Peter