linking cells to a text box

[imported_unknown]

I have managed to link one cell to a text box. Although I want to link several cells to a text box with multiple lines and font sizes. Can anyone help?

Thanks

 

[ROBINSYN]

IS THIS A TEXTBOX ON A USERFORM?

COULD YOU POST THE CODE.

 

[Ivan F Moala]

On 2002-10-06 23:14, Matrrix wrote:
I have managed to link one cell to a text box. Although I want to link several cells to a text box with multiple lines and font sizes. Can anyone help?

Thanks

If you mean a textbox within the Spreadsheet then
I don't think you can link multiple cells to a Textbox > limited to just ONE cell.
You could however try the camera Tool


Customize > Commands > Tools > select [Camera]

 

[Matrrix]

its in spread sheet view.

It got the idea from the Invoice template.

When you enter in the Business name and address in the cells provided it automatically updates some textboxs.

I'm pretty sure its VBA coding but my books dont tell me how to link the two.