Easy ComboBox Question (Formula)

[monagan]

I need to know how to use a combobox in a formula.

I have combobox2 with cities

I need to do =VLOOKUP(ComboBox1.value,MyTable,2,0)

What do I need to use instead of ComboBox1.value
because I get #name? error

 

[jfhewitt]

Use the value in the cell linked to the combo box rather than the box variable.

 

[ETID]

...Did you give up on the approach we we working on earlier?

 

[monagan]

ETID,

Yeah I did. I try to stay away from code if I can. But I still like to work with it because I like to learn. Another person had told me about this so I'm trying this to reduce time.
I do appreciate it though, I've printed it out, and definately will be working on it.

jfHewitt,

I do not have a linked cell, this is how I'm filling the combo:

For i = 1 To ActiveWorkbook.Worksheets(1).Range(Me.ComboBox1).Count
Me.ComboBox2.AddItem ActiveWorkbook.Worksheets(1).Range(Me.ComboBox1).Cells(i, 1)
Next i