Copy test to form
OK, what if the test boxes actually have names?
I could rename them I guess.
"Toppers" wrote in message
...
one way:
For i= 1 to 15
me.controls("txt" & i).value=Cells(activerow,i)
next i
if text boxes are TXT1 to TXT15
HTH
"SMERTZ" wrote:
What is the best way to copy data from a row, lets say row 2 cells 1 thru
15
to 15 text boxes on a form?
txt1= activeRow column 1
txt2=activeRow column 2
txt3 = active row column 3
You get the idea: Most of the data is Text, but there are a few dates in
the cells
|