How would I go about writing VBA code that will ask for the user to input
number that the macro will then search for?

I will be using this macro to look for promotion numbers that change
quarterly and I would like to be able to have a message box pop up asking
for the promo number. After I enter the promo number, the macro would
search for the number I entered.

Thank You.

Daryl Timm