Combo Box Issue

[nparsons75]

I have a combobox on a userform that gets its data from a closed spreadsheet. The main isssue is that a serial number is typed into a form that send it to a database. From the database the combobox picks up the serial number. Once the operation has been complete I need it to no longer show in the combobox but I cannot delete it from the database it it is always needed in there. Does anyone know of a workaround? appreciate any help.

 

[nparsons75]

WOW, so close. It is working now (nearly). 0,3 means 3 to the right of the column F, I was thinking from A.

It is allowing the serial number to move to the next stage for FAIL. I need it to pass to stage 3 only if it states PASS. Is this easy to solve?

Thank you so much. I had had enough....

 

[dmt32]

WOW, so close. It is working now (nearly). 0,3 means 3 to the right of the column F, I was thinking from A.

It is allowing the serial number to move to the next stage for FAIL. I need it to pass to stage 3 only if it states PASS. Is this easy to solve?

Thank you so much. I had had enough....

at a guess, in that stage just make your Offset = "PASS"

For Each Item In rng
            If Item.Offset(0, 3).Value = "PASS" Then
                .AddItem Item.Value
            End If
        Next Item

 

[nparsons75]

I need the 2 criteria, pass and fail, I need to select pass, if the item is on, then it can move to the next stage. Fail means it can't pass on. The ones that equal pass are not showing, the fail ones are. Strange,

 

[nparsons75]

Just changed If Item.Offset(0, 3).Value <> "PASS" Then

to

If Item.Offset(0, 3).Value <> "FAIL" Then

 

[nparsons75]

Struggling to get this line working: Me.axlenumbox.RemoveItem (Me.axlenumbox.ListIndex)

The rest is working fine now thank you. I now need to remove the item from the combo box once submitted. It keeps appearing even after this line, im not sure if it is in the correct place of the code or if anything else requires adding?