Excel VBA Combo box

Hi Andy, thanks for your query. You could achieve this by modifying our code on the Excel VBA intro intermediate course, in which we loaded up two comboboxes from lists on a worksheet. We simply looped through a list on a worksheet and added the cell values into the combobox. However, you could add in an IF test to see whether each successive cell value was equal to the combobox.value property selected by the user and if it was to skip it, move on to the next iteration of the loop, thereby filtering out those values from the second combobox list. This sounds involved but shouldn't take any more coding than you have already achieved on the Intro Intermediate course. Have a try, and if you need any further assistance, drop me a line back and I'll post the code here.

Hope this helps,

Anthony