export data from a userform to a form in whorksheet

[s_samira_21]

Hi


I Have a userform that I really liked to print it. But I could nt find a way to do it as well as I want.


so I accepted My friends advice and I made a form in sheet1 and I want to send the data from userform to the sheet form and then print it.


I know this code is correct when the cells are one after the other:


dim i , ary


ary=array(txt1,txt2,txt3)


for i=0 to 2
cells(1,i+1)=ary(i).text
next i


but in my form the cells that shoud keep my data are seperated


for example one is a10 and on other as on d18 ,.....


so can I create an array that contains all my cells and then I use something like this:


dim i , ary,ary2


ary=array(txt1,txt2,txt3)
ary2=array(A10,D18,E8)


for i=0 to 2
ary2(i)=ary(i).text
next i


Thanks


Regards