leopardhawk
Well-known Member
- Joined
- May 31, 2007
- Messages
- 611
- Office Version
- 2016
- Platform
- Windows
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!
VBA Code:
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