ComboBox Drop Down List
If your comboboxes are named nicely:
Dim iCtr As Long
For iCtr = 1 To 14
With Me.Controls("Combobox" & iCtr)
.AddItem "Yes"
.AddItem "No"
End With
Next iCtr
Johnny wrote:
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
--
Dave Peterson
|