Visual Basic for Applications (VBA) is an implementation of Microsoft's event-driven programming language Visual Basic 6 and its associated integrated development environment (IDE).Visual Basic for Applications enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). It supersedes and expands on the abilities of earlier application-specific macro programming languages such as Word's WordBasic. It can be used to control many aspects of the host application, including manipulating user interface features, such as menus and toolbars, and working with custom user forms or dialog boxes.
Posts about Vba
  • Conditional Formatting Font Colour in Excel using VBA (and a sneaky trick!)

    … in the “Cells.(“ section. As you can see above, the value in 4.1 is in row 7, column 6 of the spreadsheet. The corresponding cell with the colour I want is in row 7, column 11. However, the line of code “[SourceRange].Cells(cll.row – 6, cll.Column – 5).Interior.Color” tells Excel to count the rows and columns within the range, so the top left cell is row 1…

    Adam Roberts/ Search Laboratory- 6 readers -
Get the top posts daily into your mailbox!