Hi. This is the first time i am making a user form in vba in excel 2007. The problem is I made a combo box for selecting the date. I then coded it as follows:
Private Sub UserForm_Initialize()
DateOfEntry.Value = ""
With DateOfEntry
.AddItem "1"
.AddItem "2"
.AddItem "3"
.AddItem "4"
.AddItem "5"
End With
There are other parts of the form also, and other combo boxes but i am posting this only. When i ran the form for the first time, everything worked fine. but then after making some changes i ran the form, all the drop down lists have stopped showing the lists. Can someone suggest what can be the probable issue? Thanks in advance.
Bookmarks