Lecture 20 - Using VBA with EXCEL

Lecture 20 - Using VBA with EXCEL - 11/30/2009 Excel + VBA...

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

View Full Document Right Arrow Icon
11/30/2009 1 Excel + VBA Excel + VBA How this information will help you: learn how to read from and write to Excel files using VBA skills learn how to calculate lots of information very quickly in a nice format Connecting to your background Car mortgage House mortgage Student loans Planning for the future Making Decisions VBA skills
Background image of page 1

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

View Full DocumentRight Arrow Icon
11/30/2009 2 Input/Output Reading and Writing I/O Cost = Range (“A5”).Value This will read what ever is in cell A5 and assign it to cost Cost = Cells (5,1).Value This will read whatever is in row 5, column 1 (A5) and assign it to cost Range(“A5”).Value = cost Whatever the value of cost is, it will be printed in cell A5. Cells(5,1).Value = cost Whatever the value of cost is, it will be printed in row 5, column 1 (A5) Things to Notice the quotation marks the .Value Cells(row, column).Value Input/Output Reading and Writing I/O Range(“A5:B12”)= cost The value of cost will be
Background image of page 2
Image of page 3
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 / 5

Lecture 20 - Using VBA with EXCEL - 11/30/2009 Excel + VBA...

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

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