Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run a sub every time a function is used in a sheet
I have a custom function in Excel
I want to run other sub lets say to display a msg box each time the function is used in the sheet (not each time the function is calculated) ie. only at the time the function is used in the sheet. lets say in coding i want the following Function myfunction (x as variant) as variant myfunction = x+x end function sub mysub () 'this should run each time the function 'my function is used in the cell 'not each time the function is calculated msgbox "Myfunction is used in the active cell" end sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Sheet - Calculating Time Differences for Totals | Excel Discussion (Misc queries) | |||
Calender function - time sheet - excel 2003/7 | Excel Worksheet Functions | |||
verify use of TIME Function, Find Quantity Level compare to time-d | Excel Discussion (Misc queries) | |||
Detailed Time Sheet (overtime, comp time, vacation used) | New Users to Excel | |||
Time Sheet Function | Excel Worksheet Functions |