Search results

By using this property you can tell which Event_Procedure has called a function. Useful if you have a function that can be called by a number of Event_Procedures and you need to know which procedure the call came from (this negates the need to pass a parameter to the function). Anyway, thanks...

Does anyone know the correct syntax to get the event property EventProcPrefix to work? I can't find the correct object to use. The code I need is something like this: Sub Cell59_Change() myFunction(EventProcPrefix) End Sub Function myFunction(strProc as String) .. {code} .. End Function What...

I think I might have found something that may work, but I need some help with it. The property EventProcPrefix looks like it could work, but I'm not sure what object to apply it it. I need some thing like this: Sub Cell59_Change() myFunction(EventProcPrefix) End Sub Function...

Both solutions you suggest have problems with the way I need them to work. I have a form with 100 input cells and when a cell is changed by a user, I need to be able to change other cells depending on what cell was changed by the user, hence needing to know the calling subprocedure. Solution 1...

How can you identify the name of the SubProcedure that called a Function. Surely the function must know where it's return address is? The problem I'm trying to solve is this: I've set up a function which could be called from any number of SubProcedures, but I need to be able to detect which...