Excel VBA ColorIndex
PNRao2026-07-31T17:36:53+05:30The VBA ColorIndex property in Excel sets fill colors, border [...]
VBA MsgBox Examples with Code
PNRao2026-07-31T17:30:49+05:30The Message box(MsgBox) displays a message, optional icon, and selected set of command buttons in a dialog box.It waits for the user to click a button, and returns an Integer value.
ADO in Excel VBA – Connecting to database using SQL
PNRao2026-07-31T17:49:29+05:30ADO Stands for ActiveX Data Objects, is Microsoft’s Client-Server technology to access the data between Client and Server. ADO can’t access the data source directly, it will take help of OLE DB Provider to communicate with the data source. Most of the times OLE DB providers are specific to a particular Data Source Type. However, we have an OLE DB provider for ODBC, it is a general purpose provider with help of this ADO can access any Data source which can understand ODBC.
In this topic:
- What is ADO?
- What is Database?
- What is SQL?
- Practical Learning: Using ADO and SQL with VBA
- Example File
100+ Excel VBA Macro Examples with Code
PNRao2026-07-31T17:17:45+05:30100+ USEFUL VBA CODES & MACROS
The Most Useful VBA Codes & Macros! Do Almost Everything! We have explained verity of examples to cover most frequently used codes.
- Basics & Excel Objects
- Application.Object
- Dealing with Other Applications
- Hyperlinks
- File Handling
- Charting
- Pivot Tables
- Miscellaneous