How to return many edit box values in a loop?????
Posted by naeblis on December 12, 2001 11:39 AM
I am trying to use a macro to return edit box values from a dialogue box.
My edit boxes are named box1,box2,...,box50
I would like to return the values of these boxes to a spreadsheet without having to list each one of these out. Like this...
for i=1 to 50
Sheets("my_SHEET").Range("a" & counter).Value="box" & i.value
As you can see above I can not figure out the right side of the equation to return the value of each box in this loop.
Can anyone help?