View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Johnny Johnny is offline
external usenet poster
 
Posts: 126
Default ComboBox Drop Down List

I have 14 Combo Boxes on my Excel form that I want to populate with "Yes" and
"No" with the initialize event. The only way I know how to do it is to use
the following code for each ComboBox.

With ComboBox#
.AddItem "Yes"
.AddItem "No"
End With

Is there simpler code to accomplish this?

Thank you