Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox question
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combobox question | Excel Programming | |||
ComboBox question | Excel Programming | |||
Combobox Question | Excel Programming | |||
ComboBox Question | Excel Programming | |||
ComboBox Question | Excel Programming |