View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Simon Lloyd[_459_] Simon Lloyd[_459_] is offline
external usenet poster
 
Posts: 1
Default Insert cells in a ListBox

Why not create your list box using data validation?.....select you
range and give it a name...........then go to the range that you wan
the list box to be available on, highlight the whole range then clic
on data, validation....then choose allow list and type in the list nam
you should now find that all the data in the range on previous pag
will be in listbox form.

Simo

--
Message posted from http://www.ExcelForum.com