VBA Basic Function returning null

Question

I have a very basic function that is to return symbols such as "=", ">","<",">=", and "<=" and it is only returning a null value. any Ideas?

Function Lookup_Symbol(search_Name As String) As String
    Lookup_Symobl = DLookup("[Symbol]", "[Search_Names]", "[Search_Name]= '" & search_Name & "'")
End Function

when I do a Debug.print DLookup("[Symbol]", "[Search_Names]", "[Search_Name]= '" & search_Name & "'") it will return =

I guess I'm not, I just assumed that it was, it may only be "" — 3xGuy
– 3xGuy, Commented Jul 29, 2015 at 12:10

Mark Butler · Accepted Answer · 2015-07-29 15:22:59Z

1

Because you have misspelled Lookup_Symbol in your function. It should be:

Function Lookup_Symbol(search_Name As String) As String
    Lookup_Symbol = DLookup("[Symbol]", "[Search_Names]", "[Search_Name]= '" & search_Name & "'")
End Function

You would have been able to spot this much easier if you had Option Explicit at the top of the module; it would then have told you that the variable Lookup_Symobl is not defined.

edited Jul 29, 2015 at 15:22

answered Jul 29, 2015 at 13:18

Mark Butler

8951 gold badge5 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

VBA Basic Function returning null

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related