I'm abbreviating my descriptions to paint the picture.
I have a userform that has 2 comboboxes on it.
cmbPartNumber and cmbAccount
cmbAccount is 2 columns populated from a worksheet
For each row there is always a value in column 0 and sometimes a value in column 1
Click save on the userform...