This is a collection of all the code that can be found on my YouTube channel Sigma Coding.
Code Blocks relating to everything VBA
🤔 A REST backend built with plain VBA Microsoft Excel macros. Yes. Macros.
A series of Visual Basic Applications (VBA) methods I wrote, mostly for Excel, to increase the speed and accuracy in working with data, charts and databases.
A free VBA library to make structural analysis easy in Microsoft Excel
Call Julia from Microsoft Excel worksheets and from VBA
Thaddeus Vincenty's Direct and Inverse formulae for geodesic calculations in Excel (distance, azimuth, latitude, longitude).
User Defined Functions for multi-component thermodynamic calculations of the Predictive Peng-Robinson 1978 Equation of State. Clean VBA functions - no UI changes and no pop up messages. Errors are reported in cell comments. Import Math.bas, ModArraySupport.bas and ChemE_Functions.bas into PData.xlsx and save as xlsm or simply download PData.xlsm.
VBA snippets and code library
Lightweight tool to export ranges within an Excel sheet to CSV
cTaskDialog (TaskDialogIndirect implementation) universally compatible with VB6/VBA7/twinBASIC x86/x64
A VBA macro that facilitates version control by automatically importing/exporting other VBA macros in Office documents.
Add a description, image, and links to the vba-excel topic page so that developers can more easily learn about it.
To associate your repository with the vba-excel topic, visit your repo's landing page and select "manage topics."