VBA Data Types

Visual Basic for Applications (VBA), like other programming languages, provides a set of data types that determine the kind of data you can store in a variable. Here’s a brief overview of the most commonly used data types in VBA:

Effectively Manage Your
Projects and Resources

With Our Professional and Premium Project Management Templates!

View Details

Built by PNRao — Trusted Since 2012

Analysistabs was created by PNRao, a project management professional with over 15 years of experience across finance, telecom, healthcare, and retail. What started as a personal Excel blog in 2012 has grown into a resource used by 50,000+ professionals worldwide. Every template is built from real-world project experience — not generic AI-generated content.

Free Templates

Premium Templates

Free project management templates and Excel automation guides by PNRao. Download professional templates for project planning, budgets, dashboards, timelines, and more. Compatible with Excel 365, 2024, and 2021. Trusted by 50,000+ professionals since 2012.

VBA Data Types

VBA User-defined Data Type

VBA Variant Data Type

VBA String Data Type

VBA Boolean Data Type

VBA Byte Data Type

VBA Collection Data Type

VBA Currency Data Type

VBA Date Data Type

VBA Decimal Data Type

VBA Dictionary Data Type

VBA Double Data Type

VBA Integer Data Type

VBA Long Data Type

VBA LongLong Data Type

VBA LongPtr Data Type

VBA Object Data Type

VBA Single Data Type

Built by PNRao — Trusted Since 2012