Hi all , I hope this isn't asking too much, but i need some help. Unfortunately i cant post my own code on here due to my work restricting me. Anyway: I have 2 workbooks, lets call them wb1 and wb2, I am looking to get data from wb1 to appear in a drop down list and textbox on wb2. here is what i mean. Title Text Categories name 1 aa cat 1 name 2 bb cat 2 name 3 cc cat1 name 4 dd cat4 name 5 ee cat3 name 6 ff cat3 this is the spoof info i need to show. I need some code to do 2 things: 1, look for a category, and if it matches display the title in the drop down list. 2, when you select the title from the drop down list, show the text in a text box. I hope that someone will be able to help. Thanks in advance from a 1st time poster :)

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Excel VBA help

Thread starter steveyg101
Start date Jan 19, 2017

steveyg101

New Member

Jan 19, 2017

Hi all ,

I hope this isn't asking too much, but i need some help. Unfortunately i cant post my own code on here due to my work restricting me.

Anyway:

I have 2 workbooks, lets call them wb1 and wb2, I am looking to get data from wb1 to appear in a drop down list and textbox on wb2. here is what i mean.

Title	Text	Categories
name 1	aa	cat 1
name 2	bb	cat 2
name 3	cc	cat1
name 4	dd	cat4
name 5	ee	cat3
name 6	ff	cat3

this is the spoof info i need to show. I need some code to do 2 things:
1, look for a category, and if it matches display the title in the drop down list.
2, when you select the title from the drop down list, show the text in a text box.

I hope that someone will be able to help.

Thanks in advance from a 1st time poster