Userform : add value according selcet column range : Solved by (nilem)

hello evryone

if i click CommandButton1 then

pop a userform and

if i type in texbox1 (d2:d10) = value = 5 then [result d2:d10=5]
and
i type in texbox2 (f2:f10) = value = 6 then [result f2:f10=6]
and
i type in texbox3 (h2:h10) = value = 7 then [result h2:h10=7]
and
i type in texbox4 (j2:j10) = value = 8 then [result j2:j10=8] and click "add" button the data enter is complete and clear the all filed by click "clear" button

now next time the data enter after last value (like = Range("d:d" & Rows.Count).End(xlUp).Offset(1))
if i type in texbox1 (d11:d21) = value = 1 then [result d11:d21=1]
and
i type in texbox2 (f11:f21) = value = 2 then [result f11:f21=2]
and
i type in texbox3 (h11:h21) = value = 3 then [result h11:h21=3]
and
i type in texbox4 (j11:j21) = value = 4 then [result j11:j21=4] and click "add" button the data enter is complete and clear the all filed by click "clear" button


thanx a lot

haroon2015
sample