Combo Box not showing Data and need to search sheets based on combo box

[Hutch1603]

Hello,

I have created a user form that lets me enter data onto different worksheets within the workbook depending on a combobox selection. My problem arises when I click the command button to open the 2nd user form. It opens, but the combobox does not display the entries I want to Show.

Sub UserForm1_Initialize()
With ComboBox1
.AddItem "Tuesday"
.AddItem "Wednesday"
.AddItem "Friday"
.Additem "Saturday"
End With
End Sub

The code above is what I am using and is the same to the code in UserForm, used for the data entry. I have tried to rename the combobox to ComboBox11 and still it wont Work. Also, I have two DTPicker boxes below my combobox. I would like these to be blank until the user selects a date, but I cannot get them to clear. I have tried lots of different code suggestions from multiple web sites, yet nothing works.

Does anyone have an inclining to why my combobox wont display the items and I cant blank the datepicker fields?

 

[Fluff]

It should be

Sub UserForm_Initialize()

regardless of the name of the userform.

 

[Hutch1603]

Hi Fluff,

Thank you for that. I din't realise you didn't need to put the user form number in. On another note, do you no how to clear DTPicker Fields so that when the userform opens they are blank. Can't get any of the variations I have googled to work.

 

[Fluff]

I don't think that a date picker can be blank.