| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cutting and Pasting Cells into a shape or textbox
I have some cells of data where I would like to cut or copy the cells into
either a shape or textbox....can this be done? -- Gator |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cutting and Pasting Cells into a shape or textbox
1. create a textbox using the Drawing ToolBar
2. select the cell 3. copy the contents from the formula bar 4. paste into the textbox -- Gary''s Student - gsnu200794 "Gator" wrote: I have some cells of data where I would like to cut or copy the cells into either a shape or textbox....can this be done? -- Gator |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cutting and Pasting Cells into a shape or textbox
is there not a way to select a range of cells and copy that range in the text
box? -- Gator "Gary''s Student" wrote: 1. create a textbox using the Drawing ToolBar 2. select the cell 3. copy the contents from the formula bar 4. paste into the textbox -- Gary''s Student - gsnu200794 "Gator" wrote: I have some cells of data where I would like to cut or copy the cells into either a shape or textbox....can this be done? -- Gator |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cutting and Pasting Cells into a shape or textbox
You can do that with a macro.
-- Gary''s Student - gsnu200794 "Gator" wrote: is there not a way to select a range of cells and copy that range in the text box? -- Gator "Gary''s Student" wrote: 1. create a textbox using the Drawing ToolBar 2. select the cell 3. copy the contents from the formula bar 4. paste into the textbox -- Gary''s Student - gsnu200794 "Gator" wrote: I have some cells of data where I would like to cut or copy the cells into either a shape or textbox....can this be done? -- Gator |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cutting and Pasting Cells into a shape or textbox
This is just an example:
Sub Macro1() Dim s As String s = "" For Each r In Selection s = s & r.Value & Chr(10) Next ActiveSheet.Shapes.AddTextbox(msoTextOrientationHo rizontal, 404.25, 88.5, _ 187.5, 75#).Select Selection.Characters.Text = s End Sub I put a hard retrun between each cell's data. -- Gary''s Student - gsnu200794 "Gator" wrote: is there not a way to select a range of cells and copy that range in the text box? -- Gator "Gary''s Student" wrote: 1. create a textbox using the Drawing ToolBar 2. select the cell 3. copy the contents from the formula bar 4. paste into the textbox -- Gary''s Student - gsnu200794 "Gator" wrote: I have some cells of data where I would like to cut or copy the cells into either a shape or textbox....can this be done? -- Gator |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I freeze formulas when cutting and pasting other cells? | Excel Worksheet Functions | |||
| Cutting and Pasting with spaces | Excel Discussion (Misc queries) | |||
| Cutting and Pasting in Excel | Excel Discussion (Misc queries) | |||
| Cutting and Pasting cells from horizontal to multi vertical column | Excel Worksheet Functions | |||
| Formats when cutting and pasting | Excel Discussion (Misc queries) | |||
Linear Mode
