MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Text Box - Entering data

Posted by Brain Dead on May 16, 2001 6:52 PM

Hope somebody can help me out there :

A) Let's say you have a file with 10 bullet
points, each on a separate row A1 through A10.
B) You need to copy these bullets into a simple text
box - each on a separate row

Here's the dilemma:
1) Other than coping each row individually, How
can I get this data into a text box - so that
the Text box can be copied to another file.
* Selecting the rows & using copy, doesn't work.

Any and all suggestions are welcome

Posted by Right Behind You on May 16, 2001 7:46 PM

Yo! Brain Dead. Haven't heard from you lately.

Well, this is probably more work than you want, but here is what I tried, and it worked:

select the column of cells
choose copy
open MS-Word and paste
highlight the whole selection in Word and then convert Table to Text

Now you can copy it into your text box.

(void where prohibited by law, batteries not included, this end up.)


Posted by Dave Hawley on May 16, 2001 8:45 PM


Select cells A1:A10
Hold down the Shift key
Go to Edit>Copy Picture
Make your choice
Paste where you like.


OzGrid Business Applications

Posted by Benedick Dogberry on May 17, 2001 6:43 AM

Hey! Brain Dead's initials are the same as mine!

Posted by Brain Dead on May 17, 2001 8:42 AM

Thxs for help !!!!!
Take care and have a good day

Posted by Right Behind You on May 17, 2001 8:50 AM

This no worky.


This no worky inside textbox. Paste option not availble for the resultant "picture" into a textbox.

Posted by Dave Hawley on May 17, 2001 9:38 PM

It worky alright!

I don't know why you would want to place the "Picture" inside a Textbox, but if you must.
Drag the Picture inside the TextBox
Size and format it accordingly
Now from the "Drawing Toolbar" click the "Select Objects" arrow and select both the Picture and the TextBox.
Now righjt click and go to Grouping>Group.

That better ?


OzGrid Business Applications