Variant/Decimal - VBA Data Types

Có thể bạn quan tâm

BetterSolutions.comBetterSolutions.com

Resources
Microsoft Office Excel
Microsoft Office Word
C# Programming
JavaScript Programming
Add-ins
Office Add-ins for Excel
Office Add-ins for Word
Consultancy
Macros, Templates and EUDAs
TypeScript and JavaScript
Development
Office JS Add-ins and Scripts
End User Programming
Support
VSTO and .NET Migration
Troubleshooting
Training
Microsoft 365 Integration
Please Contact Us Today for a FREE Consultation
Excel
- - Add-ins
  - Best Practices
  - Cells Ranges
  - Charts
  - Conditional Format
  - Data Analysis
  - Data Validation
  - Dates Times
  - Search Excel ...
- - Functions
  - User Defined
  - Formulas
  - Formatting
  - Finance
  - Illustrations
  - Importing
  - Layout
  - Our Services ...
- - Macros
  - Named Ranges
  - Options
  - Pivot Tables
  - Power Query
  - Protection
  - Reviewing
  - Ribbon
  - Find Add-ins ...
- - Rows Columns
  - Shortcut Keys
  - Tables
  - Templates
  - Track Changes
  - Workbooks
  - Worksheets
  - XML
  - Contact Us ...
Word
- - Add-ins
  - Bookmarks
  - Building Blocks
  - Bullets
  - Characters
  - Charts
  - Content Controls
  - Design
  - Search Word ...
- - Documents
  - Fields
  - Illustrations
  - Importing
  - Layout
  - Macros
  - Mailings
  - Numbering
  - Our Services ...
- - Options
  - Outlines
  - Pages
  - Paragraphs
  - Protection
  - References
  - Reviewing
  - Ribbon
  - Find Add-ins ...
- - Sections
  - Shortcut Keys
  - Styles
  - Tables
  - Templates
  - Text Boxes
  - Track Changes
  - XML
  - Contact Us ...
PowerPoint
- - Add-ins
  - Animation
  - Bullets
  - Characters
  - Charts
  - Design
  - Handouts
  - Illustrations
  - Search PowerPoint ...
- - Importing
  - Layout
  - Macros
  - Notes
  - Numbering
  - Options
  - Outlines
  - Paragraphs
  - Our Services ...
- - Presentations
  - Protection
  - References
  - Reviewing
  - Ribbon
  - Sections
  - Shortcut Keys
  - Slide Show
  - Find Add-ins ...
- - Slides
  - Tables
  - Templates
  - Text Boxes
  - Track Changes
  - Transitions
  - Video
  - XML
  - Contact Us ...
Outlook
- - Add-ins
  - Address Book
  - Alerts
  - Appointments
  - Calendar
  - Contacts
  - Events
  - Exchange
  - Search Outlook ...
- - Folders
  - Forms
  - Groups
  - HTML
  - Illustrations
  - Importing
  - Journal
  - Macros
  - Our Services ...
- - Mail
  - Meetings
  - Notes
  - OneDrive
  - OneNote
  - Options
  - People
  - Proofing
  - Find Add-ins ...
- - Ribbon
  - Rules
  - Search
  - SharePoint
  - Shortcut Keys
  - Tasks
  - Web Client
  - XML
  - Contact Us ...
VBA
- - Add-ins
  - Arrays
  - Best Practices
  - Class Modules
  - Code Snippets
  - Collections
  - Controls
  - Databases
  - Search VBA ...
- - Data Types
  - Dates Times
  - Debugging
  - Enumerations
  - Error Handling
  - Events
  - Files Directories
  - Functions
  - Our Services ...
- - Macros
  - MsgBox
  - Numbers
  - Options
  - References
  - Ribbon
  - Shortcut Keys
  - SQL
  - Find Add-ins ...
- - Strings
  - Subroutines
  - Syntax
  - Userforms
  - Variables
  - Visual Basic Editor
  - Web Interaction
  - XML
  - Contact Us ...
C#
- - .NET Library
  - Arrays
  - Best Practices
  - Classes
  - Collections
  - Databases
  - Data Types
  - Dates Times
  - Search C# ...
- - Debugging
  - Excel Interop
  - Error Handling
  - Files Directories
  - Generics
  - Interfaces
  - MessageBox
  - Numbers
  - Our Services ...
- - Projects
  - Serialization
  - Strings
  - Structures
  - Syntax
  - Threading
  - Variables
  - VBA Migration
  - Find Add-ins ...
- - Visual Studio
  - VSTO Add-ins
  - Web Add-ins
  - Web Development
  - Web Services
  - Windows Forms
  - WPF Forms
  - XML
  - Contact Us ...
JS
- - Arrays
  - Custom Functions
  - Data Types
  - Dates Times
  - Debugging
  - Dialog Boxes
  - Error Handling
  - Excel API
  - Search JavaScript ...
- - Express Backend
  - Fluent UI
  - Functions
  - HTML Pages
  - Microsoft Graph
  - Node JS Runtime
  - Numbers
  - Objects
  - Our Services ...
- - Office Add-ins
  - Office Events
  - Office Manifest
  - Office Scripts
  - Outlook API
  - PowerPoint API
  - React Library
  - Ribbon Commands
  - Find Add-ins ...
- - Strings
  - Syntax
  - Task Panes
  - TypeScript
  - Variables
  - Visual Studio Code
  - Word API
  - Yeoman Generator
  - Contact Us ...
Software Development Services
- High Value Consultancy
- VBA Templates and Macros
- Office Scripts and EUDAs
- VSTO and .NET Migration
- Bespoke Office Add-ins
- Long-Term Technical Support
- Contact Us

PreviousNextVBA > Data Types

VBA Programming
Data Types
User FAQs
Value Types ...
Reference Types
Type - Object ...
Type - Variant ...
Sub Types
Variant/Decimal
Empty
Null
Error
VarType Function
TypeName Function
Type Checking ...
Converting - Implicit
Converting - Explicit ...
Arrays*
Collections ...
Scripting Dictionary ...
User Defined Types ...
Code Snippets ...
Updated: 01 January 2025
01 January 2025

Variant/Decimal

The variant has a special sub type called Variant/Decimal that can be used to hold very large numbers.This can support 29 significant figures with 28 decimal places.This data type uses 14 bytes.The default value is Empty because it must be declared as Variant.

Possible Values

The smallest non zero value with 28 decimal places is:+/- 0.0000000000 0000000000 000000001The largest value with 28 decimal places is+/- 7.9228162514 2643375935 43950335

Dim vValue1 As Variant Dim vValue2 As Variant vValue1 = CDec(10 / 5) vValue2 = CDec(-7000000000.55556) Debug.Print VBA.TypeName(vValue1) '= Decimal Debug.Print VBA.TypeName(vValue2) '= Decimal

This data type must be declared as a Variant and can only be created using the CDEC conversion function.Use this data type when you do not want rounding errors.If you do not need this kind of precision you should always use the Double data type instead.

Dim decMyDecimal As Variant decMyDecimal = CDec(3000000000000) Call MsgBox(TypeName(decMyDecimal)

These are stored as 96 bit (12 byte) signed integers scaled by a variable power of 10.The power of 10 scaling factor specifies the number of digits to the right of the decimal point and ranges from 0 to 28.This data type provides the greatest number of significant digits for a number.This data type is the slowest of all the numeric data types.This data type widens to Single or DoubleYou can convert Decimal to Single or Double without an Overflow error.More info Numbers > Fixed Point

Conversion Function

The CDEC function returns the expression converted to a decimal variant-subtype (Variant).

Từ khóa » Visual Basic Double Vs Decimal

Variant/Decimal - VBA Data Types

Possible Values

Conversion Function

Numeric Data Types - Visual Basic - Microsoft Docs

VS 2019 Do You Use Decimal, Single, Or Double? - VBForums

The Difference Between Decimal, Float And Double

Difference Between Decimal, Float And Double In .NET?

The Decimal Data Type - VB.NET

Comparing Double Vs. Single Data Types In VB6 - TechRepublic

Some More Variable Types - Excel VBA Programming

C# Decimal Vs Double And Other Tips About Number Types

Solved In Visual Basic, What Is The Main Difference Between - Chegg

Visual Basic Data Types - ZetCode

Adding A Decimal In Visual Basic - Small Business

– Decimals, Integers, And Doubles In Visual Basic - ITecNote

VBA Double Data Type (Dim Variable) - Automate Excel

Liên Hệ