create dialog box within macro and use value chosen

[trower2002]

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

 

[depuyus]

Check out this sleek macro for listboxes. I used it in my spreadshee
and it works great!


http://www.lacher.com/#Free Excel Example

 

[trower2002]

thanks for the message but I don't want to buy something

all i want to know is how to invoke a listbox in a macro and how to
grab the choice made

thanks
paul