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.

RelaxTools Addin for Microsoft Excel 2010/2013/2016

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.

Personal collection of vb.net, .net, vba and other books regarding vb programming

QR Code generator library in VBA

Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination.

A free VBA library to make structural analysis easy in Microsoft Excel

A tiny Selenium wrapper written in pure VBA

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).

Using Serial COM Ports in Visual Basic for Applications (VBA7)

Convert DBC to Excel by VBA

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.

SQL Server to Microsoft Excel. VBA class for Excel to make easy to access records stored in SQL Server and output these data in an Excel sheet; keeping or not the link

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.