Macro/VBA code to select ALL text in a textbox in microsoft excel and add a new row

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Macro/VBA code to select ALL text in a textbox in microsoft excel and add a new row

FAQ

Thread Tools

Display Modes

05-20-2015, 11:00 PM

excelledsoftware excelledsoftware is offline

Macro/VBA code to select ALL text in a textbox in microsoft excel and add a new row

Windows 8

Office 2003

IT Specialist

Join Date: Jan 2012

Location: Utah

Posts: 455

excelledsoftware will become famous soon enough

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to select an { includepicture } field code and format the picture behind text and 100% scale	sanpedro	Word VBA	3	03-30-2015 10:50 PM
Microsoft Word macro to find text, select all text between brackets, and delete	helal1990	Word VBA	4	02-05-2015 03:52 PM
VBA code for Microsoft Word macro — select text and insert footnote	ndnd	Word VBA	10	01-06-2015 01:47 PM
Outlook 2007 Code For Matching Textbox to a Combobox in a Different Form	lms	Outlook	4	07-03-2013 08:34 AM
Excel 2007 - formula or macro/vba code required	wrighty50	Excel Programming	3	05-13-2012 02:24 PM