View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Macros andfunctions

Hi
yes it is possible if this macro is a Function (and only returns a value)

--
Regards
Frank Kabel
Frankfurt, Germany
"Luke Vogel" <not@_real_address schrieb im Newsbeitrag
...
Hi all ...

Probably a dumb question ...

Is it possible to directly execute a macro or a VBA program from a
built-in function?

I spose in the most simplest form a cell formula might be something
like:

=if(A1="TESTING VALUE", macro_name, VBA_procedure_name)

--
Regards Luke.
-----
There are 10 types of people in this world
Those that understand binary and those that don't
-----