Active-X text box with scrolling bar with vlookup option ?

Hello there guys, I was wondering if there is a VBA code to make an Active-X text box with scrolling bar to get the data from another sheet table (something like vlookup function). I have a data validation cell list with choices and I want to appear different content (always in the text box with scrolling bar) depending on the choice the user made in the drop down list cell.

I upload a sample file with some explanation on what I am looking for .

Thanks alot

What is a "text box with scrolling bar" ...?

Do you mean a drop down list (ComboBox)??

No no, the object I have at the A1 cell in Sheet1 of the example file is an Active-X text box. It's an object you get at the developer tab -> Insert ->Active-X controls - Text box. This is the only way, I know off, to make a cell having scroll bar. I basically want to put a very long text inside and to have the scroll bar in that cell so the user can read the content without the need of getting a huge Cell.

Hi,

Yes, you will need to use a VLOOKUP. Enter you VLOOKUP in a helper cell somewhere in your workbook. Then in your TextBox1 properties under "LinkedCell" enter the cell that contains your VLOOKUP.
When you change your pull down in B3 the contents of your TextBox1 in A1 will update accordingly.

Hope that makes sense and works for you.

Cheers

Southward you are my savior!! thanks alot man [Solved] and lots of Reputation stars! . Some times the solution is there and can't be seen hehehe thanks again.

Glad I could be of some assistance.

Cheers