Thanks Matt, this method worked perfectly for me.

"MattShoreson" wrote:


use a dynamic range to name the two columns, e.g. "countries"

then use

Sub comboBox1_Change()
with me

.comboBox2.value =
application.worksheetfunction.vlookup(.combobox1.v alue,countries,2,false)

end with
End Sub


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=535571