Solved

# Convert Excel Formula to VBA function

Posted on 2014-02-13

I have this formula in my Excel sheet:

{=INDEX(B:B,MATCH(1,(C:C="caseName")*(F:F="eventName"),0),1)}

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

End Function