Embed Data from a named Range into a text box

[rrcd124]

I'd like to be able to pull data entered into a worksheet area that has a
named range and embed the data in the named range area into a text box that
updates as the data is updated. This all w/i the same workbook

 

[joel]

I would use a listbox instead of a text box. Add listbox from Contol tool
box toolbar (not forms). Put the named area into the listfilrange and change
the column count property to the corrrect number of columns.

 

[rrcd124]

Thanks for the input....now I'm struggling w/getting the text from each cell
to map over ie if I have text in B6 in the named range and the text bleeds
over into C6, D6 it apprears truncated in the list box??? Any thoughts

 

[joel]

That is why I said to change theh column Count. this method works great when
all the data is in one column. when the data is in multiple columns you have
to change the column count property.