VBA_Basics - 9/13/07 Copyright 2007 1 VBA Principles...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

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

Unformatted text preview: 9/13/07 Copyright 2007 1 VBA Principles CEE3804: Computer Applications for Civil and Environmental Engineers 9/13/07 Copyright 2007 2 Objectives Develop a simple set of programs in VBA Learn to execute a macro from within a worksheet Introduction to loop structures 9/13/07 Copyright 2007 3 Before You Program Develop a strategy to solve the problem Develop pseudo-code Develop a flowchart (helps guide your thought process) NOTE: most engineers do not to like to develop flowcharts This creates problems when someone else looks at your program Most programs do not work the first time, so a flowchart of pseudo- code can help you understand bad logic Start Output c Input b c = a + b Input a End Start here: Flowchart Then code 9/13/07 Copyright 2007 4 Flowchart Symbols Review them in Chapra’s book (page 115) Represents a comparison or a condition with more than one path Decision Represents input and output of data and information Input/Output Calculation of data manipulation Process Represent the flow of logic Flow lines Represents the beginning of end of a program Terminal Function Name Symbol Start c = a + b Input b If (a>b) True False 9/13/07...
View Full Document

This note was uploaded on 01/01/2012 for the course CEE 3804 taught by Professor Aatrani during the Spring '07 term at Virginia Tech.

Page1 / 24

VBA_Basics - 9/13/07 Copyright 2007 1 VBA Principles...

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

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