| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Zero-Length string vs Zero (also a valid value) | Excel Worksheet Functions | |||
| Formula to check against a list of valid values | Excel Worksheet Functions | |||
| How to check valid Date value? | Excel Worksheet Functions | |||
| Valid SQL string | Excel Discussion (Misc queries) | |||
| check for valid file | Excel Programming | |||
![Adrian[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
