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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s