I am trying to fill a combobox3 with values that are in another sheet.
The combobox is on a userform.

The condition is that i have a combobox2 above this one with 2 columns in it.
1 Column has a Name, the other has a Numerical value, and BOTH are displayed in the Combobox2 like
[name 123]

I am assuming Column 1 is the name, and column2 is the number ?

In the Combobox3 DropButton_Click event i want to have something logical like:

' Code
dim rngfound as cell
dim i as long
For i = 3 - 20
with sheet4.Row2
..select
Find Combobox2.Column2.Value
if rngfound ="" then
msgbox "No values exist"
else
Combobox3.additem rngfound.Offset( i, 0)
' So i want the values that are from 1 - 20 rows DOWN from the matching value in row 2 to the
Combobox2.Column2.value


Does this make sense??

How can i succesully code the above to work?

Corey....