Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy/paste text in cells into a textbox
Early today i tried to copy some text from a cell into a text box -
without success. Is this a weakness of excel? Does anyone know a good macro that, after i select a selection of cells, will copy this information into a text box? Ideally i'd like to keep the formating of the cells if possible - but obviously any suggestions would be great Many thanks --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy/paste text in cells into a textbox
If you're just copying and pasting, copy the information inside the
cells instead of the cells themselves. You'll have to do that one at a time. If you're doing something with VBA, do something like this: var1 = Cells(1, 1).Value & Cells(1, 2).Value & Cells(1, 3).Value TextBox1.Text = var1 - Pikus --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trying to copy and paste line of text into multiple cells | Excel Discussion (Misc queries) | |||
How do I copy the contents of a range of text cells and paste into one cell? | Excel Discussion (Misc queries) | |||
how can we copy cells comments text and paste to cells | Excel Discussion (Misc queries) | |||
How do I edit, copy and paste text in excel cells? | New Users to Excel | |||
How to copy text from a TextBox in a ActiveSheet to a variable | Excel Programming |