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