Problem with VLookup Function

[ritika787]

Hi, I am new to vba and i needed help in this. My excel sheet consist of table names and variables and i am using a simple vlookup function to get the corresponding variable names for the particular table but the function is not working.In this the user selects the table names from the combobox and then the listbox should enter the corresponding variable names.
my vlookup function for the Combobox is
ListBox1.Value=Application.WorksheetFunction.VLookup(Me.ComboBox1.Value, Range("B:C"), 2, False)

[Domski]

No code in your sample so hard to say but for starters your lookup range is in columns A:B, not B:C.

Dom

[Domski]

I notice you also posted this yesterday. Please read the forum rules. If you don't receive an answer bump the thread rather than posting a duplicate.

Dom

[ritika787]

Yeah i have changed that still it doesn't work. In my earlier post i wanted it in a different manner.

[Domski]

Okay but we're going to find it very difficult to help with a sample workbook that doesn't actually demonstrate the problem though.

Dom

[ritika787]

The following code is not working for selecting the corresponding variables and adding to the listbox after the user selects the table name from the combobox.
In my code cboTableName is the combo box
AddList is the ListBox in which i have to add the variable names

Public Sub cboTableName_Click()
Dim i As Integer
Dim lastrow As String
Dim Value As String

With Worksheets("Sheet1")

lastrow = .Cells(.Rows.Count, "B").End(xlUp).Row

AddList.Clear
For i = 2 To lastrow


AddList.AddItem .Cells(i, "B").Value = Application.WorksheetFunction.VLookup(Me.cboTableName.Value, Range("A:B"), 2, False)
Next i
End With

End Sub

[Domski]

Please edit your post to include code tags as per the FORUM RULES.

Dom

[ritika787]

Hi, the following attachment is my workbook on which i am working on. The code which i have written is not giving the output which i want and it is printing 0. I know for a list of variables to be entered in the listbox i should use some other function other than VLookupor case statements. But i don't know which one i should use so that it gives me the variables according to the table name which i have mentioned in the drop down box. I hope you could help me with that.

[Domski]

Are you going to edit your post?