+ Reply to Thread
Results 1 to 1 of 1

Populating a cell based on combobox data

  1. #1
    Forum Contributor
    Join Date
    12-31-2004
    Posts
    160

    Question 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 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
    Last edited by mrdata; 07-18-2006 at 05:40 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1