View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default How can I copy a Combobox with all items ?

Hi Hans

Those combos aren't really in the cells, they are floating above them. Try
to use data validation instead:
http://www.contextures.com/xlDataVal01.html

HTH. best wishes Harald

skrev i melding
...

My combobox in cell "A1" contains many names, e.g. "Harald", "Hans",
"Susi", "Eva", ...
I have created this combobox manually with the mouse from a toolbar
without VBA
and have filled it with VBA (.addItem("Harald")).