vba-excel

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

Call Julia from Microsoft Excel worksheets and from VBA

A tiny Selenium wrapper written in pure VBA

Excel VBA integration for VS Code - Tree View / Full Direct VBA Read+Write / LiveShare Compatible / Direct Agentic AI Integrations

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)

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.

Convert DBC to Excel by VBA

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

cTaskDialog (TaskDialogIndirect implementation) universally compatible with VB6/VBA7/twinBASIC x86/x64

VBA snippets and code library

Lightweight tool to export ranges within an Excel sheet to CSV