ComboBox Drop Down List
You can set up a pair of cells in a column in your workbook and give them a
name such as YNList and then your code can read:
Me.ComboBox#.RowSource="YNList"
(of course you can skip the Me. if you want).
The named list can be on any sheet in the workbook, even a hidden sheet.
"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
|