Populating a cell based on combobox data
 

I am trying to make this work but can't seem to figure it out.

I have a combobox populated from a worksheet that has two column
Jobcode and jobtitle

I want to be able to type a jobcode in column F5:F2000
I want the jobcode to be found in the combobox and then load th
Jobtitle in column G5:G2000

Each row will have a differant jobcode and some rows will have the sam
jobcodes as other rows.


I can achieve what I want using the following,

Me.ComboBox1.Text = Range("F5").Value
Range("G5") = ComboBox1.Column("1")

But how do I make it do the same thing without having to have 200
lines of code like above?

PLease help

Thanks
Charle

--
mrdat
-----------------------------------------------------------------------
mrdata's Profile: http://www.excelforum.com/member.php...fo&userid=1789
View this thread: http://www.excelforum.com/showthread.php?threadid=56264