Dollar to euro - decimal point 1.23 to decimal comma 1,23Įxcel at Finance xlf Excel at.Add logo to banner - Shapes, AddPicture2, and ScaleWidth.WS add circle element - VBA code AddShape - as a dashboard building block.WS add line element - VBA code AddConnector - as a dashboard building block.Black-Scholes Python UDF - an Excel function coded with Python and available via xlWings.WS add a battery chart - VBA code to construct chart - as a dashboard building block.xldAddNameScope macro - VBA code using the Names.Add method - demonstrates Workbook scope and Worksheet scope.Defined named with Excel for Mac - how to edit the address of a defined name in Excel for Mac.Controlling code execution - examples of If.Then.Else, single-line, and multiline (block) versions.Yahoo DST date adjustment - a correction to the daylight saving time error for ASX data sourced from Yahoo finance.Normal distribution PDF :: VBA and GAS - code for Google GAS version of normal PDF with bonus VBA code.Is year a leap year - VBA custom function.VBA's Select Case statement - correction to code 1.Normal curve tail area - combo area with step comparison.
WS ActiveX TabOrder code - achieve TabOrder using KeyDown event.FSS Excel Windows or Mac - for 90045 participants - device discussion and recommendations.Rules of logarithms - an introductory level guide - rule of logs - with examples for the HP 12C.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.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).
0 kommentar(er)
