The next free row can be found with

cNextFree = Worksheets("Sheet1").Cells(Rows.Count,"A").End(xlU p).Row+1

and you can use this for input with

Worksheets("Sheet1").Cells(cNextFree,"A").Value = ....

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Jsmith1181 " wrote in message
...
Hey.. kinda noob question here.

I'm creating a custom box where the user click it to enter data, form
pops up, he enters the data and its inputed into a worksheet in the
same workbook. The box and the input are fine, I think Ive got the
capture down as well, however inputing into the date base, and then
moving a new entry into the next row is where I become a little
confused. I'm thinking I've got each input to a variable? that right?
if so how does this input to a specified cell?

Any help on this would be great.

Oh also.... depending on the answer of the first input(probably a drop
down) determines the worksheet to be placed.

Thanks,
Jarad


---
Message posted from http://www.ExcelForum.com/