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, ….



  • 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.

Leave a Reply

Your email address will not be published. Required fields are marked *