 Vlookup In Vba/excel, Can't doooooo it :( |
|
|
|
|
  |
 Mar 5 2007, 11:18 AM
Post
#1
|
|
|
Privileged Member  Group: [HOSTED] Posts: 524 Joined: 19-May 06 From: Leeds, UK Member No.: 23,963  |
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: CODE Private Sub CommandButton1_Click() Label1.Caption = Application.WorksheetFunction.VLookup("Gateway Plaza", "C3:C26", 1, False) End Sub 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 |
 |
 
|
|
Similar Topics
|
Lo-Fi Version | Time is now: 5th July 2008 - 11:23 PM |