Tag Archives: Macro
Excel VBA Programming Tutorial 4 – Saving and Opening Workbooks with Macros
You can’t save workbooks with macros in them the way your normally would a macro free excel project. This video will show you how to save them so that every time you open the workbook, the macros will open and … Continue reading
Excel VBA Programming Tutorial 2 – How to Create a Macro
Creating our first Macro and how to execute it within Excel Duration : 0:2:48 Technorati Tags: .To, 2007, 2010, Applications, basic, business, cell, computer, create, DATA, Database, Excel, free, How, how to, howto, Macro, management, microsoft, office, programming, software, system, … Continue reading
Excel VBA Programming Tutorial 3 – Accessing the Visual Basic Editor
The visual basic editor (or VBE) is one of the most important tools that we have access to. This video tutorial guides us on how to find the editor for macros and code that we have created within Excel. Duration … Continue reading
Excel 2010 VBA Tutorial 1: Setup VBA Environment
Excel 2010 VBA Tutorial 1: Setup VBA Environment. Overview of setting up the macro environment. Includes how to unhide the personal.xlsb file and setup security settings. Duration : 0:7:45 Technorati Tags: 10minutetrain, Excel 2010 VBA Tutorial 1, how to macros, … Continue reading
Excel VBA Programming Tutorial 1 – Introduction to the Developer Tab
Instructions for 2007 Excel: 1. File to Excel Options 2. Select Popular 3. Check next to Show Developer Tab 4. Click OK Duration : 0:1:35 Technorati Tags: .To, 2007, 2010, Applications, basic, business, cell, computer, DATA, Database, Developer, Excel, free, … Continue reading
“Excel VBA” Executing your own Functions from within a worksheet cell
This tutorial shows you how to create your own “VBA functions” from within the Excel VBA IDE and then call them from the top level spreadsheet by entering the function name into the cell and passing parameters. Duration : 0:9:59 … Continue reading
Excel VBA Expose Excel “Developer Tab” and simple MACRO example Tutorial
When I first got Office 2010 it took me forever to find the EXCEL developer tab. This video shows how to find and add it too the excel menu. It also has a quick example on how to record a … Continue reading
Microsoft Word letter template example
How a template can allow users to simply create professional ,branded and consistent Word documents. It uses macros written in VBA. www.brochet.co.uk Duration : 0:3:32 Technorati Tags: brand, friendly, implementation, Macro, macros, microsoft word, professional, rebrand, simple, template, User, VBA
Tutorial Excel – Funcion If .. Then .. End If – VBA
Descarga el archivo: http://www.asesorjuanmanuel.com/2011/05/tutorial-excel-funcion-if-then-end-if.html Ejemplo de como validar un codigo en visual basic para aplicaciones utilizando la funcion If..then..end if (Si condicional) para que una macro haga o no una determinada accion. COMENZAMOSSS! Duration : 0:3:50 Technorati Tags: .Clear, animation, … Continue reading
MS Excel VBA – Using Application.Speech
MS Excel VBA – Using Application.Speech If you need help regarding MS Excel or need an Excel freelancer, feel free to contact me at ExcelTutorJJ@gmail.com. You can download the workbook at http://www.box.net/shared/kh3n7te2zh. Feel free to add me on LinkedIn use … Continue reading