I tried a textbox but it has a limit of 255 characters also.
Message boxes can contain more than 255 chars but they do not
reappear.
Since the problem is to be able to access data that exceeds 255
characters, the following code might be acceptable in each sheet's
module:
Private Sub Worksheet_Change(ByVal Target As Range)
If Len(Target.Text) 255 Then
Open "C:\Excess.txt" For Output As #1
Write #1, Target.Text
Close #1
End If
End Sub
Of course this could be improved by asking for specific file names for
example.
--
raypayette
------------------------------------------------------------------------
raypayette's Profile:
http://www.excelforum.com/member.php...o&userid=29569
View this thread:
http://www.excelforum.com/showthread...hreadid=574171