Hi,

I`m simply trying to export the text out of Multuple TextBoxes on
differnt Excel Worksheets in an ACCESS DB. This works fine as long as
I address only one TextBox:

Dim Text as String ' Temporary text Storage
Dim TableName as String ' Name of Tabel I want to access

' Name of TextBox1 = Comment

Text = Worksheets(TableName).Comment.Text

I have a List of all of the TextBox Names and now wanted to loop
through then always writing the content into the temporary String
"Text" and then export the Data. How can I address/access the text in
different TextBoxes during runtime ? The Item funktion doesn`t work:
e.g

Dim TextBoxName as String ' name of the TextBox I want to access

Text = Worksheets(TableName).Item(TextBoxName).Text

Thanx in advance for your help
Tim


--
TimBro
------------------------------------------------------------------------
TimBro's Profile: http://www.excelforum.com/member.php...o&userid=14912
View this thread: http://www.excelforum.com/showthread...hreadid=265419