I am creating a macro in excel 2002. In the macro I would like to
create a dropdown box that users choose a value from and then do
different things depending on what they choose.

Can this be done and can anyone point me in the right direction ?

Thanks
Paul Trower