Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Vlookup in VBA
In excel I have created a user form, in which there is a label
("nonfincalcLabel"). I am trying to change the Caption of the label based on a calculation using Vlookup when a change is made to one of the comboboxes. The lookup table range is defined as "nonfinRange" in the worksheet "nonfinTable". When i try to run the code it says, Run-time error '1004': Unable to get the Vlookup property of the WorksheetFunction class. Below is my code, where am i going wrong? Private Sub defaulthistoryCombo_Change() Dim searchRange As Range Set searchRange = Worksheets("nonfinTable").Range("nonfinRange") nonfincalcLabel.Caption = Application.WorksheetFunction.VLookup(xCombo.Value , searchRange, 3, False) + Application.WorksheetFunction.VLookup(yCombo.Value , searchRange, 5, False) End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Vlookup in VBA
You have response to your other post in public.excel
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "prahz" wrote in message ups.com... In excel I have created a user form, in which there is a label ("nonfincalcLabel"). I am trying to change the Caption of the label based on a calculation using Vlookup when a change is made to one of the comboboxes. The lookup table range is defined as "nonfinRange" in the worksheet "nonfinTable". When i try to run the code it says, Run-time error '1004': Unable to get the Vlookup property of the WorksheetFunction class. Below is my code, where am i going wrong? Private Sub defaulthistoryCombo_Change() Dim searchRange As Range Set searchRange = Worksheets("nonfinTable").Range("nonfinRange") nonfincalcLabel.Caption = Application.WorksheetFunction.VLookup(xCombo.Value , searchRange, 3, False) + Application.WorksheetFunction.VLookup(yCombo.Value , searchRange, 5, False) End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Vlookup in VBA
See your other post.
prahz wrote: In excel I have created a user form, in which there is a label ("nonfincalcLabel"). I am trying to change the Caption of the label based on a calculation using Vlookup when a change is made to one of the comboboxes. The lookup table range is defined as "nonfinRange" in the worksheet "nonfinTable". When i try to run the code it says, Run-time error '1004': Unable to get the Vlookup property of the WorksheetFunction class. Below is my code, where am i going wrong? Private Sub defaulthistoryCombo_Change() Dim searchRange As Range Set searchRange = Worksheets("nonfinTable").Range("nonfinRange") nonfincalcLabel.Caption = Application.WorksheetFunction.VLookup(xCombo.Value , searchRange, 3, False) + Application.WorksheetFunction.VLookup(yCombo.Value , searchRange, 5, False) End Sub -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |