Thread: How do I create a list when it is not in the Data tool bar?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
protonLeah
 
Posts: n/a
Default How do I create a list when it is not in the Data tool bar?

I'm using XL-2000-, and 'LIST' is found at DATA|VALIDATION|ALLOW:LIST.
However, you can always put your list on a scratch sheet and link a
dropdown combo box to it, though you'll probably need an INSERT button
or some EVENT code along with it.

Ben


--
protonLeah
------------------------------------------------------------------------
protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097
View this thread: http://www.excelforum.com/showthread...hreadid=472471

Reply With QuoteReply With Quote