{"id":11393,"date":"2022-09-11T19:52:01","date_gmt":"2022-09-11T10:52:01","guid":{"rendered":"https:\/\/prodskill.com\/?p=11393"},"modified":"2022-10-11T11:42:51","modified_gmt":"2022-10-11T02:42:51","slug":"excel-vba-lecture-9-how-to","status":"publish","type":"post","link":"https:\/\/prodskill.com\/es\/excel-vba-lecture-9-how-to\/","title":{"rendered":"Cursos de Excel VBA (9): Procedimientos de Excel VBA"},"content":{"rendered":"<p>Este art\u00edculo examina el procedimiento de Excel VBA. Cons\u00faltelo cuando codifique Excel VBA.<\/p>\n\n\n\n<p>Esta es una continuaci\u00f3n del art\u00edculo anterior.<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-8-datatype\/\">Curso Excel VBA (8): Conceptos b\u00e1sicos del lenguaje Excel VBA: tipos de datos, estructuras de datos<\/a><\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">&lt;&lt;Tabla de contenidos&gt;&gt;<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Pesta\u00f1a de contenido alternativo\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Palanca<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-9-how-to\/#4_%EC%97%91%EC%85%80_VBA_How-To\" >4. Procedimientos de Excel VBA<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-9-how-to\/#41_UIUser_Interface_%EA%B5%AC%EC%84%B1_%EB%B0%A9%EB%B2%95\" >4.1. C\u00f3mo configurar la interfaz de usuario (UI)<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-9-how-to\/#411_%EC%97%91%EC%85%80_Sheet%EB%A5%BC_%EC%82%AC%EC%9A%A9%ED%95%9C_UI\" >4.1.1. Interfaz de usuario con hoja de Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-9-how-to\/#412_User_Form%EC%9D%84_%EC%82%AC%EC%9A%A9%ED%95%9C_UI\" >4.1.2. Interfaz de usuario con formulario de usuario<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-9-how-to\/#412_Ribbon_Bar%EB%A5%BC_%EC%82%AC%EC%9A%A9%ED%95%9C_UI\" >4.1.2. Interfaz de usuario con barra de cinta<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-9-how-to\/#42_VBA_%EC%BD%94%EB%93%9C%EB%A5%BC_%EC%8B%A4%ED%96%89%ED%95%98%EB%8A%94_%EB%B0%A9%EB%B2%95\" >4.2. C\u00f3mo ejecutar c\u00f3digo VBA<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-9-how-to\/#421_%EB%B2%84%ED%8A%BC_%ED%81%B4%EB%A6%AD_%EC%9D%B4%EB%B2%A4%ED%8A%B8%EC%97%90%EC%84%9C_%EC%8B%A4%ED%96%89\" >4.2.1. Ejecutar en evento de clic de bot\u00f3n<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-9-how-to\/#422_%EC%8B%A4%ED%96%89%ED%95%A0_%EC%86%8C%EC%8A%A4%EC%BD%94%EB%93%9C%EC%97%90_%EC%BB%A4%EC%84%9C_%EC%9C%84%EC%B9%98%EC%8B%9C%ED%82%A4%EA%B3%A0_%EB%8B%A8%EC%B6%95%ED%82%A4%EB%A1%9C_%EC%8B%A4%ED%96%89\" >4.2.2. Coloque el cursor sobre el c\u00f3digo fuente a ejecutar y ejec\u00fatelo con una tecla de m\u00e9todo abreviado<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-9-how-to\/#423_%EC%A7%81%EC%A0%91_%EC%8B%A4%ED%96%89_%EC%B0%BD%EC%97%90%EC%84%9C_%EC%8B%A4%ED%96%89\" >4.2.3. Ejecutar en ventana inmediata<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-9-how-to\/#43_%EC%A7%81%EC%A0%91_%EC%8B%A4%ED%96%89_%EC%B0%BD_%EB%8F%84%EA%B5%AC_%ED%99%9C%EC%9A%A9_%EB%B0%A9%EB%B2%95\" >4.3. C\u00f3mo utilizar la herramienta Ventana inmediata<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-9-how-to\/#44_%EA%B0%9C%EC%B2%B4_%EC%B0%BE%EC%95%84%EB%B3%B4%EA%B8%B0_%EB%8F%84%EA%B5%AC_%ED%99%9C%EC%9A%A9_%EB%B0%A9%EB%B2%95\" >4.4. C\u00f3mo utilizar la herramienta Examinar objetos<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-9-how-to\/#45_VBA_%EC%84%B1%EB%8A%A5_%ED%96%A5%EC%83%81_%EB%B0%A9%EB%B2%95\" >4.5. C\u00f3mo mejorar el rendimiento de VBA<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-9-how-to\/#46_%EB%A7%A4%ED%81%AC%EB%A1%9C_%EA%B8%B0%EB%A1%9D%EA%B8%B0_%ED%99%9C%EC%9A%A9_%EB%B0%A9%EB%B2%95\" >4.6. C\u00f3mo usar la grabadora de macros<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-9-how-to\/#47_%EC%BD%94%EB%94%A9%EC%8B%9C_%EC%A7%80%ED%82%A4%EB%A9%B4_%EC%A2%8B%EC%9D%84_%EA%B8%B0%EB%B3%B8_%EC%9B%90%EC%B9%99\" >4.7. Principios b\u00e1sicos a seguir al programar<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"4._\uc5d1\uc140_VBA_How-To\"><span class=\"ez-toc-section\" id=\"4_%EC%97%91%EC%85%80_VBA_How-To\"><\/span>4. Procedimientos de Excel VBA<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"4.1._UI(User_Interface)_\uad6c\uc131_\ubc29\ubc95\"><span class=\"ez-toc-section\" id=\"41_UIUser_Interface_%EA%B5%AC%EC%84%B1_%EB%B0%A9%EB%B2%95\"><\/span>4.1. C\u00f3mo configurar la interfaz de usuario (UI)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>En Excel VBA, hay tres formas de configurar la interfaz de usuario, como recibir valores del usuario o mostrar el progreso.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"4.1.1._\uc5d1\uc140_Sheet\ub97c_\uc0ac\uc6a9\ud55c_UI\"><span class=\"ez-toc-section\" id=\"411_%EC%97%91%EC%85%80_Sheet%EB%A5%BC_%EC%82%AC%EC%9A%A9%ED%95%9C_UI\"><\/span>4.1.1. Interfaz de usuario con hoja de Excel<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Este es el m\u00e9todo m\u00e1s com\u00fan. Agregue controles como botones, cuadros de texto y casillas de verificaci\u00f3n a la hoja de Excel y maneje eventos. Es el m\u00e1s f\u00e1cil de implementar y conveniente de usar, ya que puede hacer clic en un bot\u00f3n mientras mira los datos.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-96.png\"><img loading=\"lazy\" decoding=\"async\" width=\"345\" height=\"358\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-96.png\" alt=\"\uc5d1\uc140 Sheet\ub97c \uc0ac\uc6a9\ud55c UI\" class=\"wp-image-11394\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-96.png 345w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-96-289x300.png 289w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-96-12x12.png 12w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-96-24x24.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-96-36x36.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-96-46x48.png 46w\" sizes=\"auto, (max-width: 345px) 100vw, 345px\" \/><\/a><figcaption>Interfaz de usuario con hoja de Excel<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Este m\u00e9todo tiene un inconveniente. Si hace clic en un bot\u00f3n despu\u00e9s de cambiar la resoluci\u00f3n de la pantalla, el tama\u00f1o del bot\u00f3n contin\u00faa aumentando o el tama\u00f1o del texto disminuye. Principalmente, cuando se cambia el monitor externo o se conecta a un proyector de haz, la resoluci\u00f3n de la pantalla cambia, y este fen\u00f3meno casi siempre ocurre si la hoja de Excel que contiene el control est\u00e1 abierta en ese momento. Este fen\u00f3meno ocurre cuando se usa un control ActiveX y no ocurre cuando se usa un control de formulario.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-97.png\"><img loading=\"lazy\" decoding=\"async\" width=\"647\" height=\"307\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-97.png\" alt=\"\uc591\uc2dd \ucee8\ud2b8\ub864\uacfc ActiveX \ucee8\ud2b8\ub864\" class=\"wp-image-11395\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-97.png 647w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-97-300x142.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-97-18x9.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-97-24x11.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-97-36x17.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-97-48x23.png 48w\" sizes=\"auto, (max-width: 647px) 100vw, 647px\" \/><\/a><figcaption>Controles de formulario y controles ActiveX<\/figcaption><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\" id=\"4.1.2._User_Form\uc744_\uc0ac\uc6a9\ud55c_UI\"><span class=\"ez-toc-section\" id=\"412_User_Form%EC%9D%84_%EC%82%AC%EC%9A%A9%ED%95%9C_UI\"><\/span>4.1.2. Interfaz de usuario con formulario de usuario<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Este es un m\u00e9todo para manejar eventos al crear un objeto UserForm separado y agregarle controles.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-98.png\"><img loading=\"lazy\" decoding=\"async\" width=\"345\" height=\"358\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-98.png\" alt=\"User Form\uc744 \uc0ac\uc6a9\ud55c UI\" class=\"wp-image-11396\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-98.png 345w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-98-289x300.png 289w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-98-12x12.png 12w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-98-24x24.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-98-36x36.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-98-46x48.png 46w\" sizes=\"auto, (max-width: 345px) 100vw, 345px\" \/><\/a><figcaption>Interfaz de usuario con formulario de usuario<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Puede que no sea adecuado para trabajar mientras se ingresan\/modifican datos, como una lista de valores de entrada, ya que puede cubrir la pantalla. Como se muestra en la figura a continuaci\u00f3n, es adecuado para mostrar informaci\u00f3n como ProgressBar.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-99.png\"><img loading=\"lazy\" decoding=\"async\" width=\"439\" height=\"123\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-99.png\" alt=\"Progress Bar UI\" class=\"wp-image-11397\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-99.png 439w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-99-300x84.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-99-18x5.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-99-24x7.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-99-36x10.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-99-48x13.png 48w\" sizes=\"auto, (max-width: 439px) 100vw, 439px\" \/><\/a><figcaption>Interfaz de usuario de la barra de progreso<\/figcaption><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\" id=\"4.1.2._Ribbon_Bar\ub97c_\uc0ac\uc6a9\ud55c_UI\"><span class=\"ez-toc-section\" id=\"412_Ribbon_Bar%EB%A5%BC_%EC%82%AC%EC%9A%A9%ED%95%9C_UI\"><\/span>4.1.2. Interfaz de usuario con barra de cinta<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Este es el m\u00e9todo m\u00e1s laborioso y complicado. Agregue pesta\u00f1as y botones personalizados a la interfaz de la barra de la cinta, que se modific\u00f3 desde Excel 2007, y controle los eventos. Este es un ejemplo de una barra de cinta personalizada que un empleado subalterno hizo y me envi\u00f3 hace unos a\u00f1os.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-100.png\"><img loading=\"lazy\" decoding=\"async\" width=\"392\" height=\"319\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-100.png\" alt=\"Ribbon Bar\ub97c \uc0ac\uc6a9\ud55c UI\" class=\"wp-image-11398\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-100.png 392w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-100-300x244.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-100-15x12.png 15w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-100-24x20.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-100-36x29.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-100-48x39.png 48w\" sizes=\"auto, (max-width: 392px) 100vw, 392px\" \/><\/a><figcaption>Interfaz de usuario usando la barra de la cinta<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Herramienta de verificaci\u00f3n de est\u00e1ndares de datos (* Nota: <a href=\"https:\/\/prodskill.com\/es\/data-standard-checker-toc\/\">Herramienta de verificaci\u00f3n est\u00e1ndar de datos Descripci\u00f3n Contenido, Descargar<\/a>) proporcion\u00f3 la interfaz de usuario en la hoja de Excel, pero si la cambia a la interfaz de usuario de la barra de cinta, ser\u00e1 similar a la anterior.<\/p>\n\n\n\n<p>El contenido de la barra de cinta es bastante extenso por s\u00ed solo, por lo que lo organizar\u00e9 en un art\u00edculo separado m\u00e1s adelante. Vea abajo.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/docs.microsoft.com\/en-us\/archive\/msdn-magazine\/2007\/february\/extend-office-2007-with-your-own-ribbon-tabs-and-controls\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/archive\/msdn-magazine\/2007\/february\/extend-office-2007-with-your-own-ribbon-tabs-and-controls<\/a><\/li><li><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/library-reference\/concepts\/overview-of-the-office-fluent-ribbon\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/office\/vba\/library-reference\/concepts\/overview-of-the-office-fluent-ribbon<\/a><\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"4.2._VBA_\ucf54\ub4dc\ub97c_\uc2e4\ud589\ud558\ub294_\ubc29\ubc95\"><span class=\"ez-toc-section\" id=\"42_VBA_%EC%BD%94%EB%93%9C%EB%A5%BC_%EC%8B%A4%ED%96%89%ED%95%98%EB%8A%94_%EB%B0%A9%EB%B2%95\"><\/span>4.2. C\u00f3mo ejecutar c\u00f3digo VBA<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Hay al menos tres formas de ejecutar c\u00f3digo VBA.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"4.2.1._\ubc84\ud2bc_\ud074\ub9ad_\uc774\ubca4\ud2b8\uc5d0\uc11c_\uc2e4\ud589\"><span class=\"ez-toc-section\" id=\"421_%EB%B2%84%ED%8A%BC_%ED%81%B4%EB%A6%AD_%EC%9D%B4%EB%B2%A4%ED%8A%B8%EC%97%90%EC%84%9C_%EC%8B%A4%ED%96%89\"><\/span>4.2.1. Ejecutar en evento de clic de bot\u00f3n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-101.png\"><img loading=\"lazy\" decoding=\"async\" width=\"762\" height=\"358\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-101.png\" alt=\"\ubc84\ud2bc \ud074\ub9ad \uc774\ubca4\ud2b8\uc5d0\uc11c VBA \ucf54\ub4dc \uc2e4\ud589\" class=\"wp-image-11399\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-101.png 762w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-101-300x141.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-101-18x8.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-101-520x245.png 520w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-101-24x11.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-101-36x17.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-101-48x23.png 48w\" sizes=\"auto, (max-width: 762px) 100vw, 762px\" \/><\/a><figcaption>Ejecute el c\u00f3digo VBA en el evento de clic de bot\u00f3n<\/figcaption><\/figure>\n<\/div>\n\n\n<p>As\u00ed es como se crea un bot\u00f3n como se muestra en la figura anterior y se escribe una instrucci\u00f3n que ejecuta el c\u00f3digo VBA en el evento de clic del bot\u00f3n. Esto es adecuado cuando se proporciona una forma de ejecutarlo en la interfaz de usuario.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"4.2.2._\uc2e4\ud589\ud560_\uc18c\uc2a4\ucf54\ub4dc\uc5d0_\ucee4\uc11c_\uc704\uce58\uc2dc\ud0a4\uace0_\ub2e8\ucd95\ud0a4\ub85c_\uc2e4\ud589\"><span class=\"ez-toc-section\" id=\"422_%EC%8B%A4%ED%96%89%ED%95%A0_%EC%86%8C%EC%8A%A4%EC%BD%94%EB%93%9C%EC%97%90_%EC%BB%A4%EC%84%9C_%EC%9C%84%EC%B9%98%EC%8B%9C%ED%82%A4%EA%B3%A0_%EB%8B%A8%EC%B6%95%ED%82%A4%EB%A1%9C_%EC%8B%A4%ED%96%89\"><\/span>4.2.2. Coloque el cursor sobre el c\u00f3digo fuente a ejecutar y ejec\u00fatelo con una tecla de m\u00e9todo abreviado<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-102.png\"><img loading=\"lazy\" decoding=\"async\" width=\"396\" height=\"323\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-102.png\" alt=\"\ucee4\uc11c \uc704\uce58\uc5d0\uc11c VBA \ucf54\ub4dc \uc2e4\ud589\" class=\"wp-image-11400\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-102.png 396w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-102-300x245.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-102-15x12.png 15w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-102-24x20.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-102-36x29.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-102-48x39.png 48w\" sizes=\"auto, (max-width: 396px) 100vw, 396px\" \/><\/a><figcaption>Ejecute el c\u00f3digo VBA en la posici\u00f3n del cursor<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Coloque el cursor en el c\u00f3digo de procedimiento Sub o Function en VBE (Visual Basic Editor) y presione la tecla de acceso directo.&nbsp;<strong>F5<\/strong>corre con Tambi\u00e9n puede hacer clic en el bot\u00f3n ejecutar (\u25b6\ufe0f) en la barra de herramientas. Este m\u00e9todo solo funciona para procedimientos Sub y Function sin par\u00e1metros.<\/p>\n\n\n\n<p>Este m\u00e9todo es adecuado para pruebas simples cuando no hay necesidad de proporcionar un m\u00e9todo de ejecuci\u00f3n externo.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"423_%EC%A7%81%EC%A0%91_%EC%8B%A4%ED%96%89_%EC%B0%BD%EC%97%90%EC%84%9C_%EC%8B%A4%ED%96%89\"><\/span>4.2.3. Ejecutar en ventana inmediata<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-103.png\"><img loading=\"lazy\" decoding=\"async\" width=\"465\" height=\"380\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-103.png\" alt=\"\uc9c1\uc811 \uc2e4\ud589 \ucc3d\uc5d0\uc11c VBA \ucf54\ub4dc \uc2e4\ud589\" class=\"wp-image-11401\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-103.png 465w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-103-300x245.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-103-15x12.png 15w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-103-24x20.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-103-36x29.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-103-48x39.png 48w\" sizes=\"auto, (max-width: 465px) 100vw, 465px\" \/><\/a><figcaption>Ejecutar c\u00f3digo VBA en la ventana inmediata<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Este m\u00e9todo consiste en ingresar el nombre y el par\u00e1metro de un procedimiento Sub o Function en la ventana de Ejecuci\u00f3n Inmediata y presionar la tecla Enter para ejecutarlo. Este m\u00e9todo es adecuado para pruebas simples de procedimientos Sub y Function con par\u00e1metros.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"4.3._\uc9c1\uc811_\uc2e4\ud589_\ucc3d_\ub3c4\uad6c_\ud65c\uc6a9_\ubc29\ubc95\"><span class=\"ez-toc-section\" id=\"43_%EC%A7%81%EC%A0%91_%EC%8B%A4%ED%96%89_%EC%B0%BD_%EB%8F%84%EA%B5%AC_%ED%99%9C%EC%9A%A9_%EB%B0%A9%EB%B2%95\"><\/span>4.3. C\u00f3mo utilizar la herramienta Ventana inmediata<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>La ventana Ejecuci\u00f3n inmediata se puede utilizar para una variedad de prop\u00f3sitos, como la depuraci\u00f3n y la salida de mensajes, adem\u00e1s de la ejecuci\u00f3n de macros, como se explic\u00f3 anteriormente.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-104.png\"><img loading=\"lazy\" decoding=\"async\" width=\"894\" height=\"524\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-104.png\" alt=\"\uc9c1\uc811 \uc2e4\ud589 \ucc3d \ub3c4\uad6c \ud65c\uc6a9 \ubc29\ubc95\" class=\"wp-image-11402\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-104.png 894w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-104-300x176.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-104-768x450.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-104-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-104-24x14.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-104-36x21.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-104-48x28.png 48w\" sizes=\"auto, (max-width: 894px) 100vw, 894px\" \/><\/a><figcaption>C\u00f3mo utilizar la herramienta Ventana inmediata<\/figcaption><\/figure>\n<\/div>\n\n\n<ol class=\"wp-block-list\"><li>ejecutar macro<ul><li>Ejecutar ingresando el nombre del procedimiento de funci\u00f3n o sub en el m\u00f3dulo<\/li><li>Tambi\u00e9n se pueden ejecutar procedimientos con par\u00e1metros.<\/li><\/ul><\/li><li>Comprobar valores de variables en tiempo de ejecuci\u00f3n<ul><li>Se usa mientras se detiene en un punto de interrupci\u00f3n<\/li><li>Imprimir o ? Despu\u00e9s de ingresar el nombre de la variable, confirme el valor con la tecla Enter.<\/li><\/ul><\/li><li>Comprobar mensaje de salida<ul><li>Verifique la salida con Debug.Print<\/li><\/ul><\/li><\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"4.4._\uac1c\uccb4_\ucc3e\uc544\ubcf4\uae30_\ub3c4\uad6c_\ud65c\uc6a9_\ubc29\ubc95\"><span class=\"ez-toc-section\" id=\"44_%EA%B0%9C%EC%B2%B4_%EC%B0%BE%EC%95%84%EB%B3%B4%EA%B8%B0_%EB%8F%84%EA%B5%AC_%ED%99%9C%EC%9A%A9_%EB%B0%A9%EB%B2%95\"><\/span>4.4. C\u00f3mo utilizar la herramienta Examinar objetos<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Publicaci\u00f3n anterior&nbsp;<a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-3\/\">Curso de Excel VBA (3): Modelo de objetos de Excel<\/a>&nbsp;Ech\u00e9 un vistazo r\u00e1pido a la herramienta de b\u00fasqueda de objetos en .<\/p>\n\n\n\n<p>Ejecute &#039;Examinar objeto&#039; en el men\u00fa &#039;Ver&#039; de VBE. El atajo es&nbsp;<strong>F2<\/strong>&nbsp;ser.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-105.png\"><img loading=\"lazy\" decoding=\"async\" width=\"695\" height=\"431\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-105.png\" alt=\"\uac1c\uccb4 \ucc3e\uc544\ubcf4\uae30 \uba54\ub274\" class=\"wp-image-11403\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-105.png 695w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-105-300x186.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-105-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-105-24x15.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-105-36x22.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-105-48x30.png 48w\" sizes=\"auto, (max-width: 695px) 100vw, 695px\" \/><\/a><figcaption>men\u00fa de b\u00fasqueda de objetos<\/figcaption><\/figure>\n<\/div>\n\n\n<p>La herramienta de exploraci\u00f3n de objetos se compone de lo siguiente.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-106.png\"><img loading=\"lazy\" decoding=\"async\" width=\"765\" height=\"515\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-106.png\" alt=\"\uac1c\uccb4 \ucc3e\uc544\ubcf4\uae30 \ub3c4\uad6c \uad6c\uc131\" class=\"wp-image-11404\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-106.png 765w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-106-300x202.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-106-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-106-24x16.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-106-36x24.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-106-48x32.png 48w\" sizes=\"auto, (max-width: 765px) 100vw, 765px\" \/><\/a><figcaption>Configuraci\u00f3n de la herramienta de b\u00fasqueda de objetos<\/figcaption><\/figure>\n<\/div>\n\n\n<ol class=\"wp-block-list\"><li>Filtrar y buscar<ul><li>Puede consultar la lista de todas las bibliotecas que se proporcionan de forma predeterminada en Excel y las bibliotecas que se han agregado como referencias, y seleccionar una biblioteca espec\u00edfica.<\/li><li>La lista completa de la biblioteca se puede buscar por nombre de clase o nombre de miembro.<\/li><\/ul><\/li><li>Lista de clase<ul><li>Muestra una lista de todas las clases, m\u00f3dulos y enumeraciones de la biblioteca seleccionada.<\/li><\/ul><\/li><li>Lista de miembros<ul><li>Muestra la lista de procedimientos, funciones, propiedades, etc. que son miembros de la clase o m\u00f3dulo seleccionado en la lista de clases.<\/li><\/ul><\/li><li>Informaci\u00f3n de miembro<ul><li>Muestra los detalles del procedimiento, funci\u00f3n, propiedad, etc. seleccionados de la lista de miembros.<\/li><\/ul><\/li><\/ol>\n\n\n\n<p>Los tipos de iconos que se muestran en la herramienta de b\u00fasqueda de objetos y sus significados son los siguientes.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-107.png\"><img loading=\"lazy\" decoding=\"async\" width=\"502\" height=\"672\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-107.png\" alt=\"\uac1c\uccb4 \ucc3e\uc544\ubcf4\uae30 \ub3c4\uad6c\uc5d0\uc11c \ud45c\uc2dc\ub418\ub294 \uc544\uc774\ucf58\uc758 \uc885\ub958\uc640 \uc758\ubbf8\" class=\"wp-image-11405\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-107.png 502w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-107-224x300.png 224w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-107-9x12.png 9w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-107-18x24.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-107-27x36.png 27w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-107-36x48.png 36w\" sizes=\"auto, (max-width: 502px) 100vw, 502px\" \/><\/a><figcaption>Tipos y significados de los iconos que se muestran en la herramienta de b\u00fasqueda de objetos<\/figcaption><\/figure>\n<\/div>\n\n\n<p>(fuente:&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/icons-used-in-the-object-browser-and-code-windows\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/icons-used-in-the-object-browser-and-code-windows<\/a>)<\/p>\n\n\n\n<p>Para obtener m\u00e1s informaci\u00f3n sobre la herramienta de exploraci\u00f3n de objetos, consulte la siguiente URL.<\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/object-browser\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/office\/vba\/language\/reference\/user-interface-help\/object-browser<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"4.5._VBA_\uc131\ub2a5_\ud5a5\uc0c1_\ubc29\ubc95\"><span class=\"ez-toc-section\" id=\"45_VBA_%EC%84%B1%EB%8A%A5_%ED%96%A5%EC%83%81_%EB%B0%A9%EB%B2%95\"><\/span>4.5. C\u00f3mo mejorar el rendimiento de VBA<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>C\u00f3mo mejorar el rendimiento de VBA est\u00e1 escrito en un art\u00edculo separado.<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/es\/excel-vba-coding-pattern-performance-improvement\/\">Patrones de codificaci\u00f3n de VBA: mejora del rendimiento de VBA<\/a><\/p>\n\n\n\n<p>Para resumir el art\u00edculo anterior, establezca la variable global en un valor de mejora del rendimiento antes de ingresar el c\u00f3digo que se procesar\u00e1 y c\u00e1mbielo al valor original una vez que finalice el procesamiento del c\u00f3digo. Consulte el siguiente c\u00f3digo.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">'\ucf54\ub4dc \uc9c4\uc785 \ubd80\ubd84\nApplication.ScreenUpdating = False\nApplication.Calculation = xlCalculationManual\nApplication.EnableEvents = False\nApplication.DisplayAlerts = False\n\u00a0\n'\uc2e4\ud589\ud560 \ucf54\ub4dc\uac00 \ub4e4\uc5b4 \uac08 \ubd80\ubd84\n...\n\u00a0\n'\ucf54\ub4dc \uc885\ub8cc \ubd80\ubd84\nApplication.ScreenUpdating = True\nApplication.Calculation = xlCalculationAutomatic\nApplication.EnableEvents = True\nApplication.DisplayAlerts = True<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"4.6._\ub9e4\ud06c\ub85c_\uae30\ub85d\uae30_\ud65c\uc6a9_\ubc29\ubc95\"><span class=\"ez-toc-section\" id=\"46_%EB%A7%A4%ED%81%AC%EB%A1%9C_%EA%B8%B0%EB%A1%9D%EA%B8%B0_%ED%99%9C%EC%9A%A9_%EB%B0%A9%EB%B2%95\"><\/span>4.6. C\u00f3mo usar la grabadora de macros<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>La grabadora de macros de Excel es muy \u00fatil. Por ejemplo, si est\u00e1 creando una nueva tabla din\u00e1mica, un nuevo gr\u00e1fico o no sabe c\u00f3mo escribir tareas repetitivas en c\u00f3digo VBA, la grabadora de macros puede ser de gran ayuda.<\/p>\n\n\n\n<p>Si inicia la grabadora de macros, procesa una tarea con el teclado o el mouse y luego detiene la grabadora de macros, puede ver que los detalles del trabajo procesado hasta el momento est\u00e1n escritos en c\u00f3digo VBA. Es posible codificar mucho m\u00e1s r\u00e1pido y con mayor precisi\u00f3n modificando y usando el c\u00f3digo creado de esta manera que escribiendo c\u00f3digo VBA desde cero.<\/p>\n\n\n\n<p>La grabaci\u00f3n de macros comienza haciendo clic en el bot\u00f3n &#039;Grabar macro&#039; en la pesta\u00f1a Desarrollador o en la barra de estado inferior de la siguiente manera.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-108.png\"><img loading=\"lazy\" decoding=\"async\" width=\"708\" height=\"241\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-108.png\" alt=\"\ub9e4\ud06c\ub85c \uae30\ub85d \uc2dc\uc791 \ubc84\ud2bc\" class=\"wp-image-11406\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-108.png 708w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-108-300x102.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-108-18x6.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-108-24x8.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-108-36x12.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-108-48x16.png 48w\" sizes=\"auto, (max-width: 708px) 100vw, 708px\" \/><\/a><figcaption>Bot\u00f3n Iniciar grabaci\u00f3n de macros<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Si hace clic en el bot\u00f3n &#039;Grabar macro&#039;, aparecer\u00e1 una ventana para ingresar el nombre de la macro, la tecla de m\u00e9todo abreviado, la ubicaci\u00f3n para guardar y la descripci\u00f3n de la siguiente manera.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-109.png\"><img loading=\"lazy\" decoding=\"async\" width=\"350\" height=\"327\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-109.png\" alt=\"\ub9e4\ud06c\ub85c \uc774\ub984, \ubc14\ub85c \uac00\uae30 \ud0a4, \uc800\uc7a5 \uc704\uce58 \uc124\uc815\" class=\"wp-image-11407\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-109.png 350w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-109-300x280.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-109-13x12.png 13w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-109-24x22.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-109-36x34.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-109-48x45.png 48w\" sizes=\"auto, (max-width: 350px) 100vw, 350px\" \/><\/a><figcaption>Establecer nombre de macro, tecla de acceso directo, ubicaci\u00f3n de almacenamiento<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Si hace clic en el bot\u00f3n &#039;Aceptar&#039; despu\u00e9s de ingresar la informaci\u00f3n de la macro, el estado de grabaci\u00f3n cambia de la siguiente manera.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-110.png\"><img loading=\"lazy\" decoding=\"async\" width=\"713\" height=\"241\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-110.png\" alt=\"\ub9e4\ud06c\ub85c \uae30\ub85d \uc911\" class=\"wp-image-11408\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-110.png 713w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-110-300x101.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-110-18x6.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-110-24x8.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-110-36x12.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-110-48x16.png 48w\" sizes=\"auto, (max-width: 713px) 100vw, 713px\" \/><\/a><figcaption>grabaci\u00f3n de macros<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Grabemos la designaci\u00f3n del borde de los datos pegados, la configuraci\u00f3n del encabezado (color de fondo, fuente, alineaci\u00f3n central), la ocultaci\u00f3n de la l\u00ednea de cuadr\u00edcula y las funciones de cuadro congelado con la grabadora de macros. Si inicia la grabaci\u00f3n de macros y ejecuta la funci\u00f3n usando el teclado o el mouse, el resultado es como se muestra en el lado derecho de la figura a continuaci\u00f3n.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-111.png\"><img loading=\"lazy\" decoding=\"async\" width=\"734\" height=\"443\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-111.png\" alt=\"\ub9e4\ud06c\ub85c \uae30\ub85d \uc608\uc2dc\" class=\"wp-image-11409\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-111.png 734w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-111-300x181.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-111-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-111-24x14.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-111-36x22.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-111-48x29.png 48w\" sizes=\"auto, (max-width: 734px) 100vw, 734px\" \/><\/a><figcaption>Ejemplo de registro de macros<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Detenga la grabaci\u00f3n de macros y verifique el c\u00f3digo VBA generado de la siguiente manera.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">Sub \ub9e4\ud06c\ub85c1()\n'\n' \ub9e4\ud06c\ub85c1 \ub9e4\ud06c\ub85c\n'\n    Columns(\"A:B\").Select\n    Columns(\"A:B\").EntireColumn.AutoFit\n    Range(\"A1:B11\").Select\n    Selection.Borders(xlDiagonalDown).LineStyle = xlNone\n    Selection.Borders(xlDiagonalUp).LineStyle = xlNone\n    With Selection.Borders(xlEdgeLeft)\n        .LineStyle = xlContinuous\n        .ColorIndex = xlAutomatic\n        .TintAndShade = 0\n        .Weight = xlThin\n    End With\n    With Selection.Borders(xlEdgeTop)\n        .LineStyle = xlContinuous\n        .ColorIndex = xlAutomatic\n        .TintAndShade = 0\n        .Weight = xlThin\n    End With\n    With Selection.Borders(xlEdgeBottom)\n        .LineStyle = xlContinuous\n        .ColorIndex = xlAutomatic\n        .TintAndShade = 0\n        .Weight = xlThin\n    End With\n    With Selection.Borders(xlEdgeRight)\n        .LineStyle = xlContinuous\n        .ColorIndex = xlAutomatic\n        .TintAndShade = 0\n        .Weight = xlThin\n    End With\n    With Selection.Borders(xlInsideVertical)\n        .LineStyle = xlContinuous\n        .ColorIndex = xlAutomatic\n        .TintAndShade = 0\n        .Weight = xlThin\n    End With\n    With Selection.Borders(xlInsideHorizontal)\n        .LineStyle = xlContinuous\n        .ColorIndex = xlAutomatic\n        .TintAndShade = 0\n        .Weight = xlThin\n    End With\n    Range(\"A1:B1\").Select\n    Selection.Font.Bold = True\n    With Selection\n        .HorizontalAlignment = xlCenter\n        .VerticalAlignment = xlCenter\n        .WrapText = False\n        .Orientation = 0\n        .AddIndent = False\n        .IndentLevel = 0\n        .ShrinkToFit = False\n        .ReadingOrder = xlContext\n        .MergeCells = False\n    End With\n    With Selection.Interior\n        .Pattern = xlSolid\n        .PatternColorIndex = xlAutomatic\n        .Color = 65535\n        .TintAndShade = 0\n        .PatternTintAndShade = 0\n    End With\n\n    Range(\"A2\").Select\n    ActiveWindow.FreezePanes = True\n\n    ActiveWindow.DisplayGridlines = False\nEnd Sub<\/pre>\n\n\n\n<p>Analizando este c\u00f3digo:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-112.png\"><img loading=\"lazy\" decoding=\"async\" width=\"979\" height=\"517\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-112.png\" alt=\"\ub9e4\ud06c\ub85c \uae30\ub85d\uae30\ub85c \uc0dd\uc131\ub41c \ucf54\ub4dc \ubd84\uc11d\" class=\"wp-image-11410\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-112.png 979w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-112-300x158.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-112-768x406.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-112-18x10.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-112-24x13.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-112-36x19.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-112-48x25.png 48w\" sizes=\"auto, (max-width: 979px) 100vw, 979px\" \/><\/a><figcaption>An\u00e1lisis de c\u00f3digo generado por la grabadora de macros<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Incluso si no est\u00e1 familiarizado con el modelo de objetos de Excel o la sintaxis de VBA, puede crear macros \u00fatiles utilizando el c\u00f3digo VBA creado de esta manera. Si usa bien la grabadora de macros, la codificaci\u00f3n VBA se vuelve f\u00e1cil.<\/p>\n\n\n\n<p>Como referencia, Excel es la \u00fanica grabadora de macros entre las suites de Ms-Office.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"4.7._\ucf54\ub529\uc2dc_\uc9c0\ud0a4\uba74_\uc88b\uc744_\uae30\ubcf8_\uc6d0\uce59\"><span class=\"ez-toc-section\" id=\"47_%EC%BD%94%EB%94%A9%EC%8B%9C_%EC%A7%80%ED%82%A4%EB%A9%B4_%EC%A2%8B%EC%9D%84_%EA%B8%B0%EB%B3%B8_%EC%9B%90%EC%B9%99\"><\/span>4.7. Principios b\u00e1sicos a seguir al programar<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Se recomienda mantener los siguientes principios b\u00e1sicos al codificar usando Excel VBA.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>No coloque el valor cambiado dentro, pero reciba la entrada desde el exterior (IU).<\/li><li>No lo estructure como un M\u00f3dulo\/Clase desde el principio, enf\u00f3quese solo en el prop\u00f3sito de la implementaci\u00f3n al principio.<ul><li>La estructuraci\u00f3n toma tiempo adicional, lo que no deber\u00eda afectar el cronograma de trabajo original.<\/li><li>VBA es un medio (herramienta), no un fin. Tenga cuidado de no dar la vuelta.<\/li><\/ul><\/li><li>Si se usa m\u00e1s de 3 veces o si est\u00e1 claro que se usar\u00e1 continuamente en el futuro, refactor\u00edcelo y estruct\u00farelo en M\u00f3dulo\/Clase considerando la reutilizaci\u00f3n. (Hacer -&gt; Copiar -&gt; Refactorizaci\u00f3n)<\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>En este art\u00edculo, analizamos los procedimientos que es bueno saber al codificar Excel VBA. A continuaci\u00f3n, veremos ejemplos de herramientas desarrolladas y utilizadas con Excel VBA. Esta ser\u00e1 la \u00faltima publicaci\u00f3n de la conferencia Excel VBA.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>&lt;&lt; Lista de art\u00edculos relacionados &gt;&gt;<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-preface\/\">Inicie el curso de Excel VBA. (Aviso de conferencia, haza\u00f1a. Por qu\u00e9 recomendamos Excel VBA)<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-1-overview\/\">Curso Excel VBA(1): Descripci\u00f3n general de Excel VBA<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-2-basic\/\">Curso de Excel VBA (2): Conceptos b\u00e1sicos de Excel VBA<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-3-object-model\/\">Curso de Excel VBA (3): Modelo de objetos de Excel<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-4-handling-object-model\/\">Curso de Excel VBA (4): Trabajar con el modelo de objetos de Excel<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-5-excel-file-extension-vbe-font\/\">Curso de Excel VBA (5): extensi\u00f3n de archivo de Excel, VBE, configuraci\u00f3n de fuente<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-6-variable\/\">Curso Excel VBA (6): Conceptos b\u00e1sicos del lenguaje Excel VBA - Variables<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-7-syntax\/\">Curso Excel VBA (7): Conceptos b\u00e1sicos del lenguaje Excel VBA - Sintaxis<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-8-datatype\/\">Curso Excel VBA (8): Conceptos b\u00e1sicos del lenguaje Excel VBA: tipos de datos, estructuras de datos<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-9-how-to\/\">Cursos de Excel VBA (9): Procedimientos de Excel VBA<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-10-self-developed-tools\/\">Curso Excel VBA (10): Herramientas desarrolladas y utilizadas con Excel VBA<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-toc\/\">Tabla de contenido completa para cursos de Excel VBA<\/a><\/li><\/ul>","protected":false},"excerpt":{"rendered":"<p>Este art\u00edculo examina el procedimiento de Excel VBA. Cons\u00faltelo cuando codifique Excel VBA. Esta es una continuaci\u00f3n del art\u00edculo anterior. Clase de Excel VBA (8): lenguaje b\u00e1sico de Excel VBA: tipo de datos, estructura de datos 4. Procedimientos de Excel VBA 4.1. C\u00f3mo configurar UI (interfaz de usuario) Recibir valores de entrada del usuario en Excel VBA o...<\/p>","protected":false},"author":1,"featured_media":11398,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28],"tags":[17],"class_list":["post-11393","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-vba-tutorial","tag-vba"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\uc5d1\uc140 VBA \uac15\uc88c(9): \uc5d1\uc140 VBA How-To - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"\uc774\ubc88 \uae00\uc740 \uc5d1\uc140 VBA How-To\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. UI \uad6c\uc131 \ubc29\ubc95, VBA \ucf54\ub4dc\ub97c \uc2e4\ud589\ud558\ub294 \ubc29\ubc95, \uc9c1\uc811 \uc2e4\ud589\ucc3d \ub3c4\uad6c\uc640 \uac1c\uccb4 \ucc3e\uc544\ubcf4\uae30 \ub3c4\uad6c \ud65c\uc6a9 \ubc29\ubc95, VBA \uc131\ub2a5 \ud5a5\uc0c1 \ubc29\ubc95, \ub9e4\ud06c\ub85c \uae30\ub85d\uae30 \ud65c\uc6a9 \ubc29\ubc95, \ucf54\ub529\uc2dc \uc9c0\ud0a4\uba74 \uc88b\uc744 \uae30\ubcf8 \uc6d0\uce59\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-9-how-to\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\uc5d1\uc140 VBA \uac15\uc88c(9): \uc5d1\uc140 VBA How-To - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"\uc774\ubc88 \uae00\uc740 \uc5d1\uc140 VBA How-To\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. UI \uad6c\uc131 \ubc29\ubc95, VBA \ucf54\ub4dc\ub97c \uc2e4\ud589\ud558\ub294 \ubc29\ubc95, \uc9c1\uc811 \uc2e4\ud589\ucc3d \ub3c4\uad6c\uc640 \uac1c\uccb4 \ucc3e\uc544\ubcf4\uae30 \ub3c4\uad6c \ud65c\uc6a9 \ubc29\ubc95, VBA \uc131\ub2a5 \ud5a5\uc0c1 \ubc29\ubc95, \ub9e4\ud06c\ub85c \uae30\ub85d\uae30 \ud65c\uc6a9 \ubc29\ubc95, \ucf54\ub529\uc2dc \uc9c0\ud0a4\uba74 \uc88b\uc744 \uae30\ubcf8 \uc6d0\uce59\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/es\/excel-vba-lecture-9-how-to\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-11T10:52:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-11T02:42:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-100.png\" \/>\n\t<meta property=\"og:image:width\" content=\"392\" \/>\n\t<meta property=\"og:image:height\" content=\"319\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Zerom\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"\uc5d1\uc140 VBA \uac15\uc88c(9): \uc5d1\uc140 VBA How-To\",\"datePublished\":\"2022-09-11T10:52:01+00:00\",\"dateModified\":\"2022-10-11T02:42:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/\"},\"wordCount\":244,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-100.png\",\"keywords\":[\"\uc5d1\uc140VBA\"],\"articleSection\":[\"\uc5d1\uc140 VBA \uac15\uc88c\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/\",\"url\":\"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/\",\"name\":\"\uc5d1\uc140 VBA \uac15\uc88c(9): \uc5d1\uc140 VBA How-To - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-100.png\",\"datePublished\":\"2022-09-11T10:52:01+00:00\",\"dateModified\":\"2022-10-11T02:42:51+00:00\",\"description\":\"\uc774\ubc88 \uae00\uc740 \uc5d1\uc140 VBA How-To\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. UI \uad6c\uc131 \ubc29\ubc95, VBA \ucf54\ub4dc\ub97c \uc2e4\ud589\ud558\ub294 \ubc29\ubc95, \uc9c1\uc811 \uc2e4\ud589\ucc3d \ub3c4\uad6c\uc640 \uac1c\uccb4 \ucc3e\uc544\ubcf4\uae30 \ub3c4\uad6c \ud65c\uc6a9 \ubc29\ubc95, VBA \uc131\ub2a5 \ud5a5\uc0c1 \ubc29\ubc95, \ub9e4\ud06c\ub85c \uae30\ub85d\uae30 \ud65c\uc6a9 \ubc29\ubc95, \ucf54\ub529\uc2dc \uc9c0\ud0a4\uba74 \uc88b\uc744 \uae30\ubcf8 \uc6d0\uce59\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/#primaryimage\",\"url\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-100.png\",\"contentUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-100.png\",\"width\":392,\"height\":319},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/prodskill.com\/ko\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\uc5d1\uc140 VBA \uac15\uc88c(9): \uc5d1\uc140 VBA How-To\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/prodskill.com\/ko\/#website\",\"url\":\"https:\/\/prodskill.com\/ko\/\",\"name\":\"\uc0dd\uc0b0\uc131 Skill\",\"description\":\"Meta Thinking, Meta Working\",\"publisher\":{\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/prodskill.com\/ko\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png\",\"url\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png\",\"contentUrl\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png\",\"width\":512,\"height\":512,\"caption\":\"Zerom\"},\"logo\":{\"@id\":\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png\"},\"url\":\"https:\/\/prodskill.com\/es\/author\/proda\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Tutorial de VBA en Excel (9): C\u00f3mo usar VBA en Excel - Habilidades de productividad","description":"Este art\u00edculo explora los tutoriales de VBA en Excel. Aprender\u00e1 a configurar la interfaz de usuario, ejecutar c\u00f3digo VBA, utilizar las herramientas Ventana inmediata y Explorador de objetos, mejorar el rendimiento de VBA, usar la grabadora de macros y aprender los principios b\u00e1sicos de la programaci\u00f3n.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/prodskill.com\/es\/excel-vba-lecture-9-how-to\/","og_locale":"es_ES","og_type":"article","og_title":"\uc5d1\uc140 VBA \uac15\uc88c(9): \uc5d1\uc140 VBA How-To - \uc0dd\uc0b0\uc131 Skill","og_description":"\uc774\ubc88 \uae00\uc740 \uc5d1\uc140 VBA How-To\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. UI \uad6c\uc131 \ubc29\ubc95, VBA \ucf54\ub4dc\ub97c \uc2e4\ud589\ud558\ub294 \ubc29\ubc95, \uc9c1\uc811 \uc2e4\ud589\ucc3d \ub3c4\uad6c\uc640 \uac1c\uccb4 \ucc3e\uc544\ubcf4\uae30 \ub3c4\uad6c \ud65c\uc6a9 \ubc29\ubc95, VBA \uc131\ub2a5 \ud5a5\uc0c1 \ubc29\ubc95, \ub9e4\ud06c\ub85c \uae30\ub85d\uae30 \ud65c\uc6a9 \ubc29\ubc95, \ucf54\ub529\uc2dc \uc9c0\ud0a4\uba74 \uc88b\uc744 \uae30\ubcf8 \uc6d0\uce59\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.","og_url":"https:\/\/prodskill.com\/es\/excel-vba-lecture-9-how-to\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-09-11T10:52:01+00:00","article_modified_time":"2022-10-11T02:42:51+00:00","og_image":[{"width":392,"height":319,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-100.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Zerom","Tiempo de lectura":"11 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"\uc5d1\uc140 VBA \uac15\uc88c(9): \uc5d1\uc140 VBA How-To","datePublished":"2022-09-11T10:52:01+00:00","dateModified":"2022-10-11T02:42:51+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/"},"wordCount":244,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-100.png","keywords":["\uc5d1\uc140VBA"],"articleSection":["\uc5d1\uc140 VBA \uac15\uc88c"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/","url":"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/","name":"Tutorial de VBA en Excel (9): C\u00f3mo usar VBA en Excel - Habilidades de productividad","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-100.png","datePublished":"2022-09-11T10:52:01+00:00","dateModified":"2022-10-11T02:42:51+00:00","description":"Este art\u00edculo explora los tutoriales de VBA en Excel. Aprender\u00e1 a configurar la interfaz de usuario, ejecutar c\u00f3digo VBA, utilizar las herramientas Ventana inmediata y Explorador de objetos, mejorar el rendimiento de VBA, usar la grabadora de macros y aprender los principios b\u00e1sicos de la programaci\u00f3n.","breadcrumb":{"@id":"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-100.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/image-100.png","width":392,"height":319},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/excel-vba-lecture-9-how-to\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"\uc5d1\uc140 VBA \uac15\uc88c(9): \uc5d1\uc140 VBA How-To"}]},{"@type":"WebSite","@id":"https:\/\/prodskill.com\/ko\/#website","url":"https:\/\/prodskill.com\/ko\/","name":"Habilidades de productividad","description":"Meta Pensamiento, Meta Trabajo","publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/prodskill.com\/ko\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"Cerom","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","width":512,"height":512,"caption":"Zerom"},"logo":{"@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png"},"url":"https:\/\/prodskill.com\/es\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/posts\/11393","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/comments?post=11393"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/posts\/11393\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/media\/11398"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/media?parent=11393"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/categories?post=11393"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/es\/wp-json\/wp\/v2\/tags?post=11393"}],"curies":[{"name":"gracias","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}