Thread: How to make drop-down lists show more rows
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike Tomasura Mike Tomasura is offline
external usenet poster
  
Posts: 32
Default How to make drop-down lists show more rows
use additem


For x = 1 To 200
ComboBox1.AddItem x
Next x




"paul" wrote in message
...
I'd need to make the drop-down list displayed show more
rows than the default. Any ideas?

TIA
Paul



Reply With QuoteReply With Quote