Hello,

its possbile make combination of data types? my solution doesnt work and i ddnt find on internet how to do..


'data type product 1-3
Dim DOC As String: DOC = "Product 1"
Dim DOK As String: DOK = "Product 2"
Dim DOB As String: DOB = "Product 3"
'data type product 4-6
Dim KC As String: KC = "Product 4"
Dim KK As String: KK = "Product 5"
Dim KB As String: KB = "Product 6"
'data type product 7-9
Dim SCo As String: SCo = "Product 7"
Dim SKl As String: SKl = "Product 8"
Dim SCi As String: SCi = "Product 9"
'data type combination
Dim Sna As String: Snack = SCo Or SKl Or SCi
Dim Dor As String: Dortik = DOC Or DOK
Dim Kor As String: Korpus = KK Or KB


'start
If (set1.Value = KC And (set1.Value = K1 Or set12.Value = K2) And set13.Value = T2) Then
MsgBox "X"


'next
ElseIf ((set1.Value = DC Or set1.Value = DK Or set1.Value = DCi Or set1.Value = DB Or set1.Value = DM) And set13.Value = Kor) Then
MsgBox "wrong"