Thread: Macro/VBA code to select ALL text in a textbox in microsoft excel and add a new row
View Single Post
 
Old 05-20-2015, 11:00 PM
excelledsoftware excelledsoftware is offline Windows 8 Office 2003
IT Specialist
  
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default
The macro recorder can really bloat things and is best used to get unknown snippets. We can make this code A LOT shorter. I need to validate a couple of things.
1. Is the data that you are copying to the text box all in 1 column?
2. Does the data on the worksheet have any blank rows between it.
3. Will all sentences end with a period?

If you could post a sample book I could write this pretty quickly for you.

Thanks
Reply With Quote