Hi, I have a combobox on a userform that gets it's info from a seperate workbook (admin). What I would like it to do is that when the user selects one of the entries in the combobox, it automatically fills a textbox with the data directly to the left of the combobox source data..
Additional info:
Combobox = Combobox1
Source for combobox = Book 'Admin' sheet 'Data' range 'D5:D65536'
Source for Textbox fill = Book 'Admin' Sheet 'Data' range 'C5:C65536'
Textbox = Textbox1
Example:
If I select "CIS" in the combobox it will fill the textbox with "Marketing" as Marketing is in the cell to the left of CIS in the source sheet.
Hope this makes sense and somebody is able to help.
Thanks,
John.
Additional info:
Combobox = Combobox1
Source for combobox = Book 'Admin' sheet 'Data' range 'D5:D65536'
Source for Textbox fill = Book 'Admin' Sheet 'Data' range 'C5:C65536'
Textbox = Textbox1
Example:
If I select "CIS" in the combobox it will fill the textbox with "Marketing" as Marketing is in the cell to the left of CIS in the source sheet.
Hope this makes sense and somebody is able to help.
Thanks,
John.