SBrooky
06-15-2012, 03:38 AM
Been struggling with this one for quite a while now and tried a few methods from googling with no help so I decided to turn to reddit!
I have a populated sheet and I want to find where 3 different combo boxes appear on the same line. Being the "clever dick" I am after trying other methods was on concatenate the 3 rows on the end of each row then simply look for the 3 comboboxes put together:
result = Application.WorksheetFunction.VLookup(ComboBox3.Text & ComboBox5.Text & ComboBox4.Text, sheet.Range("A1:N72"), 4, False)
So im trying to set 'result' as row 4 on the line which contains the result of ComboBox3&5&4 put together in that order in the area of A1:N72.
Looks legit to me but it comes back with a "Unable to get the VLookup property of the WorksheetFunction class".
I have remembered to do this:
Dim result As String
Dim sheet As Worksheet
Set sheet = ActiveWorkbook.Sheets("PriceMatrix")
Also if it makes any difference the concatenated results are in row N?
Any more info needed?
Please help!
I have a populated sheet and I want to find where 3 different combo boxes appear on the same line. Being the "clever dick" I am after trying other methods was on concatenate the 3 rows on the end of each row then simply look for the 3 comboboxes put together:
result = Application.WorksheetFunction.VLookup(ComboBox3.Text & ComboBox5.Text & ComboBox4.Text, sheet.Range("A1:N72"), 4, False)
So im trying to set 'result' as row 4 on the line which contains the result of ComboBox3&5&4 put together in that order in the area of A1:N72.
Looks legit to me but it comes back with a "Unable to get the VLookup property of the WorksheetFunction class".
I have remembered to do this:
Dim result As String
Dim sheet As Worksheet
Set sheet = ActiveWorkbook.Sheets("PriceMatrix")
Also if it makes any difference the concatenated results are in row N?
Any more info needed?
Please help!