Macros andfunctions
 

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
-----

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
-----

Macros andfunctions
 

Now that is curious ... in a previous post a similarly question got a
negative response.

Any chance of a more detailed example?

Thanks

Luke.
----------------------------------------
"Frank Kabel" wrote in message
...
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
-----