TextBox - Needs to link to text in another sheet

[JJFletcher]

Hello All,

I have a TextBox Control that has the following code

  =EMBED("Forms.TextBox.1","")

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

  =EmployeeData!Q20:U33

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

[6StringJazzer]

Please update your profile to indicate what version of Excel you use.

Assuming 2007 or later, go to the Developer tab, and click Design Mode. Right click on the textbox. Select Properties from the pop-up menu. In the properties list, find LinkedCell and fill in EmployeeData!Q20:U33 (do not include "=").