VBA is known as Visual Basic for Application; it is an experience-driven programming language urbanized by Microsoft. It is largely used with Microsoft office application like MS Access, MS Word and ...

There are essentially two methods for adding records to a table. The first is to add one record at a time; the second is to add many records at a time. In both cases, you use the SQL statement INSERT ...

You can use the **SelLeft** property to specify or determine which column (field) is leftmost in the current selection rectangle. Read/write **Long**. _expression_ A variable that represents a **Form* ...

Susan Harkins shows you two easy ways to populate an Excel UserForm, and neither requires a single bit of VBA code. Last month’s article, “Pro tip: Add a UserForm to aid data entry in Excel,” shares ...

While many small business owners choose to use commercial applications to manage day-to-day operations, many tech-savvy entrepreneurs choose to create their own applications in Microsoft Access. With ...

One of the more common tasks on a computer is to undo something you just did by mistake. At least, it’s one of my more common tasks. CTRL+Z is my friend. But not everyone uses keyboard shortcuts – ...

Excel offers myriad options for referring to workbooks and sheets in your VBA code. See which methods make sense in which situations. Referencing workbooks and sheets programmatically generates a lot ...