Duplicate items in Listbox to populate in textbox and change

Hi Gurus,

I have a Userform with Listbox,Textbox,Combobox and Commandbutton

In Sheet1, I have Data from A-F.

The below code display the Columns A, B and C in Listbox which is in 'WAITING FOR APPROVAL' status only.

Please Login or Register  to view this content.

The below code display Column A (depends on the user when he/she double click the item) in textbox1.

Please Login or Register  to view this content.

When the user chose the number, the commandbutton should be perform to change the status (items in Combobox1 and which is in Column F in the sheet) of that number. Now, my problem is, sometimes there are duplicate number in Column A, i just want, when that number has a duplicate and when i change the status of that number, i want to change the status of all duplicate numbers.

I've attached my file.
I've stuck here for almost 3 days

Thanks in advance Gurus!

Woohooooooooooo!!!

I've tried it and IT WORKS!!!!!!!!!!

I will now call you Robert My Savior! (bow head)

THANK YOU SO MUCH ROBERT!!!!!!!!!