Vlookup In Vba/excel

What I'm trying to do is have it that when you click a command button ("CommandButton1" name will be changed later on ), it looks up a value on the work sheet "TimeTable" and changes the caption ("Label1" again will change it ) on the form "UserForm1".

What I have is some simple code:


At first I kept getting "Run time error 13" but I added "WorksheetFunction" and then I started getting "Run time error 1004: Unable to get the Vlookup property of the WorksheetFunction Class"

How do I fix it?

Edit: Haha, I didn't need to use Vlookup All I had to do was:
Label1.Caption = Range("C3")

Close topic please

This post has been edited by Dagoth Nereviar: Mar 5 2007, 11:26 AM

Vlookup macro
Vlookup In Vba/excel

Dear all, if anybody could help me creating a vlookup macro using offset. Data is too large so I need a macro which work fast. Sheet1 contains folio in coloum A and units in coulumn B. Sheet2 contains the same. I want compare the units for same folio in coulumn C.

Thanks in advance

-question by Sandeep