In the code I provided, there are several references to the Name of the combobox. If you want the code to work on a different combobox then the name of that object will need to match the name referred to in the code.

Select the combobox and then look at the Properties section of your VBA editor to change its name. If you give it a more descriptive name then make sure that is reflected in the code

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia