{"id":2132,"date":"2013-11-04T08:58:18","date_gmt":"2013-11-04T14:58:18","guid":{"rendered":"http:\/\/aplicaexcelcontable.com\/blog\/?p=2132"},"modified":"2024-12-17T13:28:12","modified_gmt":"2024-12-17T19:28:12","slug":"curso-basico-de-vba-en-excel-1","status":"publish","type":"post","link":"https:\/\/aplicaexcelcontable.com\/blog\/curso-basico-de-vba-en-excel-1.html","title":{"rendered":"Curso Basico de VBA en Excel \u2013 1"},"content":{"rendered":"<h1 style=\"text-align: center; color: rgb(0, 0, 0) !important; --tcb-applied-color: rgb(0, 0, 0) !important;\">Programar en Excel &#8211; Curso Basico de VBA en Excel &#8211; 1<\/h1>\n<p style=\"text-align: justify;\">Comencemos con el articulo <strong>Programar en Excel &#8211; Curso Basico de VBA en Excel &#8211; 1.&nbsp;<\/strong>Para todos los usuarios Excel que no conocen el potencial que tiene Excel, hoy quiero invitarles a que entren a este mundo maravilloso donde todo es autom\u00e1tico.<\/p>\n<p style=\"text-align: justify;\">Pero es autom\u00e1tico cuando descubres el potencial de Excel, a partir de hoy te invito a que descubras esta potencia.<\/p>\n<p><span style=\"width: 100%;\"><img loading=\"lazy\" decoding=\"async\" alt=\"Curso Basico de VBA\" width=\"305\" height=\"198\" title=\"Curso Basico de VBA en Excel\" data-id=\"59819\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2013\/11\/Curso-Basico-de-VBA-en-Excel.png\" style=\"aspect-ratio: auto 624 \/ 406;\" data-width=\"305\" data-height=\"198\" data-init-width=\"624\" data-init-height=\"406\"><\/span><\/p>\n<h2 style=\"text-align: center;\">Presentaci\u00f3n Curso Basico de VBA<\/h2>\n<p style=\"text-align: justify;\">Alguna vez haz conocido completamente el potencial que tiene Excel, todav\u00eda no? Pues est\u00e1s por comenzar una de las experiencias m\u00e1s fascinantes y atractivas de la Hoja de c\u00e1lculos Excel.<\/p>\n<p style=\"text-align: justify;\">Con las Macros podr\u00e1s sorprender y sorprenderte porque incrementar\u00e1s las prestaciones y el potencial de Excel de forma ilimitada. El \u00fanico l\u00edmite que tendr\u00e1s ser\u00e1 tu imaginaci\u00f3n.<\/p>\n<h2 style=\"text-align: center;\">Excel y Macros (Curso Basico de VBA)<\/h2>\n<p style=\"text-align: justify;\">La Hoja de c\u00e1lculos Excel es una de las herramientas m\u00e1s poderosas para el tratamiento de datos y su an\u00e1lisis.<\/p>\n<p style=\"text-align: justify;\">Una de las mayores ventajas que posee es la flexibilidad que ofrece, la rapidez con la que podemos construir Plantillas y todo tipo de modelos, para diversos usos y aplicaciones.<\/p>\n<p style=\"text-align: justify;\">Sin embargo, si realmente quieres \u00abExprimir todo el Jugo\u00bb a Excel, deber\u00e1s conocer y utilizar una de sus mayores y m\u00e1s potentes herramientas: <strong>Las Macros<\/strong>.<\/p>\n<p style=\"text-align: justify;\">Y si todav\u00eda no dominas bien Excel, con estos temas te aseguro que dar\u00e1s un gran paso, por que aprender\u00e1s a automatizar Plantillas aplicando las Macros.<\/p>\n<h2 style=\"text-align: center;\">\u00bfQu\u00e9 es una Macro?<\/h2>\n<p style=\"text-align: justify;\">Es un conjunto de instrucciones de c\u00f3digo (Programado) que permiten realizar una tarea determinada como as\u00ed tambi\u00e9n expandir e incrementar las prestaciones de Excel.<\/p>\n<p style=\"text-align: justify;\">Las Macros se escriben en lenguaje de programaci\u00f3n VBA (Visual Basic For Applications). Excel ya trae incorporado un editor de VBA por lo que las Macros se programan dentro del mismo Programa Excel.<\/p>\n<p style=\"text-align: justify;\">Mucha gente le tiene un poco de miedo a la palabra \u00abprogramaci\u00f3n\u00bb, bueno, si ese es tu caso no debes preocuparte.<\/p>\n<p style=\"text-align: justify;\">Hace unos a\u00f1os nosotros mismos no ten\u00edamos la m\u00e1s m\u00ednima idea de Programaci\u00f3n Excel. Pero la buena noticia es que con un buen material (Estas en el Lugar correcto!) podr\u00e1s aprender y tomar vuelo r\u00e1pidamente en el mundo de las Macros o Programaci\u00f3n en Excel.<\/p>\n<p style=\"text-align: justify;\">Ver\u00e1s que es f\u00e1cil, divertido y que puedes expandir al infinito los l\u00edmites de Excel, as\u00ed que no olvides este es el primer tema.<\/p>\n<p style=\"text-align: justify;\">Si te gusto el tema de hoy, comp\u00e1rtelo con tus amigos de <a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\" rel=\"noopener\">Facebook<\/a>, pulsando clic en compartir:<\/p>\n<p style=\"text-align: justify;\">Y si aun no estas suscrito en nuestro canal, tan solo pulsa clic en el bot\u00f3n rojo para acceder a todos los v\u00eddeos nuevos que subimos cada semana:<\/p>\n<h1><strong>S\u00edguenos en:<\/strong><\/h1>\n<p><a href=\"https:\/\/www.facebook.com\/aplicaexcecontable\" target=\"_blank\" rel=\"  noopener\"><\/a><a href=\"http:\/\/www.youtube.com\/user\/excelycontabilidad?sub_confirmation=1\" target=\"_blank\" rel=\"  noopener\"><\/a><\/p>\n<h5 style=\"\">Para Finalizar:<\/h5>\n<p style=\"text-align: justify;\">Me gustar\u00eda saber que piensas de este articulo \u00abProgramar en Excel &#8211; Curso Basico de VBA en Excel &#8211; 1\u00bb, por lo tanto, d\u00e9jame tu comentario con dudas, criticas constructivas y sugerencias.<\/p>\n<p style=\"text-align: justify;\">Hasta aqu\u00ed hemos llegado con este articulo, para continuar con el siguiente articulo, tan solo pulsa clic en el bot\u00f3n:<\/p>\n<p style=\"\">Cualquier duda o pregunta, puedes escribirme directamente en la<span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\">&nbsp;<\/span><a href=\"#comentario\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\">secci\u00f3n de comentarios<\/span><\/a>, en la <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/contacto\" target=\"_blank\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(231, 100, 224) !important;\" data-text-highlight=\"bubble\">pagina del chat<\/span><\/a>, directamente en <span style=\"--tcb-text-highlight-color: rgb(30, 184, 76) !important;\">whatsapp<\/span> o bien al correo electr\u00f3nico rogerperez@aplicaexcelcontable.com.<span style=\"--tcb-text-highlight-color: transparent !important;\"><\/span><\/p>\n<p style=\"\">Te saluda,<span style=\"--tcb-text-highlight-color: transparent !important;\"><\/span><\/p>\n<p style=\"\"><strong>Roger Perez \u2013 Aplica Excel Contable<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Programar en Excel &#8211; Curso Basico de VBA en Excel &#8211; 1 Comencemos con el articulo Programar en Excel &#8211; Curso Basico de VBA en Excel &#8211; 1.&nbsp;Para todos los usuarios Excel que no conocen el potencial que tiene Excel, hoy quiero invitarles a que entren a este mundo maravilloso donde todo es autom\u00e1tico. Pero [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":59819,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","tve_updated_post":"<div class=\"thrv_wrapper thrv_text_element\" data-tag=\"h1\" data-css=\"tve-u-18d0d6c7ffb\" style=\"\"><h1 style=\"text-align: center; color: rgb(0, 0, 0) !important; --tcb-applied-color: rgb(0, 0, 0) !important;\" class=\"\" data-css=\"tve-u-18d0d6ccb4f\">Programar en Excel - Curso Basico de VBA en Excel - 1<\/h1><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-161d3110fac\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-161d3110fae\" style=\"text-align: justify;\">Comencemos con el articulo <strong>Programar en Excel - Curso Basico de VBA en Excel - 1.&nbsp;<\/strong>Para todos los usuarios Excel que no conocen el potencial que tiene Excel, hoy quiero invitarles a que entren a este mundo maravilloso donde todo es autom\u00e1tico.<\/p><p data-css=\"tve-u-161d3110fae\" style=\"text-align: justify;\">Pero es autom\u00e1tico cuando descubres el potencial de Excel, a partir de hoy te invito a que descubras esta potencia.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-168e4d8065c\"><span class=\"tve_image_frame\" style=\"width: 100%;\"><img loading=\"lazy\" decoding=\"async\" class=\"tve_image wp-image-59819 tcb-moved-image\" alt=\"Curso Basico de VBA\" width=\"305\" height=\"198\" title=\"Curso Basico de VBA en Excel\" data-id=\"59819\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2013\/11\/Curso-Basico-de-VBA-en-Excel.png\" style=\"aspect-ratio: auto 624 \/ 406;\" data-width=\"305\" data-height=\"198\" data-init-width=\"624\" data-init-height=\"406\" data-css=\"tve-u-19397feb81d\"><\/span><\/div><div class=\"thrv_wrapper thrv_text_element\" data-tag=\"h2\" data-css=\"tve-u-18d0d6f30eb\" style=\"\"><h2 style=\"text-align: center;\" class=\"\" data-css=\"tve-u-18d0d6df09d\">Presentaci\u00f3n Curso Basico de VBA<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-161d35a5acd\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-161d35a5ace\" style=\"text-align: justify;\">Alguna vez haz conocido completamente el potencial que tiene Excel, todav\u00eda no? Pues est\u00e1s por comenzar una de las experiencias m\u00e1s fascinantes y atractivas de la Hoja de c\u00e1lculos Excel.<\/p><p data-css=\"tve-u-161d35a5ace\" style=\"text-align: justify;\">Con las Macros podr\u00e1s sorprender y sorprenderte porque incrementar\u00e1s las prestaciones y el potencial de Excel de forma ilimitada. El \u00fanico l\u00edmite que tendr\u00e1s ser\u00e1 tu imaginaci\u00f3n.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" data-tag=\"h3\" data-css=\"tve-u-18d0d726d8a\" style=\"\"><h2 class=\"\" style=\"text-align: center;\" data-css=\"tve-u-19397ffbf9f\">Excel y Macros (Curso Basico de VBA)<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-161d35d0e4d\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-161d35d0e4e\" style=\"text-align: justify;\">La Hoja de c\u00e1lculos Excel es una de las herramientas m\u00e1s poderosas para el tratamiento de datos y su an\u00e1lisis.<\/p><p data-css=\"tve-u-161d35d0e4e\" style=\"text-align: justify;\">Una de las mayores ventajas que posee es la flexibilidad que ofrece, la rapidez con la que podemos construir Plantillas y todo tipo de modelos, para diversos usos y aplicaciones.<\/p><p data-css=\"tve-u-161d35d0e4e\" style=\"text-align: justify;\">Sin embargo, si realmente quieres \"Exprimir todo el Jugo\" a Excel, deber\u00e1s conocer y utilizar una de sus mayores y m\u00e1s potentes herramientas: <strong>Las Macros<\/strong>.<\/p><p data-css=\"tve-u-161d35d0e4e\" style=\"text-align: justify;\">Y si todav\u00eda no dominas bien Excel, con estos temas te aseguro que dar\u00e1s un gran paso, por que aprender\u00e1s a automatizar Plantillas aplicando las Macros.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" data-tag=\"h4\" data-css=\"tve-u-18d0d7295ef\" style=\"\"><h2 class=\"\" style=\"text-align: center;\">\u00bfQu\u00e9 es una Macro?<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-161d360798c\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-161d360798e\" style=\"text-align: justify;\">Es un conjunto de instrucciones de c\u00f3digo (Programado) que permiten realizar una tarea determinada como as\u00ed tambi\u00e9n expandir e incrementar las prestaciones de Excel.<\/p><p data-css=\"tve-u-161d360798e\" style=\"text-align: justify;\">Las Macros se escriben en lenguaje de programaci\u00f3n VBA (Visual Basic For Applications). Excel ya trae incorporado un editor de VBA por lo que las Macros se programan dentro del mismo Programa Excel.<\/p><p data-css=\"tve-u-161d360798e\" style=\"text-align: justify;\">Mucha gente le tiene un poco de miedo a la palabra \"programaci\u00f3n\", bueno, si ese es tu caso no debes preocuparte.<\/p><p data-css=\"tve-u-161d360798e\" style=\"text-align: justify;\">Hace unos a\u00f1os nosotros mismos no ten\u00edamos la m\u00e1s m\u00ednima idea de Programaci\u00f3n Excel. Pero la buena noticia es que con un buen material (Estas en el Lugar correcto!) podr\u00e1s aprender y tomar vuelo r\u00e1pidamente en el mundo de las Macros o Programaci\u00f3n en Excel.<\/p><p data-css=\"tve-u-161d360798e\" style=\"text-align: justify;\">Ver\u00e1s que es f\u00e1cil, divertido y que puedes expandir al infinito los l\u00edmites de Excel, as\u00ed que no olvides este es el primer tema.<\/p><p data-css=\"tve-u-161d360798e\" style=\"text-align: justify;\">Si te gusto el tema de hoy, comp\u00e1rtelo con tus amigos de <a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\">Facebook<\/a>, pulsando clic en compartir:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_social_custom thrv_social tve_share_left\" data-counts=\"\" data-min_shares=\"0\" data-css=\"tve-u-18d0d74f49c\">\n<div class=\"tve_social_items tve_social_custom tve_style_1 tve_social_itb tve-prevent-content-edit\">\n<div class=\"tve_s_item tve_s_fb_share thrv_wrapper tve_share_item\" data-s=\"fb_share\" data-href=\"https:\/\/aplicaexcelcontable.com\/blog\/sistema-de-facturacion-en-excel.html\" data-label=\"Compartir\" data-css=\"tve-u-18be2dd4a6b\">\n<a href=\"javascript:void(0)\" class=\"tve_s_link\"><span class=\"tve_s_icon thrv-svg-icon\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"tcb-facebook\" viewBox=\"0 0 16 28\"><path d=\"M14.984 0.187v4.125h-2.453q-1.344 0-1.813 0.562t-0.469 1.687v2.953h4.578l-0.609 4.625h-3.969v11.859h-4.781v-11.859h-3.984v-4.625h3.984v-3.406q0-2.906 1.625-4.508t4.328-1.602q2.297 0 3.563 0.187z\"><\/path><\/svg><\/span><span class=\"tve_s_text\">Compartir<\/span><span class=\"tve_s_count\">0<\/span><\/a>\n<\/div>\n<\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-161d3663045\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-161d3663046\" style=\"text-align: justify;\">Y si aun no estas suscrito en nuestro canal, tan solo pulsa clic en el bot\u00f3n rojo para acceder a todos los v\u00eddeos nuevos que subimos cada semana:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-18d0d75c7ac\" style=\"\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-18d0d75c7ab\"><div class=\"thrv_wrapper thrv_text_element\" data-tag=\"h1\" style=\"\" data-css=\"tve-u-18d0d75c7b6\"><h1 data-css=\"tve-u-18d0d75c7b2\" class=\"\"><strong>S\u00edguenos en:<\/strong><\/h1><\/div><div class=\"thrv_wrapper thrv-columns\" data-css=\"tve-u-18d0d75c7aa\" style=\"--tcb-col-el-width: 181;\"><div class=\"tcb-flex-row tcb--cols--2 tcb-resized\" style=\"\" data-css=\"tve-u-18d0d75c7b5\"><div class=\"tcb-flex-col\" data-css=\"tve-u-18d0d75c7af\" style=\"\"><div class=\"tcb-col tve_empty_dropzone\" data-css=\"tve-u-18d0d75c7b9\"><a href=\"https:\/\/www.facebook.com\/aplicaexcecontable\" target=\"_blank\" rel=\" \" class=\"tve_empty_dropzone\"><div class=\"thrv_wrapper thrv_icon tcb-icon-display\" data-css=\"tve-u-18d0d75c7b1\" data-link-wrap=\"1\"><svg class=\"tcb-icon\" viewBox=\"0 0 24 28\" data-name=\"facebook-official\">\n<path d=\"M22.672 2c0.734 0 1.328 0.594 1.328 1.328v21.344c0 0.734-0.594 1.328-1.328 1.328h-6.109v-9.297h3.109l0.469-3.625h-3.578v-2.312c0-1.047 0.281-1.75 1.797-1.75l1.906-0.016v-3.234c-0.328-0.047-1.469-0.141-2.781-0.141-2.766 0-4.672 1.687-4.672 4.781v2.672h-3.125v3.625h3.125v9.297h-11.484c-0.734 0-1.328-0.594-1.328-1.328v-21.344c0-0.734 0.594-1.328 1.328-1.328h21.344z\"><\/path>\n<\/svg><\/div><\/a><\/div><\/div><div class=\"tcb-flex-col\" data-css=\"tve-u-18d0d75c7ad\" style=\"\"><div class=\"tcb-col tve_empty_dropzone\" data-css=\"tve-u-18d0d75c7b8\"><a href=\"http:\/\/www.youtube.com\/user\/excelycontabilidad?sub_confirmation=1\" target=\"_blank\" rel=\" \" class=\"tve_empty_dropzone\"><div class=\"thrv_wrapper thrv_icon tcb-icon-display tve-viewport-triggered\" data-css=\"tve-u-18d0d75c7b0\" data-link-wrap=\"1\" style=\"\"><svg class=\"tcb-icon\" viewBox=\"0 0 24 28\" data-name=\"youtube\">\n<path d=\"M15.172 19.437v3.297c0 0.703-0.203 1.047-0.609 1.047-0.234 0-0.469-0.109-0.703-0.344v-4.703c0.234-0.234 0.469-0.344 0.703-0.344 0.406 0 0.609 0.359 0.609 1.047zM20.453 19.453v0.719h-1.406v-0.719c0-0.703 0.234-1.062 0.703-1.062s0.703 0.359 0.703 1.062zM5.359 16.047h1.672v-1.469h-4.875v1.469h1.641v8.891h1.563v-8.891zM9.859 24.938h1.391v-7.719h-1.391v5.906c-0.313 0.438-0.609 0.656-0.891 0.656-0.187 0-0.297-0.109-0.328-0.328-0.016-0.047-0.016-0.219-0.016-0.547v-5.688h-1.391v6.109c0 0.547 0.047 0.906 0.125 1.141 0.125 0.391 0.453 0.578 0.906 0.578 0.5 0 1.031-0.313 1.594-0.953v0.844zM16.562 22.625v-3.078c0-0.719-0.031-1.234-0.141-1.547-0.172-0.578-0.562-0.875-1.109-0.875-0.516 0-1 0.281-1.453 0.844v-3.391h-1.391v10.359h1.391v-0.75c0.469 0.578 0.953 0.859 1.453 0.859 0.547 0 0.938-0.297 1.109-0.859 0.109-0.328 0.141-0.844 0.141-1.563zM21.844 22.469v-0.203h-1.422c0 0.562-0.016 0.875-0.031 0.953-0.078 0.375-0.281 0.562-0.625 0.562-0.484 0-0.719-0.359-0.719-1.078v-1.359h2.797v-1.609c0-0.828-0.141-1.422-0.422-1.813-0.406-0.531-0.953-0.797-1.656-0.797-0.719 0-1.266 0.266-1.672 0.797-0.297 0.391-0.438 0.984-0.438 1.813v2.703c0 0.828 0.156 1.437 0.453 1.813 0.406 0.531 0.953 0.797 1.687 0.797s1.313-0.281 1.687-0.828c0.172-0.25 0.297-0.531 0.328-0.844 0.031-0.141 0.031-0.453 0.031-0.906zM12.344 8.203v-3.281c0-0.719-0.203-1.078-0.672-1.078-0.453 0-0.672 0.359-0.672 1.078v3.281c0 0.719 0.219 1.094 0.672 1.094 0.469 0 0.672-0.375 0.672-1.094zM23.578 19.938c0 1.797-0.016 3.719-0.406 5.469-0.297 1.234-1.297 2.141-2.5 2.266-2.875 0.328-5.781 0.328-8.672 0.328s-5.797 0-8.672-0.328c-1.203-0.125-2.219-1.031-2.5-2.266-0.406-1.75-0.406-3.672-0.406-5.469v0c0-1.813 0.016-3.719 0.406-5.469 0.297-1.234 1.297-2.141 2.516-2.281 2.859-0.313 5.766-0.313 8.656-0.313s5.797 0 8.672 0.313c1.203 0.141 2.219 1.047 2.5 2.281 0.406 1.75 0.406 3.656 0.406 5.469zM7.984 0h1.594l-1.891 6.234v4.234h-1.563v-4.234c-0.141-0.766-0.453-1.859-0.953-3.313-0.344-0.969-0.688-1.953-1.016-2.922h1.656l1.109 4.109zM13.766 5.203v2.734c0 0.828-0.141 1.453-0.438 1.844-0.391 0.531-0.938 0.797-1.656 0.797-0.703 0-1.25-0.266-1.641-0.797-0.297-0.406-0.438-1.016-0.438-1.844v-2.734c0-0.828 0.141-1.437 0.438-1.828 0.391-0.531 0.938-0.797 1.641-0.797 0.719 0 1.266 0.266 1.656 0.797 0.297 0.391 0.438 1 0.438 1.828zM19 2.672v7.797h-1.422v-0.859c-0.562 0.656-1.094 0.969-1.609 0.969-0.453 0-0.781-0.187-0.922-0.578-0.078-0.234-0.125-0.609-0.125-1.172v-6.156h1.422v5.734c0 0.328 0 0.516 0.016 0.547 0.031 0.219 0.141 0.344 0.328 0.344 0.281 0 0.578-0.219 0.891-0.672v-5.953h1.422z\"><\/path>\n<\/svg><\/div><\/a><\/div><\/div><\/div><\/div><div class=\"thrv_wrapper thrv_icon tcb-icon-display tve-viewport-triggered\" data-css=\"tve-u-18d0d75c7b3\" style=\"\"><svg class=\"tcb-icon\" viewBox=\"0 0 26 28\" data-name=\"hand-pointer-o\">\n<path d=\"M10 2c-1.109 0-2 0.891-2 2v14l-2.359-3.156c-0.391-0.516-1.016-0.844-1.672-0.844-1.094 0-1.969 0.922-1.969 2 0 0.438 0.141 0.859 0.406 1.203l6 8c0.375 0.5 0.969 0.797 1.594 0.797h11.219c0.453 0 0.859-0.313 0.969-0.75l1.437-5.75c0.25-1 0.375-2.016 0.375-3.031v-3.391c0-0.828-0.641-1.578-1.5-1.578-0.828 0-1.5 0.672-1.5 1.5h-0.5v-0.953c0-0.984-0.75-1.797-1.75-1.797-0.969 0-1.75 0.781-1.75 1.75v1h-0.5v-1.406c0-1.125-0.859-2.094-2-2.094-1.109 0-2 0.891-2 2v1.5h-0.5v-8.906c0-1.125-0.859-2.094-2-2.094zM10 0c2.234 0 4 1.875 4 4.094v3.437c0.172-0.016 0.328-0.031 0.5-0.031 1.016 0 1.969 0.391 2.703 1.078 0.484-0.219 1.016-0.328 1.547-0.328 1.125 0 2.172 0.5 2.875 1.359 0.297-0.078 0.578-0.109 0.875-0.109 1.969 0 3.5 1.641 3.5 3.578v3.391c0 1.172-0.141 2.359-0.438 3.516l-1.437 5.75c-0.328 1.328-1.531 2.266-2.906 2.266h-11.219c-1.25 0-2.453-0.609-3.203-1.594l-6-8c-0.516-0.688-0.797-1.547-0.797-2.406 0-2.188 1.781-4 3.969-4 0.719 0 1.422 0.187 2.031 0.547v-8.547c0-2.203 1.797-4 4-4zM12 22v-6h-0.5v6h0.5zM16 22v-6h-0.5v6h0.5zM20 22v-6h-0.5v6h0.5z\"><\/path>\n<\/svg><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" data-css=\"tve-u-18d0d77042e\" style=\"\"><h5 class=\"\" style=\"\" data-css=\"tve-u-18d0d76c365\">Para Finalizar:<\/h5><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-161d3663045\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-161d3663046\" style=\"text-align: justify;\">Me gustar\u00eda saber que piensas de este articulo \"Programar en Excel - Curso Basico de VBA en Excel - 1\", por lo tanto, d\u00e9jame tu comentario con dudas, criticas constructivas y sugerencias.<\/p><p data-css=\"tve-u-161d3663046\" style=\"text-align: justify;\">Hasta aqu\u00ed hemos llegado con este articulo, para continuar con el siguiente articulo, tan solo pulsa clic en el bot\u00f3n:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv-button thrv-button-v2 tcb-local-vars-root\" data-css=\"tve-u-18d0d84a0a4\" style=\"\" data-button-size-d=\"m\">\n\t<div class=\"thrive-colors-palette-config\" style=\"display: none !important\">__CONFIG_colors_palette__{\"active_palette\":0,\"config\":{\"colors\":{\"62516\":{\"name\":\"Main Accent\",\"parent\":-1}},\"gradients\":[]},\"palettes\":[{\"name\":\"Default Palette\",\"value\":{\"colors\":{\"62516\":{\"val\":\"rgb(0, 255, 0)\"}},\"gradients\":[]}}]}__CONFIG_colors_palette__<\/div>\n\t<a href=\"https:\/\/aplicaexcelcontable.com\/blog\/utilidad-de-una-macro.html\" class=\"tcb-button-link tcb-plain-text\" style=\"\" target=\"_blank\">\n\t\t<span class=\"tcb-button-texts\"><span class=\"tcb-button-text thrv-inline-text\"><strong><span style=\"font-size: 20px !important;\" data-css=\"tve-u-18d0d84a0a6\">Pulsa clic aqu\u00ed P\/Ver el Tema 2 \u2192<\/span> <\/strong><\/span><\/span>\n\t<\/a>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-1939801475b\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-1939801475a\"><div class=\"thrv_wrapper thrv_text_element tcb-highlight-added\">\t<p style=\"\">Cualquier duda o pregunta, puedes escribirme directamente en la<span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\" data-css=\"tve-u-1939801475c\">&nbsp;<\/span><a href=\"#comentario\" class=\"tve-jump-scroll\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\" data-css=\"tve-u-1939801475d\">secci\u00f3n de comentarios<\/span><\/a>, en la <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/contacto\" target=\"_blank\" class=\"\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(231, 100, 224) !important;\" data-css=\"tve-u-1939801475f\" data-text-highlight=\"bubble\">pagina del chat<\/span><\/a>, directamente en <span style=\"--tcb-text-highlight-color: rgb(30, 184, 76) !important;\" data-css=\"tve-u-19398014760\">whatsapp<\/span> o bien al correo electr\u00f3nico rogerperez@aplicaexcelcontable.com.<span style=\"--tcb-text-highlight-color: transparent !important;\" data-css=\"tve-u-19398014761\"><\/span><\/p><p style=\"\">Te saluda,<span style=\"--tcb-text-highlight-color: transparent !important;\"><\/span><\/p><p style=\"\"><strong>Roger Perez \u2013 Aplica Excel Contable<\/strong><\/p><\/div><\/div>\n<\/div>","tve_custom_css":"@media (min-width: 300px){[data-css=\"tve-u-161d3110fac\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-161d3110fae\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-161d35a5acd\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-161d35a5ace\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-161d35d0e4d\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-161d35d0e4e\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-161d360798c\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-161d360798e\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-161d3663045\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-161d3663046\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-168e4d8065c\"] { width: 305px; float: none; margin-left: auto !important; margin-right: auto !important; }[data-css=\"tve-u-18d0d6c7ffb\"] { margin-top: 20px !important; margin-bottom: 20px !important; }:not(#tve) [data-css=\"tve-u-18d0d6ccb4f\"] { font-size: 42px !important; }:not(#tve) [data-css=\"tve-u-18d0d6df09d\"] { font-size: 38px !important; color: rgb(0, 0, 0) !important; --tcb-applied-color: rgb(0,0,0) !important; --tve-applied-color: rgb(0,0,0) !important; }[data-css=\"tve-u-18d0d6f30eb\"] { margin-top: 20px !important; margin-bottom: 20px !important; }[data-css=\"tve-u-18d0d726d8a\"] { margin-top: 20px !important; margin-bottom: 20px !important; }[data-css=\"tve-u-18d0d7295ef\"] { margin-top: 20px !important; margin-bottom: 20px !important; }[data-css=\"tve-u-18d0d74f49c\"] { float: none; margin-left: auto !important; margin-right: auto !important; }[data-css=\"tve-u-18d0d75c7aa\"] { margin-top: -55px !important; margin-left: 25px !important; }[data-css=\"tve-u-18d0d75c7ab\"] { min-height: 1px; }[data-css=\"tve-u-18d0d75c7ac\"] { max-width: 208px; float: none; z-index: 3; position: relative; width: 100%; --tve-alignment: center; margin-top: 20px !important; margin-left: auto !important; margin-right: auto !important; padding-left: 1px !important; }[data-css=\"tve-u-18d0d75c7ad\"] { max-width: 81.3%; }[data-css=\"tve-u-18d0d75c7af\"] { max-width: 18.7%; }:not(#tve) [data-css=\"tve-u-18d0d75c7b0\"] > :first-child { color: rgb(191, 20, 20); }:not(#tve) [data-css=\"tve-u-18d0d75c7b1\"] > :first-child { color: rgb(60, 18, 215); }:not(#tve) [data-css=\"tve-u-18d0d75c7b2\"] { font-size: 26px !important; color: rgb(3, 77, 44) !important; }[data-css=\"tve-u-18d0d75c7b3\"] { font-size: 60px; margin-top: -50px !important; margin-left: 100px !important; }[data-css=\"tve-u-18d0d75c7b1\"] { font-size: 60px; }[data-css=\"tve-u-18d0d75c7b0\"] { font-size: 60px; margin-right: 65px !important; margin-left: 45px !important; }[data-css=\"tve-u-18d0d75c7b5\"] { padding-left: 0px !important; }[data-css=\"tve-u-18d0d75c7b6\"] { padding-left: 15px !important; }:not(#tve) [data-css=\"tve-u-18d0d76c365\"] { font-size: 25px !important; color: rgb(0, 0, 0) !important; --tcb-applied-color: rgb(0,0,0) !important; --tve-applied-color: rgb(0,0,0) !important; }[data-css=\"tve-u-18d0d77042e\"] { margin-top: 20px !important; margin-bottom: 20px !important; }[data-css=\"tve-u-18d0d84a0a4\"] .tcb-button-link { letter-spacing: 2px; background-image: linear-gradient(var(--tcb-local-color-62516,rgb(19,114,211)),var(--tcb-local-color-62516,rgb(19,114,211))); --tve-applied-background-image: linear-gradient(var$(--tcb-local-color-62516,rgb(19,114,211)),var$(--tcb-local-color-62516,rgb(19,114,211))); background-size: auto; background-attachment: scroll; border-radius: 10px; padding: 14px 22px; background-position: 50% 50%; background-repeat: no-repeat; overflow: hidden; border: none; --tve-applied-border: none; background-color: transparent !important; }[data-css=\"tve-u-18d0d84a0a4\"] .tcb-button-link span { color: rgb(255, 255, 255); --tcb-applied-color: #fff; }[data-css=\"tve-u-18d0d84a0a4\"] { --tve-border-radius: 10px; --tcb-local-color-62516: rgb(0,255,0) !important; }:not(#tve) [data-css=\"tve-u-18d0d84a0a4\"] .tcb-button-link { line-height: 1.2em; font-size: 24px; }[data-css=\"tve-u-18d0d84a0a6\"] { font-size: 20px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper { width: calc(100% + 0px); }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:nth-child(n+2) { margin-top: 50px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:not(:nth-child(n+2)) { margin-top: 0px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:not(:nth-child(n)) { margin-right: 30px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:nth-child(n) { margin-right: 0px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper { width: calc(33.3333% - 13.3333px); }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:nth-child(n+4) { margin-top: 20px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:not(:nth-child(n+4)) { margin-top: 0px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:not(:nth-child(3n)) { margin-right: 20px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:nth-child(3n) { margin-right: 0px !important; }:not(#tve) [data-css=\"tve-u-19397ffbf9f\"] { font-size: 38px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-1939801475a\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-1939801475a\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-1939801475a\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-1939801475a\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-1939801475a\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-1939801475a\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-1939801475a\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-1939801475a\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-1939801475a\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-1939801475a\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-1939801475a\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-1939801475a\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-1939801475a\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-1939801475a\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-1939801475a\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-1939801475a\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-1939801475a\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-1939801475a\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-1939801475a\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-1939801475a\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-1939801475b\"] { margin-top: 20px !important; margin-bottom: 20px !important; padding: 0px !important; }[data-css=\"tve-u-1939801475c\"] { --tcb-text-highlight-color: rgb(237,243,13) !important; }[data-css=\"tve-u-1939801475d\"] { --tcb-text-highlight-color: rgb(237,243,13) !important; }[data-css=\"tve-u-1939801475f\"] { --tve-highlight-background: url(\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20314%20114%22%20preserveAspectRatio%3D'none'%3E%0A%09%09%09%09%09%3Cpath%20d%3D%22M149.412%202.398C98.053%204.579%2074.996%207.562%2053.903%2014.754%2028.892%2023.283%208.503%2040.617%202.929%2058.09c-4.148%2013.004-.464%2026.402%2010.207%2037.118%205.664%205.687%2015.228%2012.328%2021.753%2015.104%202.939%201.25%208.598%202.708%2010.559%202.72%201.16.008%201.111-.129-.909-2.543-2.554-3.05-4.753-7.567-4.761-9.775-.008-2.502%202.482-6.937%204.862-8.661%205.613-4.066%2020.333-6.115%2050.607-7.046%2012.81-.394%2019.622.068%2047.623%203.231%2057%206.439%2066.925%207.222%2091.845%207.248%2016.516.016%2020.951-.139%2026.167-.919%2020.12-3.007%2032.633-8.401%2041.489-17.883%206.859-7.344%2010.154-16.516%2010.254-28.537.032-3.902-.231-7.704-.651-9.42-5.257-21.464-31.961-33.668-80.137-36.622-11.85-.727-62.651-.546-82.425.293%22%2F%3E%0A%09%09%09%09%3C%2Fsvg%3E\"); --tcb-text-highlight-color: #2ABB61 !important; }[data-css=\"tve-u-19398014760\"] { --tcb-text-highlight-color: rgb(30,184,76) !important; }[data-css=\"tve-u-19398014761\"] { --tcb-text-highlight-color: transparent !important; }}@media (max-width: 767px){[data-css=\"tve-u-18d0d75c7b3\"] { margin-left: 90px !important; }[data-css=\"tve-u-18d0d75c7b8\"] { margin-left: 128px !important; padding-left: 1px !important; margin-right: -51px !important; margin-top: -96px !important; }[data-css=\"tve-u-18d0d75c7b9\"] { margin-left: -16px !important; padding-left: 0px !important; padding-right: 0px !important; margin-right: 0px !important; }[data-css=\"tve-u-18d0d75c7b1\"] { margin-left: 20px !important; }[data-css=\"tve-u-18d0d75c7b0\"] { margin-left: -35px !important; }}","tve_user_custom_css":"","tve_globals":{"e":"1","font_cls":[]},"tcb2_ready":1,"tcb_editor_enabled":1,"tve_landing_page":"","_tve_header":"","_tve_footer":""},"categories":[22,4],"tags":[293,292,295,294],"class_list":["post-2132","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-curso-basico-de-vba","category-programar-en-excel","tag-aprender-excel","tag-excel-y-contabilidad","tag-plantillas-excel","tag-programar-en-excel","post-wrapper","thrv_wrapper"],"_links":{"self":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/2132","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/comments?post=2132"}],"version-history":[{"count":0,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/2132\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media\/59819"}],"wp:attachment":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media?parent=2132"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/categories?post=2132"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/tags?post=2132"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}