Thread: How to check that a string is a valid formula ?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
  
Posts: 3,885
Default 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.

Reply With QuoteReply With Quote