Hi Coleman,

I'm pretty lazy and always try to use a non vba solution first. Have you ever heard of or seen the Excel (built in) Form tool? You can add the icon for it on the Quick Access Toolbar and use it instead of your form. See:
http://office.microsoft.com/en-us/ex...010236698.aspx

Now - if you really need the dropdown to select a certain record, I'd grab the Enhanced Forms Tool off the site:
http://spreadsheetpage.com/index.php/dataform/home - pay to see the code and see if you can modify it for your non-commercial use.

Then I'd have a small talk with your boss on how to use standard tools instead of having you create unique ones.