| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concatanate variable name
Thanks.
"Jake Marx" wrote in message ... Hi choco140, You can't concatenate variable names directly, as VBA will not understand it. You can, however, work with the Controls collection to do this: Dim i As Integer For i = 1 To 4 Me.Controls("Date" & CStr(i)).Text = _ Sheets("Sheet1").Cells(i, 1).Value Next i |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CONCATANATE | Excel Worksheet Functions | |||
| Runtime Error '91' Object variable or With block variable not set | Excel Discussion (Misc queries) | |||
| variable height variable width stacked bar charts | Charts and Charting in Excel | |||
| why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
| Formatting range in concatanate | Excel Discussion (Misc queries) | |||
Hybrid Mode
