Hello all,

New user here. I have been searching far and wide for a solution to this problem. I am new to macros, but have been gaining knowledge from searching forums like this one. This is the first time I have felt completely stuck.

I am attempting to use VLookup to place a value in a msgbox based on the value entered in a user form.

Here is what I have so far: (I have tried 100's of different variations of this. sub is ran by a command button)

Sub EditAdd()

MsgBox ("There are currently " & Application.WorksheetFunction.VLookup(TextBox1.Value, Sheets("Inventory").Range("a3:z1000"), 2, False) & " in stock")

End Sub
I get only errors.

My end goal is to have an If statement so that if the item typed in does not exist I get:

Else
            MsgBox "Record not found!", vbExclamation
                End If
My Item Number is in column A and the quantity is in column B.

Thanks in advance for your help!