| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Substitute a variable in a loop
I have a multiple text boxes in a form (excel 2000) that are named:
cMake01, cMake02 cMake03 etc.. I want to save the info from my form to a worksheet. instead of: ActiveCell.Offset(0, 1) = cMake01.Value ActiveCell.Offset(0, 2) = cMake02.Value ActiveCell.Offset(0, 3) = cMake03.Value I want to do it in a loop: For i = 1 To 3 ActiveCell.Offset(0, 2) = "cMake0" & i & ".Value" Next But now the values in my worksheet a "cMake01.Value"....."cMake03.Value" What is the correct syntax to save the content of the text box and not the name? regards Mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Loop with variable name? | Excel Discussion (Misc queries) | |||
| =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE.... max. limit 8 :( | Excel Discussion (Misc queries) | |||
| loop for-next with variable end | Excel Programming | |||
| SUBSTITUTE formula -- variable spacing between parameters?? | Excel Worksheet Functions | |||
| For Each ... Next loop - need to reference the loop variable | Excel Programming | |||
Threaded Mode
