Ok...I figure out 1 solution... That is, when user click on the EDIT
button, it will delete the row of the previous entries, before the user
submit the editted entries.

Any solution besides this..? I think this is not the best way to do
so...

About the Erase method, still no one can solve for me.. ? When I erase
the first entries in the listbox, it will change all my defined range
from:

=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),10)
change to the below:

=OFFSET(Sheet1!#REF!,0,0,COUNTA(Sheet1!$A:$A),10)

I hope someone is willing to shed the light for me...

Thanks...


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