I'm new to VBA and i'm trying to write a vlookup function to search different sheets when given information and what sheet to look on. the code i have so far is for a command button:
Dim Sheet as String
Dim Price as Double
Dim OD as Double
Price1 = WorksheetFunction.VLookup(OD...
I'm having the exact same problem. I understand everything that has been written so far, but i have one question. What object has to be referenced? Actually i'm not even sure i know what the definition of an object is, because i am very new at this. Is it like the text box i need to refernce...
