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