Summary of Macros Excel, Cap. 4 Primeras Constantes Primeras Variables @ADNDC @adanjp

00:00:00 - 00:30:00

The section discussed in these notes is titled "Macros Excel, Cap. 4 Primeras Constantes Primeras Variables @ADNDC @adanjp" and belongs to a larger series on macros in Excel. The YouTuber, Adam JP, starts the fourth video in the series by focusing on the use of constant variables and variables in macro programming. He explains the concept of designing more complex macros that can be applied universally to the entire workbook in a single click. He also explains the importance of combo boxes and using the Windows Shortcut keys to quickly navigate through the code. The video provides an overview of various variables and their uses in Excel macros, including the significance of the range object.

• 00:00:00 In this section, the YouTuber Adam JP begins the fourth video in a series on macros in Excel by focusing on the use of constant variables and variables in macro programming. He explains the concept of designing more complex macros that can be applied universally to the entire workbook in a single click. He also explains the importance of Understanding combo boxes and using the Windows Shortcut keys to quickly navigate through the code. The YouTuber also explains how to use visualbasic and Microsoft Office Excel to manipulate the macro, creating complex macros using variables and loop control structures. The video provides an overview of various variables and their uses in Excel macros, including the significance of the range object. It is suitable for intermediate-level users of Excel and demonstrates several examples of macro programming using variables and loop control structures.
• 00:05:00 In this section, the speaker provides a primer on constants and variables in macros in Excel, which is part of a larger series. The speaker first explains the concept of macros in Excel and then moves on to discuss the importance of constants and variables. They briefly touch upon the concept of records and provide an example before moving on to the topic of the video, where they explain that macros are created by batch processing a set of instructions. They also provide examples of how different recordings can work together to create a macro with a single record.
• 00:10:00 In this section, the video demonstrates how to use Excel macros to select a range of cells in a worksheet based on specified conditions using the "range" property. To do this, the user first opens the "Macros" dialog box and selects the macro they want to use. The video then walks the user through creating new macros before demonstrating an example of using the "range" property to select specific cells within a selected range based on user input. Finally, the video shows how to modify existing macros to use conditional logics such as if statements.
• 00:15:00 In this section, the speaker addresses the reservation of certain names in Excel. They mention that the names "else", "range", and "cells" are not allowed to be used as variables. The speaker explains that in Excel, variables must only accept values that are absolute, meaning they are either numbers or completely closed letters. The speaker also points out that the number 7 in Excel commands only select 8 cells. They also provide a brief explanation of the difference between "range" and "cells", and advise the use of "sets" for naming specific cells or positions. The speaker then moves on to discuss variables within Excel. They explain that variables are used to replace reservations and constants in Excel, making it more user-friendly. To name a variable, the user can modify the properties of a cell and assign a name to it. The variable must be written with lowercase letters and it is necessary to first select the row and column of the cell. The user can then open their macro, write the variable's name followed by the word "as", and use the named variable in their code. The speaker provides an example to illustrate this process.
• 00:20:00 In this section, the speaker uses variables to select cells in Excel. The first variable he creates is called "Fila" and it is the variable that corresponds to the row number. The second variable he creates is called "Columna" and it is the variable that corresponds to the column number. He then selects a specific cell using the variable "Cels" and writes a macro that selects cells based on the variables "Fiella" and "Columna". The speaker then creates a new macro called "example five" and writes another macro using the variable "f" to select cells based on the "Fiella" variable. He also uses the "range" constant to select multiple cells and writes a macro to do so using a single line of code.
• 00:25:00 In this section, the speaker explains how to create a Macro in Excel. They begin by opening parentheses and putting "2" inside, closing the parentheses, and then putting "select" on the line. They then go on to explain how to assign a title to a variable by using the "&" operator. The speaker then sets a value equal to a selected cell by using the ";" operator and assigning the value to the cell specified.
• 00:30:00 In this section, the speaker discusses the use of Excel macros to automate tasks and create forms. He explains how to use relative cell references to specify a starting point for further calculations and how to use the "Control + F" function to search for specific text within a document. He also discusses the importance of understanding Excel code and how it functions in order to create more complex programs. The speaker encourages viewers to practice using Excel macros and suggests exploring additional tutorials to learn more.