Ad Clicks : Ad Views :
Excel formulas and tutorials

Excel formulas and useful tools

Category: VBA

img

Excel macro for loop

By
|
In Excel Macro , VBA
|
On October 14, 2016
This is a tutorial for beginners to learn excel macro for loop. Loop sequences may be achieved by using a FOR block or a WHILE. Macro for loop using FOR A FOR block looks like this: For i = 1 To 100     Range(“A” & i) = “Number” & i Next i Where i is […]

Run macro on open file event

By
|
On October 14, 2016

In order to run macro on open file event you need to have the VBA code (macro) inside the Workbook_Open() event in ThisWorkbook element on Project Explorer. You must first open the VBA editor in Excel

Excel VBA Macro

By
|
On October 12, 2016

This is a tutorial for anyone wanting to learn how to write their first excel vba macro. These macros are very useful when we need to do a lot of manual work on large data tables and these manual acti

img
Comboboxes are user friendly data input forms that can make the difference between a quality looking form and a archaic data input screen. Defining combobox in Excel For this step you must go to the Excel Developer menu, make sure you have this menu since it doesn’t come activated in Excel Options. Select the Insert […]

Making Excel file unsavable

By
|
On May 8, 2014

Some companies use Excel files through intranet networks for all their staff to have access to certain information and automated reports. This usually means that this kind of file should be unsavable

img
Building automated reports in Excel by connecting directly to an ERP database is a good shortcut to have fresh and accurate information to base your decisions on. This method facilitates data processing and manipulation in VBA before results and conclusions are displayed and a further availability for organizing, calculations and sorting after Excel tables are […]
It is main inner container footer text