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

excelledsoftware · #1 05-30-2015, 10:32 AM

Quote:

Originally Posted by jyfuller

Hi excelled software,

At the For statement at the end of the macro I also noticed that:

CountData =Oshp.TextFrame.Characters.Count+1

The number of characters in the cell is NOT being counted by the statement and the CountData variable is set to 1 character. I think this should be counting the number of characters in the entire length of text in the cell. I'm not sure why this is, but this is also a problem.

J

I am looking into the first issue but this one above actually is the intended way. I am counting the characters in the shape so we can append the other values into it. The reason it shows 1 is because that is the first time it runs when there are no characters in the shape. It goes to 1 because of the + 1. The value of the cell is then put into the shape.

I am guessing the reason the object error happened was because the normal versions of office have a different syntax. I still use 2003 mostly because it is the most stable in my opinion and allows me to customize exactly how I need.

I am running office 2013 in a VM and will see if the code works there. I will get back to you as soon as I can with my findings.

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