Using Lookup Function Formula in VBA

Hi Smarters!

I'm building a form in VBA (excel). I have a chart in my spreadsheet called "dipchart". It has Cm's and the corresponding L of fuel. In a regular excel sheet I can type a "cm" value in one box and have the corresponding Volume populate an adjacent cell using the following formula:

=LOOKUP(B10,'DipChart'!A$2:A2011,'DipChart'!C$2:C2011)

I would like to assign that formula in my VBA form. I've gotten as far as below. But of course it's pretty much laughing at me. My Look up textbox is called TCDCMDIP and the textbox that I'd like to populate is called TCDDIPCHARTVOL.

Please Login or Register  to view this content.