[VBA - UserForm] Change "Status" cells in all duplicated rows at the same time

  • [xpost][/xpost]





    I'm going to prepare program to increase efficiency & save time. I have an UserForm when I'm going to add some rows. UserForm below:

    After this, I have below situation where I have few rows duplicated by serial no in Column2.

    Serial number is my uniqe number everywhere & it's written always. Major row is always this one from the TOP. I have written a VBA code which is going to change "Status" in Column 10 but only for one TOP row but I need to modify this code to change the same column 10 in all dublicated row with the same serial no. Below is my code. Can you please help me with this ?

  • Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the URL from the address bar in your browser) to the cross-post. We are here to help so help us help you!

    Read this to understand why we ask you to do this

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!