Dates in excel sheet not matching dates in comobox1

[ColemanJames]

I hope this is an easy question as I can't post and data due to the fact that it is classified.
I have a combo box (on a user form) with dates in it and on sheet2 in cell J is same dates. I want to do and if statement.
If the user picks a date in the combo box it goes through range("J" & i).
If combobox1.value = sheets(2).range("J" & i) then
Sheets(2).Range("B" & i).EntireRow.Copy
Sheets.Add After:=Sheets(Sheets.Count)
Sheets(3).Paste
End If
Next i

The dates look the same visually but it never gets past the if statement.
So for whatever reason...it is not recognizing the two dates as the same.
Thanks for any help.

[mjr veverka]

Some dates are in "text" format (combobox) and some in "date" format (sheet) or both date groups have different formatting, e.g.: mm/dd/yyyy vs. m/d/yy or others.

[ColemanJames]

porucha vevrku ,
Thanks for the reply.
I failed to mention that I have both the sheet dates and the combobox1 dates formatted with ("m/d/yyyy")

[mjr veverka]

What is the dates source for combobox ? This Sheet2 with cells in column 'J' ? Maybe an attachment and all vba code for that For...Next loop ?

[ColemanJames]

'''''''Populate combo box
For i = 2 To 200
If Sheets(2).Range("B" & i) = Customer Then

combobox1.AddItem Sheets(2).Range("J" & i).Value
combobox1.Value = Format(combobox1.Value, "m/d/yyyy")

End If
Next i

[mjr veverka]

Your first vba code ... is as below - this is not the whole code, missing the first lines.
What is there ... "cia top secret" ?

Please Login or Register  to view this content.

[ColemanJames]

porucha vevrku ,
That code Populates the combobox1. the code below is what im trying to do.

Private Sub cbSearch_Click()
Sheets(2).Activate

ActiveCell.Offset(0, 8).Select

For i = 2 To 10

If ActiveCell = combobox1.Value Then

Sheets(2).Range("B" & i).EntireRow.Copy
Sheets.Add After:=Sheets(Sheets.Count)
Sheets(3).Paste
End If
Next i
End of Sub

[mjr veverka]

1. The values in the ComboBox list are of type "String", so if you are searching some dates, use:

Please Login or Register  to view this content.

2. Shorter code to fill the list of 'ComboBox', e.g:

Please Login or Register  to view this content.

then in UserForm module:

Please Login or Register  to view this content.

3. 'ComboBox1.AddItem' is starting from index = 0.
So if 'i = 2' then this means that you start calculating from the value of index/list entry = 3