Hi,


I have a userform for entry in/out movements of items however, the coding for out movements in my userform seem to have an issue of duplicate of entries in my range cells. My range cells is listed in worksheet =Movements!$A$2:$A$102 whereby when I entered another record and sort by item code there will be double entry in my listbox.

I want to keep the previous record and update a new entry in my list box, how can I do that? I have use offset codes but missing the error show as "Copy method class range failed"

Below is my code


Please Login or Register  to view this content.

Appreciate anyone who can help me on this, thanks


Imzhakmaya