VBA Class 1 (VBA for Financial Engineering)

Add to Favourites
Post to:

Description
VBA Class 1 (VBA for Financial Engineering)


Type: ppt

Discussion
Presentation Transcript Presentation Transcript

VBA Class 1 : VBA Class 1

Agenda : Agenda VBA Data Types Logic Structures :IF – ELSEIF – ELSE – END IF IIF SELECT CASE Control Structures :FOR - NEXT loop FOR - EACH loop DO WHILE loop DO UNTILL loop Arrays in VBA : Array data types Single dimensional Arrays Multi dimensional Arrays Dynamic Arrays How we can access arrays’ elements with control structures , Fast Sorting of Data using Arrays Program structures and Sub-routines Functions Logical organization of Functions and Sub-routines

Area of focus today : Area of focus today Referring to ranges, creating ranges equating values Range seems to be most imp  concept of all

Playing with Ranges & Data validation : Playing with Ranges & Data validation Data Validation data type Playing with data validation using VBA

Range in VBA : Range in VBA Sample Program Clearing a range with other range Extracting value from ranges

Ranges References : Ranges References Refer MSDN http://msdn.microsoft.com/en-us/library/office/aa139976(v=office.10).aspx http://www.excel-vba-easy.com/vba-programming-range-excel-vba.html Pearson http://www.cpearson.com/excel/vbe.aspx

VBA Data Types : VBA Data Types Variant Param Array Range Array of range

Programs on Range : Programs on Range Select a range and clear contents Copy a range Get values of a range

PowerPoint Presentation : Sub range2() Dim r_range1, r_range2 As Variant Dim range1, range2 As range Set r_range1 = range("range1") Set r_range2 = range("range2") r_range2.Value = r_range1.Value End Sub Sub range3() Dim range1, range2 As range range("range2").Value = range("range1").Value End Sub

Display Contents : Display Contents Sub range4() Dim range1, range2 As range MsgBox range("range1")(1).Value End Sub

Logical Operations : Logical Operations Logical operators, control flow, data tables, functions, dependencies, joining strings, delimiter and data validation Functions Dynamic Inputs

Logic Structures : Logic Structures IF – ELSEIF – ELSE – END IF IIF SELECT CASE If End if Else if Indentation

Control Structures :FOR - NEXT loop : Control Structures :FOR - NEXT loop FOR - EACH loop DO WHILE loop DO UNTILL loop

Arrays in VBA : : Arrays in VBA : Array data types Single dimensional Arrays Multi dimensional Arrays Dynamic Arrays

Indexing in VBA : Indexing in VBA How we can access arrays’ elements with control structures , Fast Sorting of Data using Arrays

Program structures and Sub-routines : Program structures and Sub-routines Function vs Sub

Functions Logical organization of Functions and Sub-routines : Functions Logical organization of Functions and Sub-routines

Data Handling : Data Handling Data types, ranges and cell arrays, opening file, Data Handling & Visualization

Handling data : Handling data Missing Data Data Pulling into Excel

Shivgan Joshi
Free Class on: CFA,BAT,FRM, GMAT, Quant FinanFollow me to get updates.
User
1805 Members Recommend
2406 Followers

Your Facebook Friends on WizIQ