Count if part from combobox value

[Wijnand1]

Hi All,

I have the following code to count If the criteria are met. Is it possible to make to code so that it will count if the value in Range("O:O") is a part of combobox1? I have tried Range("O:O"), (*ComboBox1*.Value)), but this doesn't do the job.

TextBox6.Value = Application.CountIfs(Range("A:A"), ">=" & CLng(CDate(TextBox1.Value)), Range("A:A"), "<=" & CLng(CDate(TextBox2.Value)), Range("J:J"), "Wrong", Range("O:O"), (ComboBox1.Value))

Kind regards,

Wijnand.

[LeoTaxi]

last part change to

"*" & ComboBox1 & "*"

kind regards
Leo