excel VBA to select specific rows

[dodong]

I have created a userform in excel VBA use as a data entry form and I
have created this VBA code:

iRow = ws.Cells(Rows.Count, 3).End(xlUp).Offset(1, 0).Row

ws.Cells(iRow, 3) = TextBox1.Value

My problem is how to set this code to start the data from row 10 and
column 3, because currently it start from raw 2 and column 3.

Thanks very much for the help.

 

[ozgrid.com]

ws.Cells(10, 3) = TextBox1.Value

 

[dodong]

ws.Cells(10, 3) = TextBox1.Value

--
Regards









- Show quoted text -

Thanks for your quick reply. However, when I try to change with iRow
with 10 it overwrite the first data tha I entered. I need it to loop.

 

[Dave Peterson]

I'd qualify the Rows.count, too.

with ws
iRow = .Cells(.Rows.Count, 3).End(xlUp).Offset(1, 0).Row
if irow < 10 then
irow = 10
end if
.cells(irow,3).value = textbox1.value
end with