add data to combo box in excel then invoke macro
 

I want to either add a combo box or using data validation creat a list of
peolpes names. I will create a worksheet with each persons name and use the
result of the combo box or drop down list t navigate to the corresponding
worksheet.

How can I set this up?

add data to combo box in excel then invoke macro
 

Hi Richard,

see David McRitcghie's Build Table of Contents page at:

http://www.mvps.org/dmcritchie/excel/buildtoc.htm


---
Regards,
Norman



"Richard" wrote in message
...
I want to either add a combo box or using data validation creat a list of
peolpes names. I will create a worksheet with each persons name and use
the
result of the combo box or drop down list t navigate to the corresponding
worksheet.

How can I set this up?