userform data entry
 

i am new to userforms. i have created a userform that has three text boxes. i
can transfer the data from the userform to a spreadsheet,but what i want to
do is direct each entry to specified cells, eg 1:500, do i need another text
box to enter a number in it, then code to direct the entry
thankyou john

userform data entry
 

Dim nexrow as Long, rng as Range
With Worksheets("sheet1")
nextRow = .Cells(rows.count,1).End(xlup).row
if not isempty(.cells(nextRow,1)) then
nextrow = nextrow + 1
end if
set rng = .Cells(nextRow,1)
End with
Msgbox "I will enter my data in " & vbNewLine _
rng.Address & " to " & rng.offset(0,2).Address

--
Regards,
Tom Ogilvy

"john tempest" wrote:

i am new to userforms. i have created a userform that has three text boxes. i
can transfer the data from the userform to a spreadsheet,but what i want to
do is direct each entry to specified cells, eg 1:500, do i need another text
box to enter a number in it, then code to direct the entry
thankyou john