Hi fren i'm Shankey n i'm new for excel vba so plzz help me for this problem....
i hav 7 columns ( like a,b,c,d,e,f,g ) and textbox1 and combobox1.
select a data for textbox1 - "column a,b,c,d,e,f " and combobox1 - "column g".
when i fill value in textbox1 from column "a" or "b" or "c" or "d" or "e" or "f"
and combobox1 value from column "g", at that time ,match the both box value
that they comes in same row, if not, it should come error like "not matched"
example:--
I....A....I....B....I....C....I....D....I....E....I....F....I..........G........I
I....1....I....2.....I....3....I....4....I....5....I....6....I........TEA......I
I....7....I....8.....I....9....I...10....I...11...I...12...I......SHAKE.....I
I....1....I....2.....I....3....I....4....I....5....I....6....I...ICECREAM...I
textbox1 Value - 2
combobox1 Value - Tea - Should not comes error
or
textbox1 Value - 2
combobox1 Value - IceCream - Should not comes error but,
textbox1 Value - 2
combobox1 Value - shake - Should Comes Error like "not matched"
like when i type "2" in textbox1 and type "Tea" in combobox1, then click commandbutton Should not comes error
or
when i type "2" in textbox1 and type "IceCream" in combobox1, then click commandbutton Should not comes error
BUT
when i type "2" in textbox1 and type "Shake" in combobox1, then click commandbutton Should comes ERROR like "not matched".
plzplz plzzz Help me sombody...
i hav 7 columns ( like a,b,c,d,e,f,g ) and textbox1 and combobox1.
select a data for textbox1 - "column a,b,c,d,e,f " and combobox1 - "column g".
when i fill value in textbox1 from column "a" or "b" or "c" or "d" or "e" or "f"
and combobox1 value from column "g", at that time ,match the both box value
that they comes in same row, if not, it should come error like "not matched"
example:--
I....A....I....B....I....C....I....D....I....E....I....F....I..........G........I
I....1....I....2.....I....3....I....4....I....5....I....6....I........TEA......I
I....7....I....8.....I....9....I...10....I...11...I...12...I......SHAKE.....I
I....1....I....2.....I....3....I....4....I....5....I....6....I...ICECREAM...I
textbox1 Value - 2
combobox1 Value - Tea - Should not comes error
or
textbox1 Value - 2
combobox1 Value - IceCream - Should not comes error but,
textbox1 Value - 2
combobox1 Value - shake - Should Comes Error like "not matched"
like when i type "2" in textbox1 and type "Tea" in combobox1, then click commandbutton Should not comes error
or
when i type "2" in textbox1 and type "IceCream" in combobox1, then click commandbutton Should not comes error
BUT
when i type "2" in textbox1 and type "Shake" in combobox1, then click commandbutton Should comes ERROR like "not matched".
plzplz plzzz Help me sombody...