Thanks Peter, works fine for TextBoxes added from the drawing toolbar
as you said

Unfortunately these are limited to 255 Characters, therfore I am usin
the TextBoxes out of the control elemnts list, these aren´t limited a
therefor can contain a number of paragraphs. Like I said I can acces
this text using the line:

Text = Worksheets(TableName).Comment.Text

(where "comment" is the Name of the TextBox)
but I have a list of Names of Textboxes for whom I want to gather th
texts. How can I index the desired TextBox directly according to th
Name. interesstingly this works fine for Worksheets eg
Worksheets(TableName)

Any further ideas ?

Thanks again for your help
Ti

--
TimBr
-----------------------------------------------------------------------
TimBro's Profile: http://www.excelforum.com/member.php...fo&userid=1491
View this thread: http://www.excelforum.com/showthread.php?threadid=26541