Thread: .additem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ernie Ernie is offline
external usenet poster
 
Posts: 65
Default .additem

i have two combo boxes: cboCount1 and cboCount2.
i have a long list of same items added to the drop down list of both combo
boxes.

With cboCount1
.additem = "1"
.additem = "2"
.additem = "3"
End With

With cboCount2
.additem = "1"
.additem = "2"
.additem = "3"
End With

I need to make my codes as short and compressed as possible. I want to use
the same list for both combo boxes but use a shortcut. How can i achieve this.

thanks in advance