Greetings,

First time posting here. I was wondering if I could get some help with a macro that I found (from another thread on this forum, very helpful!). I am wanting my drop down menu display one thing, but then when an item is clicked to return another value.

In the excel file found here, under the "Course Code" section, you'll see a drop down box that has course titles, I want them to change to the course code after a selection is made. I have the macro running and working with cell D3 but I need it to work for all of the drop down boxes. These will be the only drop down menus in this spreadsheet so if it applies to ALL drop downs that is fine.

I do not know VBA at all so I would appreciate some help.

Thanks!
Ben