drop down list
 

I need to create a sheet that has drop down menus on it. I was wondering if
there was a way to link the drop down list to another workbook, because there
are going to be several different workbooks that use the same menus. I would
like to have it so that i need to only change one instance of the list rather
than going into each file and changing the list in there.

drop down list
 

This link should help


http://www.contextures.com/xlDataVal05.html

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=563673