Dim rng as Range, i as Long
set rng = Worksheets("Sheet1").Range("B9")
for i = 1 to 5
rng.offset(i-1,0).Value = userform1.Controls("Textbox" & i).Value
Next


obviously there is not enough detailed information to give you anything like
a substantive answer.

--
Regards,
Tom Ogilvy




"vhrao" wrote in message
oups.com...
I have a list with several options. I also have a defined fixed range
of cells. For each option in the list I want to store the values
entered by user inside the range of cells. Basically I want to maintain
an array where each array element can store values for the defined
range of cells
How can I do this? Thanks for you help.