adding user submitted items to a list

[The Grinch]

hello all, any help with this would be greatly appreciated...

there's a cell were a user is asked to input data, and a command butto
marked 'submit'. There is also a list.

When the button is clicked for the first time I require the underlyin
macro to place the inputted data into the 1st position in the list (n
problem so far). However when the button is clicked for the 2nd time
require the macro to place that data in the 2nd position... ie eac
time the button is pressed the list grows.

how do I write the macro to ensure the data is inputted one row dow
from the last inputted piece of data?

CHEER

 

[jeff]

Hi, Grinch,

Add code like this to your insert:

lastrow = ActiveSheet.Cells(Rows.Count, "C").End(xlUp).Row
Range("C" & lastrow + 1).Value = Range("A1")

(It's using cell A1 as you input value and Column C to
append values to)

jeff

 

[The Grinch]

Thanks very much Jeff!