Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default run a macro inside of a function

I want to run instantly a macro when value of a cell is changed (the value of
this cell is being control by a user function). It means €œIs it possible run
a macro inside of a function?€
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,440
Default run a macro inside of a function

You can run a macro in a function, but it will not be able to change anything in the Excel environment so its use is limited. This
restriction is only if the function is called from a worksheet formula, directly or indirectly.
Look at Event Procedures:

http://www.cpearson.com/excel/events.htm


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"A.Niaki" wrote in message ...
|I want to run instantly a macro when value of a cell is changed (the value of
| this cell is being control by a user function). It means "Is it possible run
| a macro inside of a function?"


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
using a cell value to control a counter inside a macro and displaying macro value ocset Excel Worksheet Functions 1 September 10th 06 05:32 AM
Macro does not function inside a list control Stephen Giles Excel Programming 0 August 8th 06 08:35 PM
HELP NEEDED FOR IF Function Inside a Macro Sandi Excel Worksheet Functions 1 June 2nd 06 04:14 AM
Nesting Networkdays function inside and If function Addison Excel Worksheet Functions 2 April 13th 06 08:04 PM
SUMIF Function Inside SUMPRODUCT Function Abdul Waheed Excel Worksheet Functions 17 September 19th 05 04:24 PM


All times are GMT +1. The time now is 09:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"