| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA- inserting multiple cell values into single textbox
Slight typo...
Dim rngmyrange As Range 'Change the sheet name to the relevant sheet Set rngMyRange = ActiveWorkbook.Sheets("Sheet1").Range("A1") 'change dialogsheets(1).editboxes(1) to represent your userform and text box names... DialogSheets(1).EditBoxes(1).Text = rngMyRange.Offset(0, 0) & rngMyRange.Offset(0, 1) & rngMyRange.Offset(0, 2) & rngMyRange.Offset(0, 3) ' you might want to add in some spaces or commas .. 'rngMyRange.Offset(0, 0) & ", " & rngMyRange.Offset(0, 1) etc... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup multiple values - sum returned values into single cell | Excel Worksheet Functions | |||
| Multiple returned values into a single cell | Excel Discussion (Misc queries) | |||
| Indentify value from multiple values in a single cell | Excel Worksheet Functions | |||
| How to sum the values of a single cell from multiple worksheets | Excel Worksheet Functions | |||
| Toggle multiple values in single cell | Excel Worksheet Functions | |||
Threaded Mode
