Thread: How can I copy a Combobox with all items ?
View Single Post
  #2   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

A2 and downwards:

Sheets(1).Range("A2").Resize(Me.ComboBox1.ListCoun t, 1).Value = _
Me.ComboBox1.List

HTH. Best wishes Harald

skrev i melding ...

How can I copy a Combobox with all items, which is placed in cell "A1", to another cell, maybe "A2" ?

Thanks in advance for any help !

Hans


Reply With QuoteReply With Quote