VBA - Visual Basic for Applications
If you have to delete all records from a table using Access VBA DAO, the following method might be helpful.
- Hits: 4861
In case you need the selected list item from a listbox, which only allows single selection the selected list item can be returned using the below source code.
Source Code
Where listBox is the name of the control element / the listbox as you defined it.
Me refers to a form a listbox is placed in.
The column index within a listbox is zero based.
- Hits: 4677
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: 4828
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
Page 15 of 17
