Convert Excel Formula to VBA function
Posted on 2014-02-13
I have this formula in my Excel sheet:
It's works beautifully. However, I would like to make it into a VBA function that takes arguments as it is used over and over again in this worksheet. I simply cannot figure out the syntax.
Here is the shell of the formula...and nothing I have entered in thus far has given any results.
Public Function findDate(caseName As String, eventName As String) As Date