{"id":5526,"date":"2014-01-17T06:51:25","date_gmt":"2014-01-17T12:51:25","guid":{"rendered":"http:\/\/aplicaexcelcontable.com\/blog\/?p=5526"},"modified":"2024-12-18T09:08:28","modified_gmt":"2024-12-18T15:08:28","slug":"llamar-un-formulario-desde-excel","status":"publish","type":"post","link":"https:\/\/aplicaexcelcontable.com\/blog\/llamar-un-formulario-desde-excel.html","title":{"rendered":"Llamar un Formulario desde excel"},"content":{"rendered":"<h1 style=\"text-align: center;\">Como llamar un Formulario desde Excel<\/h1>\n<p style=\"text-align: justify;\">Comencemos con el articulo del&nbsp;<strong>Curso Basico de VBA- Como llamar un Formulario desde Excel:<\/strong><\/p>\n<p style=\"text-align: justify;\">En el tema anterior concluimos con el dise\u00f1o de un Formulario en VBA (Visual Basic para Aplicaciones) y hoy vamos a llamar a este Formulario desde Excel.<\/p>\n<p style=\"text-align: justify;\">Pero antes, tengo una pregunta para ti: Ya viste el tema anterior? Si todav\u00eda no lo has visto tan solo&nbsp;<span style=\"color: rgb(0, 23, 255);\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/programar-en-excel-creando-un-userform-paso-a-paso-4.html\" style=\"outline: none;\" target=\"_blank\"><strong>visita este enlace para ver<\/strong><\/a><\/span>.<\/p>\n<p style=\"text-align: justify;\">Una vez termines de leer y aplicar los pasos, regresa nuevamente aqu\u00ed y continua con el tema de hoy.<\/p>\n<p style=\"text-align: justify;\">A continuaci\u00f3n vamos a ver los pasos para llamar un Formulario desde excel creado en VBA. Sigue los siguiente pasos:<\/p>\n<h2 style=\"text-align: center;\">Formulario desde excel &#8211;&nbsp; Asignar un Bot\u00f3n para Ejecutar el UserForm<\/h2>\n<p style=\"text-align: justify;\">Podemos agregar un bot\u00f3n para que un usuario pueda ejecutar el UserForm desde la Hoja Excel.<\/p>\n<ul>\n<li><span>1<\/span><span>Activamos Excel, Libro Datos.xls, Hoja 1<\/span><\/li>\n<li><span>2<\/span><span>Nos ubicamos en la <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/habilitar-la-pestana-programador.html\" target=\"_blank\" style=\"outline: none;\">pesta\u00f1a \u00abDesarrollador o Programador<\/a>\u00bb = &gt; secci\u00f3n \u00abControles\u00bb = &gt; Desde el comando \u00abInsertar\u00bb, seleccionamos con un clic el bot\u00f3n de \u00abControl de Formulario\u00bb y lo dibujamos dentro de la Hoja.<\/span><\/li>\n<\/ul>\n<p><span style=\"width: 100%;\"><img decoding=\"async\" loading=\"lazy\" alt=\"Formulario desde Excel\" width=\"628\" height=\"274\" title=\"Control de Formularios\" data-id=\"42008\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2019\/03\/Control-de-Formularios.png\" style=\"aspect-ratio: auto 628 \/ 274;\" data-width=\"628\" data-height=\"274\" data-init-width=\"628\" data-init-height=\"274\"><\/span><\/p>\n<ul>\n<li><span>3<\/span><span>Una vez dibujado el control, al soltar el mouse se presenta una nueva ventana. Hacemos clic en el bot\u00f3n \u00abNuevo\u00bb.<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: center;\">Ejemplo de Formulario desde excel<\/h3>\n<p><span><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2018\/03\/Asignar-Macro-a-Boton.png\" rel=\"\"><img decoding=\"async\" loading=\"lazy\" alt=\"Formulario desde Excel\" width=\"404\" height=\"412\" title=\"Bot\u00f3n Nuevo\" data-id=\"35517\" src=\"\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2018\/03\/Asignar-Macro-a-Boton.png\"><\/a><\/span><\/p>\n<ul>\n<li><span>5<\/span><span>Donde titila el cursor escribimos: DatosUF.Show cada vez que hagamos clic en la figura se ejecutar\u00e1 el UserForm.<\/span><\/li>\n<li><span>6<\/span><span>Vamos a cambiar el nombre del bot\u00f3n, para modificarlo vamos a ubicarnos encima del bot\u00f3n y pulsamos clic derecho del mouse, se despliega varias opciones y seleccionamos con un clic \u00abModificar Texto\u00bb. Borramos el texto y escribimos \u00abFormulario Datos\u00bb.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Ahora vamos a probar que tal funciona el bot\u00f3n, para eso he grabado un v\u00eddeo bien cortico de 26 segundo que te mostrara como quedo el bot\u00f3n y su funcionalidad:<\/p>\n<p style=\"text-align: justify;\">Muy bien, con esto hemos terminado con el tema de formularios, para el tema siguiente vamos a ver <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/programar-en-excel-ejecutar-macro-desde-otra-macro.html\" target=\"_blank\" style=\"outline: none;\"><strong>Como Ejecutar una Macro desde otra Macro<\/strong><\/a>.<\/p>\n<p style=\"text-align: justify;\">Y si te ha gustado el tema de hoy, te invito a que lo compartas con tus amigos de Facebook pulsando clic en el bot\u00f3n compartir:<\/p>\n<p style=\"text-align: justify;\">Para finalizar, me gustar\u00eda saber que piensas de este articulo \u00abProgramar en Excel &#8211; Llamar un Formulario desde Excel\u00bb.<\/p>\n<p style=\"text-align: justify;\">Por lo tanto:<\/p>\n<p style=\"text-align: justify;\">D\u00e9jame tu comentario con dudas, cr\u00edticas constructivas y sugerencia en la secci\u00f3n de comentarios o bien en el Chat. Al mismo tiempo te invito a que visites nuestra pagina de Facebook, <span style=\"color: rgb(0, 23, 255);\"><a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\" style=\"outline: none;\" rel=\"noopener\"><strong>pulsando clic aqu\u00ed<\/strong><\/a><\/span>.<\/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>Como llamar un Formulario desde Excel Comencemos con el articulo del&nbsp;Curso Basico de VBA- Como llamar un Formulario desde Excel: En el tema anterior concluimos con el dise\u00f1o de un Formulario en VBA (Visual Basic para Aplicaciones) y hoy vamos a llamar a este Formulario desde Excel. Pero antes, tengo una pregunta para ti: Ya [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":42008,"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\"><h1 data-css=\"tve-u-1621fcea338\" style=\"text-align: center;\" class=\"\">Como llamar un Formulario desde Excel<\/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-1621fcf347a\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-1621fcf347c\" style=\"text-align: justify;\">Comencemos con el articulo del&nbsp;<strong>Curso Basico de VBA- Como llamar un Formulario desde Excel:<\/strong><\/p><p data-css=\"tve-u-1621fcf347c\" style=\"text-align: justify;\">En el tema anterior concluimos con el dise\u00f1o de un Formulario en VBA (Visual Basic para Aplicaciones) y hoy vamos a llamar a este Formulario desde Excel.<\/p><p data-css=\"tve-u-1621fcf347c\" style=\"text-align: justify;\">Pero antes, tengo una pregunta para ti: Ya viste el tema anterior? Si todav\u00eda no lo has visto tan solo&nbsp;<span data-css=\"tve-u-1622003d731\" style=\"color: rgb(0, 23, 255);\"><a class=\"\" href=\"https:\/\/aplicaexcelcontable.com\/blog\/programar-en-excel-creando-un-userform-paso-a-paso-4.html\" style=\"outline: none;\" target=\"_blank\"><strong>visita este enlace para ver<\/strong><\/a><\/span>.<\/p><p data-css=\"tve-u-1621fcf347c\" style=\"text-align: justify;\">Una vez termines de leer y aplicar los pasos, regresa nuevamente aqu\u00ed y continua con el tema de hoy.<\/p><p data-css=\"tve-u-1621fcf347c\" style=\"text-align: justify;\">A continuaci\u00f3n vamos a ver los pasos para llamar un Formulario desde excel creado en VBA. Sigue los siguiente pasos:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" data-tag=\"h2\"><h2 class=\"\" data-css=\"tve-u-1621fd1182f\" style=\"text-align: center;\">Formulario desde excel -&nbsp; Asignar un Bot\u00f3n para Ejecutar el UserForm<\/h2><\/div><div class=\"thrv_responsive_video thrv_wrapper tcb-lazy-load tcb-lazy-load-youtube\" data-type=\"youtube\" data-rel=\"0\" data-modestbranding=\"1\" data-aspect-ratio=\"16:9\" data-aspect-ratio-default=\"0\" data-float-position=\"top-left\" data-float-width-d=\"300px\" data-float-padding1-d=\"25px\" data-float-padding2-d=\"25px\" data-float-visibility=\"mobile\" data-url=\"https:\/\/youtu.be\/sfdXzOIBmho\" data-css=\"tve-u-18767911020\" style=\"\">\n\t\n\n\t<div class=\"tve_responsive_video_container\" style=\"padding-bottom: 56.25%;\">\n\t\t<div class=\"video_overlay\"><\/div>\n\t<iframe title=\"Responsive Video\" class=\"tcb-responsive-video\" data-code=\"sfdXzOIBmho\" data-hash=\"undefined\" data-provider=\"youtube\" frameborder=\"0\" allowfullscreen=\"\" loading=\"lazy\" data-src=\"https:\/\/www.youtube.com\/embed\/sfdXzOIBmho?rel=0&amp;modestbranding=1&amp;controls=1&amp;showinfo=1&amp;fs=1&amp;wmode=transparent&amp;enablejsapi=1\"><\/iframe><\/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-1621fd216e8\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-1621fd216e9\" style=\"text-align: justify;\">Podemos agregar un bot\u00f3n para que un usuario pueda ejecutar el UserForm desde la Hoja Excel.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv-numbered_list\" data-start-number=\"1\" data-number-increment=\"1\" data-css=\"tve-u-1621fd28d17\" data-color=\"rgb(10, 0, 0)\" style=\"\"><ul class=\"tcb-numbered-list\"><li class=\"thrv-styled-list-item\"><div class=\"tcb-numbered-list-number thrv-disabled-label thrv_wrapper tcb-no-delete tcb-no-clone tve_no_drag\" data-css=\"tve-u-193da507dea\" style=\"\"><span class=\"tcb-numbered-list-index\">1<\/span><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-numbered-list-text tcb-no-delete\" data-css=\"tve-u-169bb121466\"><div style=\"text-align: justify;\">Activamos Excel, Libro Datos.xls, Hoja 1<\/div><\/span><\/li><li class=\"thrv-styled-list-item\"><div class=\"tcb-numbered-list-number thrv-disabled-label thrv_wrapper tcb-no-delete tcb-no-clone tve_no_drag\" data-css=\"tve-u-193da507dea\" style=\"\"><span class=\"tcb-numbered-list-index\">2<\/span><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-numbered-list-text tcb-no-delete\" data-css=\"tve-u-169bb121466\"><div style=\"text-align: justify;\">Nos ubicamos en la <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/habilitar-la-pestana-programador.html\" target=\"_blank\" class=\"\" style=\"outline: none;\">pesta\u00f1a \"Desarrollador o Programador<\/a>\" = &gt; secci\u00f3n \"Controles\" = &gt; Desde el comando \"Insertar\", seleccionamos con un clic el bot\u00f3n de \"Control de Formulario\" y lo dibujamos dentro de la Hoja.<\/div><\/span><\/li><\/ul><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-169bb19f55a\"><span class=\"tve_image_frame\" style=\"width: 100%;\"><img decoding=\"async\" loading=\"lazy\" class=\"tve_image wp-image-42008\" alt=\"Formulario desde Excel\" width=\"628\" height=\"274\" title=\"Control de Formularios\" data-id=\"42008\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2019\/03\/Control-de-Formularios.png\" style=\"aspect-ratio: auto 628 \/ 274;\" data-width=\"628\" data-height=\"274\" data-init-width=\"628\" data-init-height=\"274\"><\/span><\/div><div class=\"thrv_wrapper thrv-numbered_list\" data-start-number=\"3\" data-number-increment=\"1\" data-css=\"tve-u-1621fde6467\" data-color=\"rgb(10, 0, 0)\"><ul class=\"tcb-numbered-list\"><li class=\"thrv-styled-list-item\" data-css=\"tve-u-169bb1c87a6\"><div class=\"tcb-numbered-list-number thrv-disabled-label thrv_wrapper tcb-no-delete tcb-no-clone tve_no_drag\" data-css=\"tve-u-193da50a7f5\" style=\"\"><span class=\"tcb-numbered-list-index\">3<\/span><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-numbered-list-text tcb-no-delete\" data-css=\"tve-u-169bb1c5ce6\"><div style=\"text-align: justify;\">Una vez dibujado el control, al soltar el mouse se presenta una nueva ventana. Hacemos clic en el bot\u00f3n \"Nuevo\".<\/div><\/span><\/li><\/ul><\/div><div class=\"thrv_wrapper thrv_text_element\" data-tag=\"h3\"><h3 data-css=\"tve-u-1621fed344d\" style=\"text-align: center;\" class=\"\">Ejemplo de Formulario desde excel<\/h3><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-1621fe4a8ae\"><span class=\"tve_image_frame\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2018\/03\/Asignar-Macro-a-Boton.png\" rel=\"\"><img decoding=\"async\" loading=\"lazy\" class=\"tve_image wp-image-35517\" alt=\"Formulario desde Excel\" width=\"404\" height=\"412\" title=\"Bot\u00f3n Nuevo\" data-id=\"35517\" src=\"\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2018\/03\/Asignar-Macro-a-Boton.png\"><\/a><\/span><\/div><div class=\"thrv_wrapper thrv-numbered_list\" data-start-number=\"5\" data-number-increment=\"1\" data-css=\"tve-u-1621fe94b3e\" data-color=\"rgb(10, 0, 0)\"><ul class=\"tcb-numbered-list\"><li class=\"thrv-styled-list-item\"><div class=\"tcb-numbered-list-number thrv-disabled-label thrv_wrapper tcb-no-delete tcb-no-clone tve_no_drag\" data-css=\"tve-u-193da50bd1d\" style=\"\"><span class=\"tcb-numbered-list-index\">5<\/span><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-numbered-list-text tcb-no-delete\" data-css=\"tve-u-169bb2a35d8\"><div style=\"text-align: justify;\">Donde titila el cursor escribimos: DatosUF.Show cada vez que hagamos clic en la figura se ejecutar\u00e1 el UserForm.<\/div><\/span><\/li><li class=\"thrv-styled-list-item\"><div class=\"tcb-numbered-list-number thrv-disabled-label thrv_wrapper tcb-no-delete tcb-no-clone tve_no_drag\" data-css=\"tve-u-193da50bd1d\" style=\"\"><span class=\"tcb-numbered-list-index\">6<\/span><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-numbered-list-text tcb-no-delete\" data-css=\"tve-u-169bb2a35d8\"><div style=\"text-align: justify;\">Vamos a cambiar el nombre del bot\u00f3n, para modificarlo vamos a ubicarnos encima del bot\u00f3n y pulsamos clic derecho del mouse, se despliega varias opciones y seleccionamos con un clic \"Modificar Texto\". Borramos el texto y escribimos \"Formulario Datos\".<\/div><\/span><\/li><\/ul><\/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-1621fed792d\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-1621fed792e\" style=\"text-align: justify;\">Ahora vamos a probar que tal funciona el bot\u00f3n, para eso he grabado un v\u00eddeo bien cortico de 26 segundo que te mostrara como quedo el bot\u00f3n y su funcionalidad:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_responsive_video thrv_wrapper tcb-lazy-load tcb-lazy-load-youtube\" data-type=\"youtube\" data-url=\"https:\/\/youtu.be\/xKBXS1Dn8Xg\" data-css=\"tve-u-1621ffe0d6c\" data-showinfo=\"0\" data-modestbranding=\"1\" data-rel=\"0\" data-aspect-ratio=\"16:9\" data-aspect-ratio-default=\"0\">\n<div class=\"tve_responsive_video_container\" style=\"padding-bottom: 56.25%;\">\n<div class=\"video_overlay\"><\/div>\n<iframe title=\"Responsive Video\" class=\"tcb-responsive-video\" data-code=\"xKBXS1Dn8Xg\" data-hash=\"undefined\" data-provider=\"youtube\" frameborder=\"0\" allowfullscreen=\"\" loading=\"lazy\" data-src=\"https:\/\/www.youtube.com\/embed\/xKBXS1Dn8Xg?rel=0&amp;modestbranding=1&amp;controls=1&amp;showinfo=0&amp;fs=1&amp;wmode=transparent&amp;enablejsapi=1\"><\/iframe><\/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-1621ff94c8d\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-1621ff94c8f\" style=\"text-align: justify;\">Muy bien, con esto hemos terminado con el tema de formularios, para el tema siguiente vamos a ver <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/programar-en-excel-ejecutar-macro-desde-otra-macro.html\" target=\"_blank\" class=\"\" style=\"outline: none;\"><strong>Como Ejecutar una Macro desde otra Macro<\/strong><\/a>.<\/p><p data-css=\"tve-u-1621ff94c8f\" style=\"text-align: justify;\">Y si te ha gustado el tema de hoy, te invito a que lo compartas con tus amigos de Facebook pulsando clic en el bot\u00f3n compartir:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_social_custom thrv_social\" data-counts=\"\" data-min_shares=\"0\" data-css=\"tve-u-1621ffafc1c\">\n<div class=\"tve_social_items tve_social_custom tve_style_1 tve_social_itb\">\n<div class=\"tve_s_item tve_s_fb_share\" data-s=\"fb_share\" data-href=\"https:\/\/aplicaexcelcontable.com\/blog\/programar-en-excel-llamar-un-formulario-desde-excel.html\" data-label=\"Compartir\">\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-1621ffb5d31\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-1621ffb5d32\" style=\"text-align: justify;\">Para finalizar, me gustar\u00eda saber que piensas de este articulo \"Programar en Excel - Llamar un Formulario desde Excel\".<\/p><p data-css=\"tve-u-1621ffb5d32\" style=\"text-align: justify;\">Por lo tanto:<\/p><p data-css=\"tve-u-1621ffb5d32\" style=\"text-align: justify;\">D\u00e9jame tu comentario con dudas, cr\u00edticas constructivas y sugerencia en la secci\u00f3n de comentarios o bien en el Chat. Al mismo tiempo te invito a que visites nuestra pagina de Facebook, <span data-css=\"tve-u-1621ffc5bb9\" style=\"color: rgb(0, 23, 255);\"><a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\" class=\"\" style=\"outline: none;\"><strong>pulsando clic aqu\u00ed<\/strong><\/a><\/span>.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-193a3d424cc\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-193a3d424ca\"><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-193a3d424ce\">&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-193a3d424cf\">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-193a3d424d0\" 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-193a3d424d1\">whatsapp<\/span> o bien al correo electr\u00f3nico rogerperez@aplicaexcelcontable.com.<span style=\"--tcb-text-highlight-color: transparent !important;\" data-css=\"tve-u-193a3d424d2\"><\/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-1622003d731\"] { color: rgb(0, 23, 255) !important; }[data-css=\"tve-u-1621ffe0d6c\"] { float: none; border: 3px solid rgb(150, 159, 166); margin-left: auto !important; margin-right: auto !important; }[data-css=\"tve-u-1621ffc5bb9\"] { color: rgb(0, 23, 255) !important; }[data-css=\"tve-u-1621ffafc1c\"] { float: none; margin-left: auto !important; margin-right: auto !important; }:not(#tve) [data-css=\"tve-u-1621fed344d\"] { color: rgb(0, 23, 255) !important; font-size: 25px !important; }:not(#tve) [data-css=\"tve-u-1621fe94b3e\"] p, :not(#tve) [data-css=\"tve-u-1621fe94b3e\"] li, :not(#tve) [data-css=\"tve-u-1621fe94b3e\"] blockquote, :not(#tve) [data-css=\"tve-u-1621fe94b3e\"] address, :not(#tve) [data-css=\"tve-u-1621fe94b3e\"] h1, :not(#tve) [data-css=\"tve-u-1621fe94b3e\"] h2, :not(#tve) [data-css=\"tve-u-1621fe94b3e\"] h3, :not(#tve) [data-css=\"tve-u-1621fe94b3e\"] h4, :not(#tve) [data-css=\"tve-u-1621fe94b3e\"] h5, :not(#tve) [data-css=\"tve-u-1621fe94b3e\"] h6 { color: rgb(10, 0, 0); }[data-css=\"tve-u-1621fe94b3e\"] .tcb-numbered-list-number { color: rgb(10, 0, 0); }[data-css=\"tve-u-1621fe4a8ae\"] + div { clear: none; }[data-css=\"tve-u-1621fe4a8ae\"] { float: none; margin-left: auto; margin-right: auto; width: 404px; }:not(#tve) [data-css=\"tve-u-1621fde6467\"] p, :not(#tve) [data-css=\"tve-u-1621fde6467\"] li, :not(#tve) [data-css=\"tve-u-1621fde6467\"] blockquote, :not(#tve) [data-css=\"tve-u-1621fde6467\"] address, :not(#tve) [data-css=\"tve-u-1621fde6467\"] h1, :not(#tve) [data-css=\"tve-u-1621fde6467\"] h2, :not(#tve) [data-css=\"tve-u-1621fde6467\"] h3, :not(#tve) [data-css=\"tve-u-1621fde6467\"] h4, :not(#tve) [data-css=\"tve-u-1621fde6467\"] h5, :not(#tve) [data-css=\"tve-u-1621fde6467\"] h6 { color: rgb(10, 0, 0); }[data-css=\"tve-u-1621fde6467\"] .tcb-numbered-list-number { color: rgb(10, 0, 0); }:not(#tve) [data-css=\"tve-u-1621fd28d17\"] p, :not(#tve) [data-css=\"tve-u-1621fd28d17\"] li, :not(#tve) [data-css=\"tve-u-1621fd28d17\"] blockquote, :not(#tve) [data-css=\"tve-u-1621fd28d17\"] address, :not(#tve) [data-css=\"tve-u-1621fd28d17\"] h1, :not(#tve) [data-css=\"tve-u-1621fd28d17\"] h2, :not(#tve) [data-css=\"tve-u-1621fd28d17\"] h3, :not(#tve) [data-css=\"tve-u-1621fd28d17\"] h4, :not(#tve) [data-css=\"tve-u-1621fd28d17\"] h5, :not(#tve) [data-css=\"tve-u-1621fd28d17\"] h6 { color: rgb(10, 0, 0); }[data-css=\"tve-u-1621fd28d17\"] .tcb-numbered-list-number { color: rgb(10, 0, 0); }:not(#tve) [data-css=\"tve-u-1621fd1182f\"] { font-size: 38px !important; color: rgb(0, 23, 255) !important; }:not(#tve) [data-css=\"tve-u-1621fcea338\"] { font-size: 42px !important; color: rgb(255, 0, 0) !important; }[data-css=\"tve-u-1621fcf347a\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-1621fcf347c\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-1621fd216e8\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-1621fd216e9\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-1621fed792d\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-1621fed792e\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-1621ff94c8d\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-1621ff94c8f\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-1621ffb5d31\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-1621ffb5d32\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-169bb19f55a\"] { width: 628px; float: none; margin-left: auto !important; margin-right: auto !important; }[data-css=\"tve-u-18767911020\"] { border: 4px dashed rgba(15, 227, 99, 0.85); --tve-applied-border: 4px dashed rgba(15,227,99,0.85); --tve-border-width: 4px; --tve-border-radius: 60px; border-radius: 60px; overflow: hidden; }.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; }[data-css=\"tve-u-1621fd28d17\"] { padding-top: 0px !important; margin-top: 10px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-193a3d424ca\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-193a3d424ca\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-193a3d424ca\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-193a3d424ca\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-193a3d424ca\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-193a3d424ca\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-193a3d424ca\"] { --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-193a3d424ca\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-193a3d424ca\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-193a3d424ca\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-193a3d424ca\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-193a3d424ca\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-193a3d424ca\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-193a3d424ca\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-193a3d424ca\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-193a3d424ca\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-193a3d424ca\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-193a3d424ca\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-193a3d424ca\"] 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-193a3d424ca\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-193a3d424cc\"] { margin-top: 20px !important; margin-bottom: 20px !important; padding: 0px !important; }[data-css=\"tve-u-193a3d424ce\"] { --tcb-text-highlight-color: rgb(237,243,13) !important; }[data-css=\"tve-u-193a3d424cf\"] { --tcb-text-highlight-color: rgb(237,243,13) !important; }[data-css=\"tve-u-193a3d424d0\"] { --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-193a3d424d1\"] { --tcb-text-highlight-color: rgb(30,184,76) !important; }[data-css=\"tve-u-193a3d424d2\"] { --tcb-text-highlight-color: transparent !important; }[data-css=\"tve-u-193da507dea\"] { padding-top: 0px !important; }[data-css=\"tve-u-193da50a7f5\"] { padding-top: 0px !important; }[data-css=\"tve-u-193da50bd1d\"] { padding-top: 0px !important; }}@media (max-width: 1023px){:not(#tve) [data-css=\"tve-u-1621fcea338\"] { font-size: 25px !important; }:not(#tve) [data-css=\"tve-u-1621fd1182f\"] { font-size: 22px !important; }:not(#tve) [data-css=\"tve-u-1621fed344d\"] { font-size: 22px !important; }}@media (max-width: 767px){:not(#tve) [data-css=\"tve-u-1621fed344d\"] { font-size: 20px !important; }:not(#tve) [data-css=\"tve-u-1621fd1182f\"] { font-size: 20px !important; }:not(#tve) [data-css=\"tve-u-1621fcea338\"] { font-size: 23px !important; }}","tve_user_custom_css":"","tve_globals":{"e":"1","font_cls":[]},"tcb2_ready":1,"tcb_editor_enabled":1,"tve_landing_page":"","_tve_header":"0","_tve_footer":"0"},"categories":[4,22],"tags":[293,292,295,294],"class_list":["post-5526","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-programar-en-excel","category-curso-basico-de-vba","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\/5526","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=5526"}],"version-history":[{"count":0,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/5526\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media\/42008"}],"wp:attachment":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media?parent=5526"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/categories?post=5526"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/tags?post=5526"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}