I need to have an input box launch that would provide the user with a drop
down box of selections, then upon their selection, would take then to a
certain sheet of a workbook.

I can write the macro - what is baffling me is how to program the drop down
list into the input box instead of having the user type something.

Can this be done?