Run a sub every time a function is used in a sheet
You can check whether the function is called from the activecell.....
Function GetSomething(strData As String)
'your code
If Application.Caller.Address = ActiveCell.Address Then
'function called from the activecell...
'do something
End If
End Function
--
Jacob (MVP - Excel)
"Subodh" wrote:
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
.
|