{"id":11390,"date":"2022-11-13T08:59:41","date_gmt":"2022-11-13T01:59:41","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=11390"},"modified":"2025-04-15T10:01:15","modified_gmt":"2025-04-15T03:01:15","slug":"lap-trinh-vba-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/","title":{"rendered":"L\u1eadp tr\u00ecnh VBA trong Excel &#8211; C\u00e1c b\u01b0\u1edbc l\u1eadp tr\u00ecnh t\u1eeb A-Z"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;11390&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;5&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (5 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;L\u1eadp tr\u00ecnh VBA trong Excel - C\u00e1c b\u01b0\u1edbc l\u1eadp tr\u00ecnh t\u1eeb A-Z&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (5 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p style=\"text-align: justify;\"><em><span style=\"font-weight: 400;\">VBA l\u00e0 vi\u1ebft t\u1eaft c\u1ee7a Visual Basic for Applications gi\u00fap cho ph\u1ea7n m\u1ec1m excel th\u00f4ng th\u01b0\u1eddng tr\u1edf n\u00ean linh ho\u1ea1t; gi\u00fap gi\u1ea3i c\u00e1c b\u00e0i to\u00e1n ph\u1ee9c t\u1ea1p m\u00e0 ph\u1ea7n m\u1ec1m excel c\u01a1 b\u1ea3n kh\u00f4ng gi\u1ea3i quy\u1ebft \u0111\u01b0\u1ee3c. <\/span><span style=\"font-weight: 400;\">H\u1ecdc <\/span><b>l\u1eadp tr\u00ecnh VBA gi\u00fap trong Excel<\/b><span style=\"font-weight: 400;\"> gi\u00fap b\u1ea1n t\u1ef1 \u0111\u1ed9ng h\u00f3a c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c giao m\u1ed9t c\u00e1ch nhanh nh\u1ea5t; thay v\u00ec d\u00f9ng c\u00e1c ph\u01b0\u01a1ng ph\u00e1p truy\u1ec1n th\u1ed1ng. D\u00f9 b\u1ea1n \u0111\u00e3 th\u00e0nh th\u1ea1o excel hay l\u00e0 ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u; th\u00ec vi\u1ec7c h\u1ecdc c\u00e1ch l\u1eadp tr\u00ecnh VBA lu\u00f4n h\u1eefu \u00edch v\u00e0 c\u1ea7n thi\u1ebft. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 b\u00e0i vi\u1ebft ch\u1ee9a nh\u1eefng th\u00f4ng tin h\u1eefu \u00edch v\u1ec1 <\/span><b>l\u1eadp tr\u00ecnh VBA trong excel cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u<\/b><span style=\"font-weight: 400;\">.<\/span><\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 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\">N\u1ed9i dung <\/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=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/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:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/#Bat_dau_su_dung_lap_trinh_VBA_trong_Excel\" >B\u1eaft \u0111\u1ea7u s\u1eed d\u1ee5ng l\u1eadp tr\u00ecnh VBA trong Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/#Huong_dan_lap_trinh_VBA_trong_Excel\" >H\u01b0\u1edbng d\u1eabn l\u1eadp tr\u00ecnh VBA trong Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/#Hoc_lap_trinh_VBA_trong_Excel\" >H\u1ecdc l\u1eadp tr\u00ecnh VBA trong Excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/#Ban_co_the_tu_hoc_lap_trinh_VBA_trong_Excel_duoc_khong\" >B\u1ea1n c\u00f3 th\u1ec3 t\u1ef1 h\u1ecdc l\u1eadp tr\u00ecnh VBA trong Excel \u0111\u01b0\u1ee3c kh\u00f4ng?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/#Nguon_tai_lieu_de_hoc_lap_trinh_VBA_trong_Excel_o_dau\" >Ngu\u1ed3n t\u00e0i li\u1ec7u \u0111\u1ec3 h\u1ecdc l\u1eadp tr\u00ecnh VBA trong Excel \u1edf \u0111\u00e2u?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Bat_dau_su_dung_lap_trinh_VBA_trong_Excel\"><\/span><b>B\u1eaft \u0111\u1ea7u s\u1eed d\u1ee5ng l\u1eadp tr\u00ecnh VBA trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<figure id=\"attachment_11413\" aria-describedby=\"caption-attachment-11413\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11413 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/lap-trinh-VBA-4.jpg\" alt=\"B\u1eaft \u0111\u1ea7u s\u1eed d\u1ee5ng l\u1eadp tr\u00ecnh VBA trong Excel\" width=\"600\" height=\"400\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/lap-trinh-VBA-4.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/lap-trinh-VBA-4-400x267.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/lap-trinh-VBA-4-272x182.jpg 272w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11413\" class=\"wp-caption-text\">B\u1eaft \u0111\u1ea7u s\u1eed d\u1ee5ng l\u1eadp tr\u00ecnh VBA trong Excel<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Hi\u1ec3u \u0111\u01b0\u1ee3c nh\u1eefng kh\u00e1i ni\u1ec7m c\u01a1 b\u1ea3n sau \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n vi\u1ebft \u0111\u01b0\u1ee3c c\u00e2u l\u1ec7nh<\/span><b> l\u1eadp tr\u00ecnh VBA trong excel<\/b><span style=\"font-weight: 400;\"> d\u1ec5 d\u00e0ng h\u01a1n.<\/span><\/p>\n<p style=\"text-align: justify;\"><b>Bi\u1ebfn s\u1ed1 l\u00e0 g\u00ec?<\/b><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi b\u1ea1n l\u00e0m VBA, b\u1ea1n s\u1ebd th\u01b0\u1eddng xuy\u00ean l\u00e0m vi\u1ec7c v\u1edbi bi\u1ebfn s\u1ed1. Bi\u1ebfn s\u1ed1 gi\u1ed1ng nh\u01b0 ki\u1ebfn th\u1ee9c b\u1ea1n \u0111\u00e3 t\u1eebng h\u1ecdc v\u1ec1 m\u00f4n \u0111\u1ea1i s\u1ed1. T\u00ecm (x+3y) trong \u0111\u00f3 x v\u00e0 y l\u00e0 bi\u1ebfn. B\u1ea1n c\u00f3 th\u1ec3 g\u00e1n s\u1ed1 x v\u00e0 y b\u1ea5t k\u1ef3, n\u00f3 \u0111\u1ea1i di\u1ec7n cho m\u1ed9t gi\u00e1 tr\u1ecb v\u00e0 c\u00f3 th\u1ec3 thay \u0111\u1ed5i. Trong VBA Excel, khi b\u1ea1n khai b\u00e1o bi\u1ebfn chu\u1ea9n th\u00ec nh\u1eefng b\u01b0\u1edbc x\u1eed l\u00fd sau \u0111\u00f3 s\u1ebd tr\u1edf n\u00ean \u0111\u01a1n gi\u1ea3n h\u01a1n.<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"L\u00e2\u0323p tri\u0300nh VBA trong Excel cho ng\u01b0\u01a1\u0300i m\u01a1\u0301i b\u0103\u0301t \u0111\u00e2\u0300u | #01 Ca\u0300i \u0111\u0103\u0323t, button, bi\u00ea\u0301n, vo\u0300ng l\u0103\u0323p\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/UPYXlS-pNCA?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p style=\"text-align: justify;\"><b>C\u00e1ch khai b\u00e1o bi\u1ebfn<\/b><span style=\"font-weight: 400;\">: Dim &lt;t\u00ean bi\u1ebfn <\/span><i><span style=\"font-weight: 400;\">(l\u00e0 ch\u1eef c\u00e1i kh\u00f4ng c\u00f3 k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t)<\/span><\/i><span style=\"font-weight: 400;\">&gt; As &lt;Ki\u1ec3u d\u1eef li\u1ec7u <\/span><i><span style=\"font-weight: 400;\">(d\u1eef li\u1ec7u \u0111\u1ecbnh d\u1ea1ng cho t\u00ean bi\u1ebfn)<\/span><\/i><span style=\"font-weight: 400;\">&gt;<\/span><\/p>\n<p style=\"text-align: justify;\">Xem th\u00eam b\u00e0i vi\u1ebft:<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/teky.edu.vn\/blog\/huong-dan-su-dung-cac-phim-tat-chuyen-sheet-trong-excel-don-gian-nhat\/\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng c\u00e1c ph\u00edm t\u1eaft chuy\u1ec3n sheet trong excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/a><\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/teky.edu.vn\/blog\/cach-co-dinh-o-trong-excel\/\">H\u01b0\u1edbng d\u1eabn c\u00e1ch c\u1ed1 \u0111\u1ecbnh \u00f4 trong Excel \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh ch\u00f3ng nh\u1ea5t<\/a><\/p>\n<figure id=\"attachment_11410\" aria-describedby=\"caption-attachment-11410\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11410 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/lap-trinh-VBA-1.jpg\" alt=\"B\u1eaft \u0111\u1ea7u s\u1eed d\u1ee5ng l\u1eadp tr\u00ecnh VBA trong Excel\" width=\"600\" height=\"314\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/lap-trinh-VBA-1.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/lap-trinh-VBA-1-400x209.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11410\" class=\"wp-caption-text\">C\u00e1ch s\u1eed d\u1ee5ng l\u1eadp tr\u00ecnh VBA<\/figcaption><\/figure>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Huong_dan_lap_trinh_VBA_trong_Excel\"><\/span><b>H\u01b0\u1edbng d\u1eabn l\u1eadp tr\u00ecnh VBA trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 <\/span><b>l\u1eadp tr\u00ecnh \u0111\u01b0\u1ee3c VBA trong Excel<\/b><span style=\"font-weight: 400;\">, ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u VBA g\u1ed3m c\u00f3 nh\u1eefng g\u00ec:<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">T\u1ea1o m\u1ed9t macro: B\u1ea1n h\u00e3y t\u1ea1o m\u1ed9t macros th\u1ec3 thay th\u1ebf nhi\u1ec1u thao t\u00e1c, nhi\u1ec7m v\u1ee5 m\u1ed9t c\u00e1ch t\u1ef1 \u0111\u1ed9ng. Sau n\u00e0y khi mu\u1ed1n th\u1ef1c hi\u1ec7n nh\u1eefng thao t\u00e1c \u0111\u00f3 b\u1ea1n ch\u1ec9 c\u1ea7n l\u1ea5y macros l\u00e0 xong.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Msgbox: D\u00f9ng \u0111\u1ec3 th\u00f4ng b\u00e1o cho ng\u01b0\u1eddi d\u00f9ng c\u00e1c thao t\u00e1c h\u1ecd \u0111ang l\u00e0m hay \u0111\u00e3 l\u00e0m xong; ho\u1eb7c khi h\u1ecd b\u1ecb l\u00e0m sai tr\u01b0\u1eddng d\u1eef li\u1ec7u m\u00e0 h\u1ecd \u0111ang l\u00e0m c\u00e1c l\u1ec7nh trong macros.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Workbook v\u00e0 worksheet object: Th\u1ec3 hi\u1ec7n ph\u1ea1m vi VBA \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng; trong \u0111\u00f3 1 workbook g\u1ed3m nhi\u1ec1u worksheet, 1 worksheet g\u1ed3m nhi\u1ec1u range.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Range object: Range l\u00e0 m\u1ed9t \u00f4 ho\u1eb7c m\u1ed9t v\u00f9ng d\u00f9ng \u0111\u1ec3 tham chi\u1ebfu \u0111\u1ebfn m\u1ed9t v\u00f9ng ch\u1ecdn trong Excel. Trong l\u1eadp tr\u00ecnh VBA, \u0111\u1ed1i t\u01b0\u1ee3ng n\u00e0y r\u1ea5t quan tr\u1ecdng.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Variables: N\u00f3 l\u00e0 m\u1ed9t lo\u1ea1i bi\u1ebfn s\u1ed1.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">If then statements: N\u00f3 t\u01b0\u01a1ng t\u1ef1 nh\u01b0 h\u00e0m if trong excel.<\/span><\/p>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_11411\" aria-describedby=\"caption-attachment-11411\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11411 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/lap-trinh-VBA-2.jpg\" alt=\"H\u01b0\u1edbng d\u1eabn l\u1eadp tr\u00ecnh VBA trong Excel\" width=\"600\" height=\"172\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/lap-trinh-VBA-2.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/lap-trinh-VBA-2-400x115.jpg 400w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11411\" class=\"wp-caption-text\">H\u01b0\u1edbng d\u1eabn l\u1eadp tr\u00ecnh VBA<\/figcaption><\/figure>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Loop: b\u1eb1ng nh\u1eefng l\u1ec7nh \u0111\u01a1n gi\u1ea3n, loop gi\u00fap b\u1ea1n l\u1eb7p l\u1ea1i thao t\u00e1c trong m\u1ed9t v\u00f9ng. \u0110\u00e2y l\u00e0 m\u1ed9t thao t\u00e1c th\u01b0\u1eddng xuy\u00ean s\u1eed d\u1ee5ng.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Userform: Tr\u00ean Windows, Userform l\u00e0 giao di\u1ec7n c\u1ee7a c\u00e1c ph\u1ea7n m\u1ec1m; \u0111\u01b0\u1ee3c vi\u1ebft tr\u00ean c\u00e1c ng\u00f4n ng\u1eef Visual Basic hay Java. C\u00f2n tr\u00ean VBA, n\u00f3 s\u1eed d\u1ee5ng nh\u1eefng \u0111\u1ed1i t\u01b0\u1ee3ng Command Button, TextBox \u0111\u1ec3 t\u1ea1o Userform.\u00a0<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Events: Gi\u00fap ta bi\u1ebft \u0111\u01b0\u1ee3c s\u1ef1 ki\u1ec7n c\u1ee7a ng\u01b0\u1eddi d\u00f9ng l\u00ean m\u1ed9t \u0111\u1ed1i t\u01b0\u1ee3ng n\u00e0o \u0111\u00f3. V\u00ed d\u1ee5 ng\u01b0\u1eddi d\u00f9ng nh\u1ea5n 1 l\u1ea7n chu\u1ed9t-click, ng\u01b0\u1eddi d\u00f9ng nh\u1ea5n 2 l\u1ea7n-double click.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Function &amp; sub: Khi mu\u1ed1n VBA tr\u1ea3 v\u1ec1 m\u1ed9t gi\u00e1 tr\u1ecb n\u00e0o \u0111\u00f3, b\u1ea1n d\u00f9ng Function. C\u00f2n khi b\u1ea1n mu\u1ed1n VBA th\u1ef1c hi\u1ec7n h\u00e0nh \u0111\u1ed9ng b\u1ea5t k\u1ef3, h\u00e3y d\u00f9ng Sub, Sub kh\u00f4ng tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb nh\u01b0 Function. V\u1edbi nh\u1eefng ch\u01b0\u01a1ng tr\u00ecnh l\u1edbn c\u1ea7n x\u1eed l\u00fd nhi\u1ec1u, th\u00ec \u0111\u00e2y l\u00e0 2 h\u00e0m r\u1ea5t h\u1eefu d\u1ee5ng.<\/span><\/p>\n<p><a href=\"http:\/\/hoclaptrinhmienphi.teky.vn\/1hhoclaptrinh\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24877\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2024\/03\/Banner-Free-Trial.png\" alt=\"H\u1ecdc th\u1eed mi\u1ec5n ph\u00ed\" width=\"600\" height=\"314\" \/><\/a><\/p>\n<h2 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Hoc_lap_trinh_VBA_trong_Excel\"><\/span><b>H\u1ecdc l\u1eadp tr\u00ecnh VBA trong Excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">B\u01b0\u1edbc \u0111\u1ec7m \u0111\u1ea7u ti\u00ean n\u1ebfu b\u1ea1n mu\u1ed1n h\u1ecdc VBA l\u00e0 b\u1ea1n ph\u1ea3i trang b\u1ecb m\u1ed9t ki\u1ebfn th\u1ee9c excel thu\u1ea7n th\u1ee5c. B\u1edfi b\u1ea3n ch\u1ea5t excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 t\u00ednh to\u00e1n, tr\u00ecnh b\u00e0y th\u00f4ng d\u1ee5ng v\u00e0 v\u00f4 c\u00f9ng h\u1eefu \u00edch, trong \u0111\u00f3 kh\u00f4ng th\u1ec3 kh\u00f4ng nh\u1eafc \u0111\u1ebfn macro trong excel. Tr\u01b0\u1edbc h\u1ebft, b\u1ea1n n\u00ean h\u1ecdc Visual Basic \u0111\u1ec3 gi\u1ea3i quy\u1ebft c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh b\u1edfi n\u00f3 s\u1eed d\u1ee5ng \u1edf h\u1ea7u h\u1ebft c\u00e1c Microsoft, kh\u00f4ng ch\u1ec9 ri\u00eang excel.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Ban_co_the_tu_hoc_lap_trinh_VBA_trong_Excel_duoc_khong\"><\/span><span style=\"font-weight: 400;\">B\u1ea1n c\u00f3 th\u1ec3 t\u1ef1 h\u1ecdc <\/span><b>l\u1eadp tr\u00ecnh VBA trong Excel <\/b><span style=\"font-weight: 400;\">\u0111\u01b0\u1ee3c kh\u00f4ng?<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Ho\u00e0n to\u00e0n c\u00f3 th\u1ec3, n\u1ebfu b\u1ea1n l\u00e0 m\u1ed9t ng\u01b0\u1eddi ki\u00ean tr\u00ec, ch\u1ecbu kh\u00f3 t\u00ecm t\u00f2i. B\u1edfi VBA v\u1ed1n d\u0129 l\u00e0 m\u1ed9t kho t\u00e0ng ki\u1ebfn th\u1ee9c kh\u1ed5ng l\u1ed3, B\u1ea1n c\u00f3 th\u1ec3 b\u1eaft \u0111\u1ea7u b\u1eb1ng nh\u1eefng ki\u1ebfn th\u1ee9c t\u1eeb \u0111\u01a1n gi\u1ea3n \u0111\u1ebfn ph\u1ee9c t\u1ea1p h\u01a1n. V\u00e0 quan tr\u1ecdng nh\u1ea5t l\u00e0 h\u1ecdc \u0111i \u0111\u00f4i v\u1edbi th\u1ef1c h\u00e0nh, h\u1ecdc \u0111\u1ebfn \u0111\u00e2u th\u1ef1c h\u00e0nh t\u1edbi \u0111\u00f3. Khi \u0111\u00f3 ki\u1ebfn th\u1ee9c b\u1ea1n h\u1ecdc s\u1ebd \u0111\u01b0\u1ee3c ghi nh\u1edb l\u00e2u nh\u1ea5t.<\/span><\/p>\n<figure id=\"attachment_11412\" aria-describedby=\"caption-attachment-11412\" style=\"width: 600px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-11412 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/lap-trinh-VBA-3.jpg\" alt=\"B\u1ea1n c\u00f3 th\u1ec3 t\u1ef1 h\u1ecdc l\u1eadp tr\u00ecnh VBA trong Excel \u0111\u01b0\u1ee3c kh\u00f4ng?\" width=\"600\" height=\"738\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/lap-trinh-VBA-3.jpg 600w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/lap-trinh-VBA-3-325x400.jpg 325w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption id=\"caption-attachment-11412\" class=\"wp-caption-text\">T\u1ef1 h\u1ecdc l\u1eadp tr\u00ecnh VBA \u0111\u01b0\u1ee3c kh\u00f4ng?<\/figcaption><\/figure>\n<h3 style=\"text-align: justify;\"><span class=\"ez-toc-section\" id=\"Nguon_tai_lieu_de_hoc_lap_trinh_VBA_trong_Excel_o_dau\"><\/span><span style=\"font-weight: 400;\">Ngu\u1ed3n t\u00e0i li\u1ec7u \u0111\u1ec3 h\u1ecdc <\/span><b>l\u1eadp tr\u00ecnh VBA trong Excel <\/b><span style=\"font-weight: 400;\">\u1edf \u0111\u00e2u?<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Hi\u1ec7n nay, v\u1edbi kh\u00f4ng gian m\u1edf, b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm t\u00e0i li\u1ec7u h\u1ecdc t\u1eadp \u1edf b\u1ea5t k\u1ef3 \u0111\u00e2u. B\u1ea1n c\u00f3 th\u1ec3 t\u00ecm h\u1ecdc tr\u00ean <a href=\"https:\/\/vi.wikipedia.org\/wiki\/YouTube\">Youtube<\/a>, internet hay c\u00e1c t\u00e0i li\u1ec7u PDF, kh\u00f3a h\u1ecdc online \u0111\u01b0\u1ee3c m\u1edf b\u00e1n tr\u00ean m\u1ea1ng. Tuy nhi\u00ean, theo ph\u01b0\u01a1ng ph\u00e1p n\u00e0o th\u00ec s\u1ef1 ki\u00ean tr\u00ec v\u00e0 m\u1ed9t c\u00e1ch s\u1eafp x\u1ebfp khoa h\u1ecdc; chi\u1ebfn l\u01b0\u1ee3c t\u1ed1t c\u0169ng l\u00e0 y\u1ebfu t\u1ed1 ti\u00ean quy\u1ebft nh\u00e9!<\/span><\/p>\n<p><a href=\"https:\/\/khuyenmai.teky.vn\/tangsachlaptrinh\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24876\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2024\/03\/Free-Asset.png\" alt=\"T\u1eb7ng s\u00e1ch mi\u1ec5n ph\u00ed\" width=\"600\" height=\"314\" \/><\/a><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Khi v\u1ed1n ki\u1ebfn th\u1ee9c c\u1ee7a b\u1ea1n \u0111\u1ee7 nhi\u1ec1u; th\u00ec b\u1ea1n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng gi\u1ea3i quy\u1ebft nh\u1eefng v\u1ea5n \u0111\u1ec1 ph\u1ee9c t\u1ea1p trong c\u00f4ng vi\u1ec7c c\u0169ng nh\u01b0 th\u1ef1c t\u1ebf.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-weight: 400;\">Tr\u00ean \u0111\u00e2y ch\u00fang t\u00f4i \u0111\u00e3 t\u1ed5ng h\u1ee3p l\u1ea1i nh\u1eefng \u0111i\u1ec1u c\u01a1 b\u1ea3n v\u1ec1 <\/span><b>l\u1eadp tr\u00ecnh VBA trong Excel<\/b><span style=\"font-weight: 400;\">; hi\u1ec3u \u0111\u01b0\u1ee3c nh\u1eefng kh\u00e1i ni\u1ec7m c\u0169ng nh\u01b0 c\u00e1ch l\u1eadp tr\u00ecnh c\u01a1 b\u1ea3n s\u1ebd gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft nh\u1eefng v\u1ea5n \u0111\u1ec1 kh\u00f3 h\u01a1n. H\u1eb9n g\u1eb7p l\u1ea1i v\u00e0o b\u00e0i vi\u1ebft ti\u1ebfp theo nh\u00e9!<\/span><\/p>\n<p><strong>Xem th\u00eam:<\/strong><\/p>\n<ul>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/vba-excel-la-gi\/\" target=\"_blank\" rel=\"noopener\">VBA Excel l\u00e0 g\u00ec? 5 m\u1eb9o gi\u00fap b\u1ea1n l\u1eadp tr\u00ecnh VBA \u0111\u01a1n gi\u1ea3n trong Excel<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-bo-dau-trong-excel-nhanh-chong-don-gian\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch b\u1ecf d\u1ea5u trong Excel nhanh ch\u00f3ng, \u0111\u01a1n gi\u1ea3n<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-xoa-so-trang-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch x\u00f3a s\u1ed1 trang trong excel sao cho \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-an-cong-thuc-trong-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch \u1ea9n c\u00f4ng th\u1ee9c trong excel \u0111\u01a1n gi\u1ea3n nh\u1ea5t 2022<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/khoa-o-trong-excel\/\" target=\"_blank\" rel=\"noopener\">M\u1eb9o kh\u00f3a \u00f4 trong Excel an to\u00e0n, nhanh ch\u00f3ng<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>VBA l\u00e0 vi\u1ebft t\u1eaft c\u1ee7a Visual Basic for Applications gi\u00fap cho ph\u1ea7n m\u1ec1m excel th\u00f4ng th\u01b0\u1eddng tr\u1edf n\u00ean linh ho\u1ea1t; gi\u00fap gi\u1ea3i c\u00e1c b\u00e0i to\u00e1n ph\u1ee9c t\u1ea1p m\u00e0 ph\u1ea7n m\u1ec1m excel c\u01a1 b\u1ea3n kh\u00f4ng gi\u1ea3i quy\u1ebft \u0111\u01b0\u1ee3c. H\u1ecdc l\u1eadp tr\u00ecnh VBA gi\u00fap trong Excel gi\u00fap b\u1ea1n t\u1ef1 \u0111\u1ed9ng h\u00f3a c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c giao m\u1ed9t &hellip;<\/p>\n","protected":false},"author":3,"featured_media":11409,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-11390","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.9 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>L\u1eadp tr\u00ecnh VBA trong Excel - C\u00e1c b\u01b0\u1edbc l\u1eadp tr\u00ecnh t\u1eeb A-Z cho ng\u01b0\u1eddi m\u1edbi<\/title>\n<meta name=\"description\" content=\"H\u1ecdc l\u1eadp tr\u00ecnh VBA gi\u00fap trong Excel gi\u00fap b\u1ea1n t\u1ef1 \u0111\u1ed9ng h\u00f3a c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c giao m\u1ed9t c\u00e1ch nhanh nh\u1ea5t; thay v\u00ec d\u00f9ng ph\u01b0\u01a1ng ph\u00e1p truy\u1ec1n th\u1ed1ng\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"L\u1eadp tr\u00ecnh VBA trong Excel - C\u00e1c b\u01b0\u1edbc l\u1eadp tr\u00ecnh t\u1eeb A-Z cho ng\u01b0\u1eddi m\u1edbi\" \/>\n<meta property=\"og:description\" content=\"H\u1ecdc l\u1eadp tr\u00ecnh VBA gi\u00fap trong Excel gi\u00fap b\u1ea1n t\u1ef1 \u0111\u1ed9ng h\u00f3a c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c giao m\u1ed9t c\u00e1ch nhanh nh\u1ea5t; thay v\u00ec d\u00f9ng ph\u01b0\u01a1ng ph\u00e1p truy\u1ec1n th\u1ed1ng\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TekyAcademy\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-13T01:59:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-15T03:01:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/lap-trinh-VBA-e1647136498527.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"387\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Huy \u0110\u00e0m\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Huy \u0110\u00e0m\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"L\u1eadp tr\u00ecnh VBA trong Excel &#8211; C\u00e1c b\u01b0\u1edbc l\u1eadp tr\u00ecnh t\u1eeb A-Z\",\"datePublished\":\"2022-11-13T01:59:41+00:00\",\"dateModified\":\"2025-04-15T03:01:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/\"},\"wordCount\":1570,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/lap-trinh-VBA-e1647136498527.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/\",\"name\":\"L\u1eadp tr\u00ecnh VBA trong Excel - C\u00e1c b\u01b0\u1edbc l\u1eadp tr\u00ecnh t\u1eeb A-Z cho ng\u01b0\u1eddi m\u1edbi\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/lap-trinh-VBA-e1647136498527.jpg\",\"datePublished\":\"2022-11-13T01:59:41+00:00\",\"dateModified\":\"2025-04-15T03:01:15+00:00\",\"description\":\"H\u1ecdc l\u1eadp tr\u00ecnh VBA gi\u00fap trong Excel gi\u00fap b\u1ea1n t\u1ef1 \u0111\u1ed9ng h\u00f3a c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c giao m\u1ed9t c\u00e1ch nhanh nh\u1ea5t; thay v\u00ec d\u00f9ng ph\u01b0\u01a1ng ph\u00e1p truy\u1ec1n th\u1ed1ng\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/lap-trinh-VBA-e1647136498527.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/lap-trinh-VBA-e1647136498527.jpg\",\"width\":600,\"height\":387,\"caption\":\"L\u1eadp tr\u00ecnh VBA trong Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"L\u1eadp tr\u00ecnh VBA trong Excel &#8211; C\u00e1c b\u01b0\u1edbc l\u1eadp tr\u00ecnh t\u1eeb A-Z\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"description\":\"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh\",\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"width\":495,\"height\":234,\"caption\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/TekyAcademy\",\"https:\/\/x.com\/SteamTeky\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\",\"name\":\"Huy \u0110\u00e0m\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"caption\":\"Huy \u0110\u00e0m\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"L\u1eadp tr\u00ecnh VBA trong Excel - C\u00e1c b\u01b0\u1edbc l\u1eadp tr\u00ecnh t\u1eeb A-Z cho ng\u01b0\u1eddi m\u1edbi","description":"H\u1ecdc l\u1eadp tr\u00ecnh VBA gi\u00fap trong Excel gi\u00fap b\u1ea1n t\u1ef1 \u0111\u1ed9ng h\u00f3a c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c giao m\u1ed9t c\u00e1ch nhanh nh\u1ea5t; thay v\u00ec d\u00f9ng ph\u01b0\u01a1ng ph\u00e1p truy\u1ec1n th\u1ed1ng","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:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"L\u1eadp tr\u00ecnh VBA trong Excel - C\u00e1c b\u01b0\u1edbc l\u1eadp tr\u00ecnh t\u1eeb A-Z cho ng\u01b0\u1eddi m\u1edbi","og_description":"H\u1ecdc l\u1eadp tr\u00ecnh VBA gi\u00fap trong Excel gi\u00fap b\u1ea1n t\u1ef1 \u0111\u1ed9ng h\u00f3a c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c giao m\u1ed9t c\u00e1ch nhanh nh\u1ea5t; thay v\u00ec d\u00f9ng ph\u01b0\u01a1ng ph\u00e1p truy\u1ec1n th\u1ed1ng","og_url":"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/","og_site_name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","article_publisher":"https:\/\/www.facebook.com\/TekyAcademy","article_published_time":"2022-11-13T01:59:41+00:00","article_modified_time":"2025-04-15T03:01:15+00:00","og_image":[{"width":600,"height":387,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/lap-trinh-VBA-e1647136498527.jpg","type":"image\/jpeg"}],"author":"Huy \u0110\u00e0m","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Huy \u0110\u00e0m","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"7 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"L\u1eadp tr\u00ecnh VBA trong Excel &#8211; C\u00e1c b\u01b0\u1edbc l\u1eadp tr\u00ecnh t\u1eeb A-Z","datePublished":"2022-11-13T01:59:41+00:00","dateModified":"2025-04-15T03:01:15+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/"},"wordCount":1570,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/lap-trinh-VBA-e1647136498527.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/","name":"L\u1eadp tr\u00ecnh VBA trong Excel - C\u00e1c b\u01b0\u1edbc l\u1eadp tr\u00ecnh t\u1eeb A-Z cho ng\u01b0\u1eddi m\u1edbi","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/lap-trinh-VBA-e1647136498527.jpg","datePublished":"2022-11-13T01:59:41+00:00","dateModified":"2025-04-15T03:01:15+00:00","description":"H\u1ecdc l\u1eadp tr\u00ecnh VBA gi\u00fap trong Excel gi\u00fap b\u1ea1n t\u1ef1 \u0111\u1ed9ng h\u00f3a c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c giao m\u1ed9t c\u00e1ch nhanh nh\u1ea5t; thay v\u00ec d\u00f9ng ph\u01b0\u01a1ng ph\u00e1p truy\u1ec1n th\u1ed1ng","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/lap-trinh-VBA-e1647136498527.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/03\/lap-trinh-VBA-e1647136498527.jpg","width":600,"height":387,"caption":"L\u1eadp tr\u00ecnh VBA trong Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/lap-trinh-vba-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"L\u1eadp tr\u00ecnh VBA trong Excel &#8211; C\u00e1c b\u01b0\u1edbc l\u1eadp tr\u00ecnh t\u1eeb A-Z"}]},{"@type":"WebSite","@id":"https:\/\/teky.edu.vn\/blog\/#website","url":"https:\/\/teky.edu.vn\/blog\/","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","description":"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh","publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/teky.edu.vn\/blog\/#organization","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","url":"https:\/\/teky.edu.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","width":495,"height":234,"caption":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TekyAcademy","https:\/\/x.com\/SteamTeky"]},{"@type":"Person","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c","name":"Huy \u0110\u00e0m","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","caption":"Huy \u0110\u00e0m"},"url":"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11390","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=11390"}],"version-history":[{"count":2,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11390\/revisions"}],"predecessor-version":[{"id":24895,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/11390\/revisions\/24895"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/11409"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=11390"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=11390"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=11390"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}