Excel Macro Class

Learn the secrets of Excel VBA and enjoy numerous macro examples

Pages

Macros
Training
Objects
Functions
Enumerations
Books
Games
Sports
Business
About
Contact
Privacy

Enumerations

This page gathers predefined enumerations, constants, lists, sets, and other useful resources to help you find them easily and quickly while creating VBA macros in Microsoft Excel.

Excel Enumerations (xl)

Chart Type enumeration (xlChartType)

Paste Type enumeration (xlPasteType)

Cell Type enumeration (xlCellType)

Validation Type enumeration (xlDVType)

See full list of Excel enumerations

Office Enumerations (mso)

Shape Type enumeration (msoShapeType)

AutoShape Type enumeration (msoAutoShapeType)

File Dialog Type enumeration (msoFileDialogType)

See full list of Office enumerations

Visual Basic Constants/Enumerations (vb)

Miscellaneous VB constants

Color VB constants

Message Box Style enumeration

Message Box Result enumeration

Lists and Sets

ASCII character code set

Command Bar Button FaceId icons

Microsoft Office ImageMSO icons

Other

Email This BlogThis!Share to Twitter Share to Facebook Share to Pinterest

No comments:

Post a Comment

Popular Posts

Send Multiple Emails From Excel VBA Macro

In a previous post , we have seen how to send an email from Excel (via Outlook) using VBA macros. We can add as many recipients as needed se...
Send Email From Excel VBA Macro

We can integrate Excel with other Microsoft Office applications using VBA. In this post we are going to see how to send an email from Excel ...
Compare Two Worksheets Excel VBA Macro

In this macro example, we compare two worksheets with data from two different versions of the same data set. Thus, we can see if there are a...
Copy Filtered Data To New Sheets Excel VBA Macro

Excel offers filter options to easily narrow down the data. This macro example activates the filter option in VBA and copies the filtered da...
Compare Two Workbooks Excel VBA Macro

In this post we see how to compare two Excel workbooks with VBA macros. The macro checks if the number of worksheets matches, then compares ...
Compare Two Columns Excel VBA Macro

In a previous post we saw how to Compare Two Worksheets in Excel using VBA macros. In this post we see how to compare two columns with data...
Upload Data To Google Sheets Excel VBA Macro

In this post we learn how to upload or export data from Excel to Google Sheets using VBA macros. The macro sends a HTTP request to POST the ...
Simple Digital Clock Timer Excel VBA Macro

This macro runs a clock timer in Excel. The user can start/stop the time, and the clock shows minutes and seconds. It is a simple example ...
Scrape Web Data Excel VBA Macro (Part 1)

In this post we learn how to send a HTTP request to scrape and import web data into Excel using VBA macros. As an example, we are getting da...
Separate Sheets Into Workbooks Excel VBA Macro

This macro example separates sheets into new workbooks, keeping the original workbook. Each new workbook takes the name of the sheet and con...

My Blogs

Excel Macro Fun
Excel Macro Class
Excel Macro Business
Excel Macro Sports

My Books

Object Categories

Application (4)
Button (3)
Chart (3)
Google Sheets (3)
HTML (1)
HTTP (4)
Other (4)
Outlook (3)
Picture (5)
PowerPoint (1)
QueryTable (3)
Range (20)
Shape (4)
Table (1)
Word (1)
Workbook (8)
Worksheet (7)

Training for Beginners

Developer Tab and VBA Editor
Modules and Procedures
Excel Object Model
The Range Object
Variables
Conditions and Loops
Arrays
Message and Input Boxes
Userforms
Debugging and Error Handling

Excel VBA Objects

Application Object
Workbook Object
Worksheet Object
WorksheetFunction Object
Range Object
Shape Object
Chart Object

Popular Posts

Send Multiple Emails From Excel VBA Macro
Send Email From Excel VBA Macro
Separate Sheets Into Workbooks Excel VBA Macro
Upload Data To Google Sheets Excel VBA Macro
Copy Filtered Data To New Sheets Excel VBA Macro
Simple Digital Clock Timer Excel VBA Macro
Compare Two Columns Excel VBA Macro
Compare Two Worksheets Excel VBA Macro
Delete Rows Based On Criteria Excel VBA Macro
Send Google Mail From Excel VBA Macro

Search This Blog

Translate

Theme images by fpm. Powered by Blogger.