| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ----- |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 ----- |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 ----- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| weird saving of a document with macros resulting with macros being transfered to the copy | Excel Programming | |||
| Open workbook-macros enabled, opening another with macros | Excel Programming | |||
| Macro Size Limit / open macros with macros? | Excel Programming | |||
| Macros not appearing in the Tools Macro Macros list | Excel Programming | |||
| Suppress the Disable Macros / Enable Macros Dialog | Excel Programming | |||
![Luke Vogel[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
