lunes, 10 de abril de 2017

Excel Macros Tutorial 1.1 | Excel Setup - Developer Tab

Excel Setup – Activate Developer Tab (1.1)


In this free course, you will learn the basics of recording and programming excel macros, how to use buttons user forms, and other tools that can help us achieve repetitive tasks in a very optimized and user friendly way.
Note that I’m going to use Excel 2013 for these tutorials.

The first thing we have to do, is to setup excel so we can visualize the developer tab. This is achieved by clicking on the top left corner “File”


Then we’ll have to click on “Options”. A new window will pop out.



Finally we have to click (1)“customize Ribbon” and check the (2)“Developer” tab.
When we click the OK button, we should now be able to see the Developer tab in our excel file:




Now we are ready to start developing Excel Macros.





No hay comentarios:

Publicar un comentario

Excel Macros Tutorial 1.4 | Types of Variables

to declare a variable, you have to do it like this: dim Variable_Name as Type_of_Variable "Dim" followed by a name for the va...