Help with Textbox control Please!

**JJFletcher** · 10-17-2014, 04:57 PM

Hello All,

I think I posted this in the wrong section. so sorry about that

Hello All,

I have a TextBox Control that has the following code

Please Login or Register  to view this content.

I have assigned the Scrollbar to it using the properties - but I now need to link the Textbox to the following Cell in another sheet

Please Login or Register  to view this content.

I do not know how to use the above code and incorporate the cell so the Textbox loads the cell data

Please Advise !

Best Regards,

John

**Bernie Deitrick** · 10-17-2014, 09:22 PM

John,

Don't use a textbox - insert an ActiveX Listbox, and use your cells as the ListFillRange (without the equal sign)

EmployeeData!Q20:U33

and set the column count to 5.

Note that you can only get the first column of values into the linkedcell as output.