Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Yet Another VLOOKUP issue in VBA
Anyone know what I am doing wrong?
Here is a snip of my code: ' Calculate Yardage Set CapRange = Worksheets("TruckInfo").Range("TruckData") Set truck = Me.cboTruckID Set PerFull = Me.txtPerCap TruckCap = Application.VLookup(truck, CapRange, 8, False) vTruckYard = TruckCap * PerFull The "truck" variable is getting set correctly (long type) The "PerFull" variable is getting set correctly (long type) The code hangs-up with the Vlookup segment ("Type mismatch") Is there a special way to pass parameters to VLOOKUP inside of VBA? Help? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Yet Another VLOOKUP issue in VBA
TruckCap = Application.VLookup(truck.Value, CapRange, 8, False)
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Bill" wrote in message ... Anyone know what I am doing wrong? Here is a snip of my code: ' Calculate Yardage Set CapRange = Worksheets("TruckInfo").Range("TruckData") Set truck = Me.cboTruckID Set PerFull = Me.txtPerCap TruckCap = Application.VLookup(truck, CapRange, 8, False) vTruckYard = TruckCap * PerFull The "truck" variable is getting set correctly (long type) The "PerFull" variable is getting set correctly (long type) The code hangs-up with the Vlookup segment ("Type mismatch") Is there a special way to pass parameters to VLOOKUP inside of VBA? Help? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Yet Another VLOOKUP issue in VBA
When I tried it, truck was a string value, even though it was a number
in the combobox. I could get it to work if I had text values in the lookup range first column, or if I declared truck as long. That is likely the Type Mismatch you are seeing. Do you have Dim Truck As Long somewhere? Are you sure it is a long? It is usually a good idea to declare all variables, which you might be doing, but just not showing it here. Len Bill wrote: Anyone know what I am doing wrong? Here is a snip of my code: ' Calculate Yardage Set CapRange = Worksheets("TruckInfo").Range("TruckData") Set truck = Me.cboTruckID Set PerFull = Me.txtPerCap TruckCap = Application.VLookup(truck, CapRange, 8, False) vTruckYard = TruckCap * PerFull The "truck" variable is getting set correctly (long type) The "PerFull" variable is getting set correctly (long type) The code hangs-up with the Vlookup segment ("Type mismatch") Is there a special way to pass parameters to VLOOKUP inside of VBA? Help? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Yet Another VLOOKUP issue in VBA
One mo
TruckCap = Application.VLookup(clng(truck.value), CapRange, 8, False) Bill wrote: Anyone know what I am doing wrong? Here is a snip of my code: ' Calculate Yardage Set CapRange = Worksheets("TruckInfo").Range("TruckData") Set truck = Me.cboTruckID Set PerFull = Me.txtPerCap TruckCap = Application.VLookup(truck, CapRange, 8, False) vTruckYard = TruckCap * PerFull The "truck" variable is getting set correctly (long type) The "PerFull" variable is getting set correctly (long type) The code hangs-up with the Vlookup segment ("Type mismatch") Is there a special way to pass parameters to VLOOKUP inside of VBA? Help? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup issue | Excel Worksheet Functions | |||
vlookup issue | Excel Discussion (Misc queries) | |||
Vlookup issue | Excel Discussion (Misc queries) | |||
VLOOKUP issue | Excel Worksheet Functions | |||
VLOOKUP issue | Excel Worksheet Functions |