Debra Dalgleish has a downloadable sample file with the code and examples of
what you want.
http://www.contextures.on.ca/excelfiles.html#DataVal
Scroll down about one third of a page to find the workbook.
Gord Dibben MS Excel MVP
On 6 Jul 2006 12:33:19 -0700, "DukeDevil" wrote:
I know how to create a drop down list where i can choose one of the
options in the list. i need to be able to choose multiple options. Help
Please