create dialog box within macro and use value chosen
 

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

create dialog box within macro and use value chosen
 

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


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

--
Message posted from http://www.ExcelForum.com

create dialog box within macro and use value chosen
 

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