Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I create a string from a range (Excel VBA)?
I want to create a userform that can string a selected range of cells to a
textbox. I can do it on predifend cells, but I want it to be flexible so that you can highlight the cells and then click a button that will string it. Can anybody help me with a link to a page that explain how to string from highlighted cells? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I create a string from a range (Excel VBA)?
Dim rng As Range
Dim cell As Range Dim str Set rng = Application.InputBox("Use mo=use to select cells", Type:=8) For Each cell In rng str = str & cell.Value & " " Next cell TextBox1.Text = str -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "JJ" wrote in message ... I want to create a userform that can string a selected range of cells to a textbox. I can do it on predifend cells, but I want it to be flexible so that you can highlight the cells and then click a button that will string it. Can anybody help me with a link to a page that explain how to string from highlighted cells? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create comma-delimited string from dynamic range? | Excel Discussion (Misc queries) | |||
making a text string recognizable as a name range in excel | Excel Programming | |||
Excel / Formatting a Cell / Setting a string range | Excel Programming | |||
Passing a String in Array to Range as String | Excel Programming | |||
Create a formula into a String then assign string to a cell | Excel Programming |