- Hubs »
- tagged vba
1-10 of 80 Hubssort by Hot Best Latest
64Automated Sales Tax Calculator done in Microsoft Excel 2010
An easy to build sales tax calculator.
0 comments
73A Tutorial: Sales Tax Calculator Program (code) done in Visual Basic (VB)
A Visual Basic tutorial which builds a sales tax cost calculator including form-based user interface.
0 comments
63Looping through a Single Dimensional Visual Basic Array in Excel
An array is a variable that is capable of holding multiple data elements. An array can be single dimensional or multidimensional. This module will cover single dimensional arrays. The storage capability of a single dimensional array can best...
0 comments
75Learn how to program using VBA in Excel
Unleash the power of Microsoft Excel and begin using VBA. With Visual Basic for Applications you can easily customize the functionality of any spreadsheet with simple to learn programming using VBA. This quick tutorial gives a basic introduction on how to use VBA, or program in code, for any type of spreadsheet.
0 comments60Combining String Variables and Text
One of the first things you will need find a need to do as you begin writing visual basic code is to combine text and string variables. In the previous module we learned to open workbooks in visual basic. Imagine the following situation each day...
0 comments
62Opening a Workbook in Excel and Visual Basic
The easiest method for opening a workbook in Excel is to use the keyboard shortcut Control+O. One of the main advantages of keyboard shortcuts is that they work regardless of what version of excel you are using. After pressing Control+O, a...
0 comments
62Referencing Worksheets In Excel and VBA
Think of a worksheet as a unique layer of cells within a Workbook. By default each workbook has three worksheets. Worksheets can be added or delete as needed. A user can move between worksheets by clicking the tabs located near the bottom of the...
0 comments
61Applying Borders in Excel and VBA
A border is an outline around the contents of a cell. To create a border in Excel: Select a single cell or range of cells Right Click Select Properties Click the borders tab Click the desired style of line to the left. Click the...
0 comments
68Hiding and Unhiding Rows and Columns in Excel and Visual Basic
This Excel Tutorial shows how to hide and unhide rows and column in Excel and from VBA code.
1 comment
65Setting Column Width and Using AutoFit in Excel and VBA
If you begin actively using excel it will not be long before you need to change the width of a column to accommodate so it can accommodate a larger field. Luckily for you excel makes make this task pretty easy. Move you pointer directly between...
0 comments
