- May 31, 2007
- Office Version
Hello forum friends, I have a UserForm with eight separate comboboxes that I want to have the months of the year in. Currently, I am using the code below to accomplish this. I think there must be a way to extend this to the other seven comboboxes without having to copy and paste this code seven more times. I'm hoping someone knows how I can do this. The other comboboxes in question are all named slightly different in that they start with a different character than 'B'... Thanks!
Private Sub UserForm_Initialize() With BMonthComboBox .AddItem "January" .AddItem "February" .AddItem "March" .AddItem "April" .AddItem "May" .AddItem "June" .AddItem "July" .AddItem "August" .AddItem "September" .AddItem "October" .AddItem "November" .AddItem "December" End With