New drop down menu

[pcor]

A long time ago I had some code to add a drop down menu to Excel. Can some
kind soul please direct me to a location where I can recapture that
code.\Thanks

 

[Bob Phillips]

See http://www.contextures.com/xlDataVal01.html

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[pcor]

Thanks Bob...but that is not the one.
The one I am looking for goes like this;
You take a worksheet and write some code so that EXCEL knows were to find
it and then you can add a number of antris that will activate macros.
Whne this is all in place the HEADING only shows up on the TOOL bar. A click
on the heqadinf will reveal all the other macro access points. You can then
clikc on any of these access points at activate the macro\.
I do appreciate your help
Thanks

 

[Debra Dalgleish]

John Walkenbach has a menu maker example:

http://www.j-walk.com/SS/excel/tips/tip53.htm