You obviously want this work in a different way: can you post your w/book to
me as it is impossible to advise you without understanding clearly what you
are doing different?

In the original example, the whole of Input form has to be filled, so you
cannot only fill columns A & B. Are you saying you only want to enter the
"Entry Date" & "Person" once?

toppers <at johntopley.fsnet.co.uk

"kyoshirou" wrote:

http://www.contextures.com/xlUserForm01.html

i have realised that the sample above have some limit.
for example, if inside PartsData sheet, A2 and B2 has been filled,
and i go to Input sheet to insert new data, the newly data will be inserted
at A3 and B3.
Why is it so? How can i modify it?