Prepared to ask questions about VB?
Users questions: Prepared to ask some of your VB, VB has a structure of IF .... Then my programming along the following lines: IfSheets ("Shipping Details"). Cells (I, 12) = "AOC" ThenSheets ("Shipping Details") . Cells (I, 1) = "Beijing Xing strap "******************************************* *********- Now, I want to as long as the language contained in the AOC of the strap can be equal to Beijing Xing. that the equal sign, the sign change include This should be how to change it know? Because: in the writing process may be aoc
Experts answer: with like operator: IfSheets ("Shipping Details"). Cells (12,9) Like "* AOC *" OrSheets ("Shipping Details "). Ce lls (12,9) Like "* aoc *" ThenSheets ("Shipping Details"). Cells (1,9) = "Beijing Xing strap" EndIf see Annex: Annex: shipping details. xls