Macros andfunctions

  • Thread starter Thread starter Luke Vogel
  • Start date Start date
L

Luke Vogel

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)
 
Hi
yes it is possible if this macro is a Function (and only returns a value)
 
Now that is curious ... in a previous post a similarly question got a
negative response.

Any chance of a more detailed example?

Thanks

Luke.
----------------------------------------
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro that will insert a simple text string in top cell of text file 1
D'you know: Workbook_Open is not called first(!) 1
macro on different reports CTRL+F in formula 2
Referencing a cell value in a macro 7
Storing VBA Code In a Cell to Use real Time 2
OnTime Change_Event macro AND copy to sheet2 macro trouble 7
Running macro operations in serial fashion 6
Need Macro... 8

Back
Top