Dear Natefarm,

Many thanks for your reply.

Sorry, I can't have hidden column. But I changed the code from 

If Not (WorksheetFunction.CountIf(ws.Range("D:D"), ComboBox6.Value) > 0 And WorksheetFunction.CountIf(ws.Range("E:E"), ComboBox3.Value) > 0)
to 
If WorksheetFunction.CountIfs(ws.Range("D:D"), ComboBox6.Value, ws.Range("E:E"), ComboBox3.Value) = 0 Then
And It solved the problem.

Many Thanks & Kind Regards