Thread: get more than 255 characters from text box
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
  
Posts: 2,824
Default get more than 255 characters from text box
http://support.microsoft.com/default.aspx?id=148815
How to Copy Text to TextBoxes Using the Characters Method

might help.

woolfm wrote:

strText = ActiveSheet.TextBoxes("Text Box 1").Text

This code returns 255 characters from the text box. The text box displays
many more than 255 characters.

Anyone know how I can get the entire text from a text box?

--

Dave Peterson

Reply With QuoteReply With Quote