#DATA ANALYSIS WITH EXCEL AND VBA CODE#

Spreadsheets and risk - spreadsheet risk organizations, interest groups, and articles.Advanced filter to Filter function -video version.Break out of a MsgBox Loop - Ctrl + Break, OSK, Cancel button.Format the return value of a UDF - example :: FV of an annuity.Prevent data entry in WS TextBox - operation of the WS TextBox.Locked property.WS controls and colors - quick guide to Shapes and ActiveX.VBA built-in constants - view ASCII values.Emulate DAYS360 function - custom WS function to emulate DAYS360 (US method - NASD).Programming VBA references - add a reference library programmatically.

#DATA ANALYSIS WITH EXCEL AND VBA CODE#

Change function argument value - edit function arguments using VBA code.Enterprise Risk Management - a list of ERM resources.xlfGumbel function - VBA version of Gumbel distribution.GetStrType function - evaluate the data type (limited) of element in a delimited string.Road map to the xlf-ymd-selector file - contains both Data Validation and Form Control versions of the Year-Month-Day worksheet selector interface WIP.WS date - UNIX timestamp - added From Web URL string for /v7/finance/download.YMD WS date picker - Data Validation and Form Control versions of the Year-Month-Day worksheet selector interface - published version.xlf :: VBA add a thermometer chart to the WS - a Quick Guide to the VBA needed to add a 'thermometer chart' to a WS.VBA sample question - ATO CorpTax - ATO company tax rates → User Defined function (UDF).

Data analysis with excel and vba