Hi Lambs -

We'll get this back on track and the frustration will melt away...

It sounds like you added the control to the worksheet using the Forms
toolbar. Delete that dropdown control and add one using the Control Toolbox.
The Control Toolbox produces more modern controls that can be handled more
consistently. To add a combobox control from the Control Toolbox:

1. Turn on the Control ToolBox toolbar by right-clicking on any toolbar and
choosing 'Control Toolbox'.

2. Click on the Combobox button (in the toolbox) and draw your combobox on
the worksheet.

3. You'll see the new combobox appear with some circular "handles" along
its perimeter. That means you are in DesignMode and can edit the combobox
size and properties. Right-click the combobox and choose [Properties].

4. Find ListFillRange in the Properies window that opens and enter a
worksheet range that holds the list of options for the combobox, e.g.,
A10:A50.

5. At the top of the Properties window you'll see the 'Name' property.
Make a note of the name for later (it might be Combobox2, Combobox3, etc.
depending on how many you have constructed).

6. Close the properties window.

7. Double-click the combobox to open the worksheet module and copy the code
I provided there. Edit the name of the combobox in the VB code to match the
name noted in Step 5.

8. Switch back to the worksheet and turn off the Control DesignMode by
clicking the DesignMode icon in the Control Toolbox. Done.

------

Making an entry in the combobox should run its Change event. Good luck and
let me know what's next.

---
Jay