Lecture 9 - VBA Review (And Or)

Lecture 9 - VBA Review (And Or) - 2/8/2010 VBA Skills...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
2/8/2010 1 VBA Skills Inventory Skills Inventory How this material will help you: You will be able to see everything that we have learned so far about VBA You will be able to assess your own skill You will learn to make your decision branches more powerful Connecting to your Background Building skills Presentation skills Problem solving skills Programming skills Preparing For exams Future courses Practice
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2/8/2010 2 VBA Commands h Option Explicit h Dim Single, Integer, String h h Variable = InputBox(“enter something here”) If (this is true) then This will happen EndIf If-then-Else If (this is true) then This will happen Else This will happen instead EndIf Don’t forget: If-then EndIF
Background image of page 2
2/8/2010 3 If-then-ElseIf-then If (this is true) then This will happen ElseIf (this is true) then This will happen instead EndIf Don’t forget: If-then EndIF Go To If (this is true) then Go To 10 ElseIf (this is true) then This will happen instead EndIf 10
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/09/2012 for the course ENGR 160 taught by Professor Sengupta during the Spring '07 term at Iowa State.

Page1 / 6

Lecture 9 - VBA Review (And Or) - 2/8/2010 VBA Skills...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online