Excel VBA基础控制结构与应用示例.pdfVIP

VBAhasmanycontrolstructurestouse.ThemostusedonesaretheIf…EndIfandtheFor…Next.

Withthesetwoyoushouldbeabletobuildsubstantialcontrolintoyour‘programs’.

TheIf…EndifCONTROL:

Executesanactionifaconditionistrue.

IfAns1=1ThenTestcondition.

Score=Score+1IncrementvariableScoreifconditionistrue

EndIfEndafteraction

AcommonformofthiscontrolistheIf..Else..EndIf

IfAns1=1ThenTestcondition.

Score=Score+1IncrementvariableScoreifconditionistrue

Else

Score=Score–1DecrementvariableScoreifconditionisnottrue

EndIf

LOOKatExerciseOneasanexampleofthiscontrolinaction.

TheFor….NextCONTROL:

RepeatsastatementORagroupofstatementsaspecifiednumberoftimes.

Score=0Initializevariable.

ForCount=1to10Doit10times

Score=Score+1IncrementvariableScore

NextCount

LOOKatExerciseThreeasanexampleofthiscontrolinaction.

TheWhile…WendCONTROL:

ExecutesaseriesofstatementsaslongasagivenconditionisTrue.

Score=0Initializevariable.

WhileScore10TestvalueofvariableScore

Score=Score+1IncrementvariableScore

WendEndWhileloopwhenCounter10

TheDo…LoopCONTROL:

RepeatsablockofstatementswhileaconditionisTrueoruntilaconditionbecomesTrue.

Score=0Initializevariable

Do

Score=Score+1