VBA For Excel
- Dates: Articles related to dates, date objects, getting dates, …
- Cells and Ranges: Articles related to working with cells and ranges. Formatting cell and range properties, …
- Workbooks: Articles related to working with multiple workbooks.
- Worksheets: Articles related to working with multiple worksheets.
- Web: Articles related to working and connecting to the web using VBA. For example data scraping, …
- GUI: Gui related articles. Userforms, ActiveX controls, Dialogs, ….
- Sample Codes and Downloads: VBA articles with samples and downloads.
- User Defined Functions and Subs: Articles related to working with user defined functions and sub.
- Data Types: Articles related to working with data types in VBA.
- System: Articles related to system function in VBA. Getting the list of file and folder in a directory …
- Text Files: Articles related to working with text files. Creating, modifying, reading, …
- Formatting: Articles related to formatting cells and range.
- Speed and Efficiency: Articles related to comparing the speed and efficiency of the different functions in VBA for Excel.
- Automation: Articles related to automating application from excel, or automating excel from other applications.