run a macro from a form

K

kevin carter

hi
we have a workbook containing serveral worksheets
each worksheet contains a lot of data
we have split each worksheet into three pages for print purposes

what we want to do is have a form containing drop down list of names
we need each name to select and run a macro
can this be done?


thanks in advance
kevin
 
D

Dave Peterson

You may be able to get by using data|validation and a worksheet_change event.

(if you're using xl97, this may not work.)

Debra Dalgleish has very nice instructions on how to use Data|Validation at:
http://www.contextures.com/xlDataVal01.html

And she has a couple of sample workbooks that kind of do what you want:
http://www.contextures.com/excelfiles.html

Look for:
Product List by Category -- uses Data Validation and an Advanced Filter to
extract a list of products for the selected category; file contains a macro
which
automates the filter (XL2000 and XL2002 only) ProductsList.xls 35 kb;
(XL97) ProductsList97.xls 38 kb; ProductsList97Calc.xls 39 kb
 
Top