If-then statements allow you to perform different sets of actions if certain conditions are met or are not met.<\/p>\n
If<\/span> condition1 Then<\/span> For a single action you can put everything in a single line:<\/p>\n If<\/span> condition Then<\/span> action<\/p>\n The Select-Case statement is used to list possible situations in which certain actions should be performed. This is conceptually the same as an if\/else statement, but easier to read.<\/p>\n Select Case<\/span> UserValue You can also use the expresions To, Is =, <>, <, <=, > o >=<\/span><\/p>\n Case 1 To<\/span> 10 The structure of For, Next loops is as follows:<\/p>\n For<\/span> i\u00a0= 1 To<\/span> 10 For<\/span> i = 1 To<\/span> 10 Step<\/span> 2 For<\/span> i = 10 To<\/span> 1 Step -1<\/span> Do Loops perform a set of actions repeatedly while or until a condition is met.<\/p>\n Do While<\/span> count < 10 Do Until<\/span> count > 10 You can also check the condition after performing the actions<\/p>\n Do<\/span> Do<\/span> Exiting Loops<\/strong><\/p>\n To exit a loop we use Exit For<\/span> and Exit Do<\/span> depending on the loop. The command will stop executing the loop and move to the next line of code after the Next\/Loop statement.<\/p>\n The With construct is used to set several properties or use several methods of one object in an enclosed statement.<\/p>\n With<\/span> Range(\u201cA1:B5\u201d) For Each, Next loops use objects as the loop counter.<\/p>\n For Each<\/span> ws In<\/span> ActiveWorkbook.Worksheets<\/span> For Each<\/span> r in<\/span> Worksheets(“Sheet1”).Range(“A1:D10”).Cells<\/span> 1. If, Then Statements If-then statements allow you to perform different sets of actions if certain conditions are met or are not met. If condition1 Then Actions1 ElseIf condition2 Then Actions2 Else Actions3 End If For a single action you can put everything in a single line: If condition Then action 2. Select, Case The […]<\/p>\n","protected":false},"author":22982,"featured_media":0,"parent":2,"menu_order":3,"comment_status":"open","ping_status":"closed","template":"page-templates\/full-width.php","meta":{"footnotes":""},"class_list":["post-15","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blogs.ubc.ca\/coetoolbox\/wp-json\/wp\/v2\/pages\/15","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.ubc.ca\/coetoolbox\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.ubc.ca\/coetoolbox\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.ubc.ca\/coetoolbox\/wp-json\/wp\/v2\/users\/22982"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.ubc.ca\/coetoolbox\/wp-json\/wp\/v2\/comments?post=15"}],"version-history":[{"count":6,"href":"https:\/\/blogs.ubc.ca\/coetoolbox\/wp-json\/wp\/v2\/pages\/15\/revisions"}],"predecessor-version":[{"id":1457,"href":"https:\/\/blogs.ubc.ca\/coetoolbox\/wp-json\/wp\/v2\/pages\/15\/revisions\/1457"}],"up":[{"embeddable":true,"href":"https:\/\/blogs.ubc.ca\/coetoolbox\/wp-json\/wp\/v2\/pages\/2"}],"wp:attachment":[{"href":"https:\/\/blogs.ubc.ca\/coetoolbox\/wp-json\/wp\/v2\/media?parent=15"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nActions1
\nElseIf<\/span> condition2 Then<\/span>
\nActions2
\nElse<\/span>
\nActions3
\nEnd If<\/span><\/p>\n2. Select, Case<\/h2>\n
\nCase<\/span> 1
\nActions1
\nCase<\/span> 2
\nActions2
\nCase Else<\/span>
\nActionsElse
\nEnd Select<\/span><\/p>\n
\nCase Is <=<\/span>10<\/p>\n3. For, next<\/h2>\n
\nActions
\nNext<\/span> i<\/p>\n
\nActions
\nNext<\/span> i<\/p>\n
\nActions
\nNext<\/span> i<\/p>\n4. Do Loops<\/h2>\n
\nactions
\ncount = count + 1
\nLoop<\/span><\/p>\n
\nactions
\ncount = count + 1
\nLoop<\/span><\/p>\n
\nactions
\ncount = count + 1
\nLoop While<\/span> count < 10<\/p>\n
\nactions
\ncount = count + 1
\nLoop Until<\/span> count > 10<\/p>\n\u00a05. The With Construct<\/h2>\n
\n.Interior.Color = vbRed
\n.Font.Bold = True
\n.Font.Name = \u201cArial\u201d
\n.Borders(xlEdgeBottom).LineStyle = xlDash
\nEnd With<\/span><\/p>\n\u00a06. For, each, next<\/h2>\n
\nactions
\nNext ws<\/p>\n
\nFor Each<\/span> nm In<\/span> ActiveWorkbook.Names<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"