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 columns 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 the Jobtitle in column G5:G2000
Each row will have a differant jobcode and some rows will have the same 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 2000 lines of code like above?
PLease help
Sorry about the double post I thought I lost it computer went crazy
Thanks
Charles
Bookmarks