biker9
asked on
Excel VBA extract text in shapes
Hello Experts,
the code in the attached file code text in a shapes, in a sequential order, it seems based upon the successive value of the shape. Is it possible to modify the code so that it reads the text based upon the shapes position in given range, preferably a column then row, ….
ie: Column E, rows 11 through 85, then column F rows 11 through 85, column G rows 11 through 85 etc.
The result would read;
Text from 1
Text from 2
Text from 3
Text from 4
Text from 5 etc…
Thank you,
biker9
Paste-Excel-Shape-Text-to-Word-D.docx
Extract-text-from-shapes-2.xlsm
the code in the attached file code text in a shapes, in a sequential order, it seems based upon the successive value of the shape. Is it possible to modify the code so that it reads the text based upon the shapes position in given range, preferably a column then row, ….
ie: Column E, rows 11 through 85, then column F rows 11 through 85, column G rows 11 through 85 etc.
The result would read;
Text from 1
Text from 2
Text from 3
Text from 4
Text from 5 etc…
Thank you,
biker9
Paste-Excel-Shape-Text-to-Word-D.docx
Extract-text-from-shapes-2.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
fanpages, what can I say but Amazing and Seamless!
Thank you very much.
biker9
Thank you very much.
biker9
:)
No problem at all. I enjoyed working on something new (to me).
No problem at all. I enjoyed working on something new (to me).
pls try this to reorder your shapes
Open in new window
Regards