VBA - Visual Basic for Applications

Sometimes it is necessary to get a folder path from the user instead of receiving a file path.

The Excel Application class is providing a corresponding function, which is used in below method.

Source Code

Hits: 4271

If you search a value in a column in Excel the following method will be of use.

Source Code

Hits: 4145

If you have to delete all records from a table using Access VBA DAO, the following method might be helpful.

Hits: 4201
  1. Deleting a worksheet
  2. Get Range object of NamedRange
  3. Get selected list item using VBA
  4. Find / Search value in Excel row

Subcategories

Excel VBA Article Count:  30

This category will hold articles regarding developement in Excel VBA. It will serve as a wiki and an Excel VBA Framework for myself.

Some development tasks reoccur for every customer. Since I am a lazy bum it will be nice to have a central source where I can reuse source code from.

MS Office and VBA Article Count:  11

This category holds articles regarding general things in MS Office VBA independent from the MS Office application.  

Power Point VBA Article Count:  1

Access VBA Article Count:  7

This category holds articles regarding Access VBA, but also general things I come accross Access and its usage in companies.

Access VBA DAO Article Count:  2