{"id":8577,"date":"2024-12-22T14:57:17","date_gmt":"2024-12-22T14:57:17","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/gioi-thieu-ve-macro-trong-excel-windows\/"},"modified":"2024-12-22T14:57:17","modified_gmt":"2024-12-22T14:57:17","slug":"gioi-thieu-ve-macro-trong-excel-windows","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/gioi-thieu-ve-macro-trong-excel-windows\/","title":{"rendered":"Gi\u1edbi thi\u1ec7u v\u1ec1 Macro trong Excel (Windows)"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p><em>Ch\u1eafc h\u1eb3n b\u1ea5t c\u1ee9 ai s\u1eed d\u1ee5ng Excel \u0111\u1ec1u \u0111\u00e3 t\u1eebng nghe t\u1edbi c\u1ee5m t\u1eeb \u201cMacro\u201d. V\u1eady Macro trong Excel l\u00e0 g\u00ec, c\u00f3 t\u00e1c d\u1ee5ng ra sao? H\u00e3y \u0111\u1ecdc b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y c\u1ee7a <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> \u0111\u1ec3 t\u00ecm hi\u1ec3u.<\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-676828cc95a29\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/gioi-thieu-macro-trong-excel.html#Macro_%E2%80%93_trinh_tu_dong_mo_phong_tac_vu_nguoi_dung_trong_Excel\" title=\"Macro \u2013 tr\u00ecnh t\u1ef1 \u0111\u1ed9ng m\u00f4 ph\u1ecfng t\u00e1c v\u1ee5 ng\u01b0\u1eddi d\u00f9ng trong Excel\">Macro \u2013 tr\u00ecnh t\u1ef1 \u0111\u1ed9ng m\u00f4 ph\u1ecfng t\u00e1c v\u1ee5 ng\u01b0\u1eddi d\u00f9ng trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/gioi-thieu-macro-trong-excel.html#Ghi_macro_trong_Windows\" title=\"Ghi macro trong Windows\">Ghi macro trong Windows<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/gioi-thieu-macro-trong-excel.html#Macro_trong_Windows\" title=\"Macro trong Windows\">Macro trong Windows<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/gioi-thieu-macro-trong-excel.html#Ghi_mot_macro_trong_Excel\" title=\"Ghi m\u1ed9t macro trong Excel\">Ghi m\u1ed9t macro trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/gioi-thieu-macro-trong-excel.html#Lam_viec_voi_Macro_trong_Excel\" title=\"L\u00e0m vi\u1ec7c v\u1edbi Macro trong Excel\">L\u00e0m vi\u1ec7c v\u1edbi Macro trong Excel<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Macro_%E2%80%93_trinh_tu_dong_mo_phong_tac_vu_nguoi_dung_trong_Excel\"><\/span>Macro \u2013 tr\u00ecnh t\u1ef1 \u0111\u1ed9ng m\u00f4 ph\u1ecfng t\u00e1c v\u1ee5 ng\u01b0\u1eddi d\u00f9ng trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Macro l\u00e0 m\u1ed9t chu\u1ed7i t\u1ef1 \u0111\u1ed9ng\u00a0 \u0111\u01b0\u1ee3c nh\u1eadp v\u00e0o, m\u00f4 ph\u1ecfng thao t\u00e1c g\u00f5 ph\u00edm ho\u1eb7c thao t\u00e1c v\u1edbi chu\u1ed9t c\u1ee7a ng\u01b0\u1eddi d\u00f9ng.\u00a0M\u1ed9t macro th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 thay th\u1ebf m\u1ed9t lo\u1ea1t c\u00e1c h\u00e0nh \u0111\u1ed9ng l\u1eb7p \u0111i l\u1eb7p l\u1ea1i v\u00e0 ph\u1ed5 bi\u1ebfn trong vi\u1ec7c x\u1eed l\u00fd b\u1ea3ng t\u00ednh. Ch\u1eb3ng h\u1ea1n b\u1ea1n c\u00f3 th\u1ec3 ghi m\u1ed9t \u0111\u1ecbnh d\u1ea1ng v\u00e0 sau \u0111\u00f3 l\u1eb7p l\u1ea1i \u1edf b\u1ea5t c\u1ee9 \u0111\u00e2u b\u1eb1ng m\u1ed9t thao t\u00e1c ch\u1ea1y b\u1ed9 ghi.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ghi_macro_trong_Windows\"><\/span>Ghi macro trong Windows<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"Macro_trong_Windows\"><\/span>Macro trong Windows<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>M\u1ed9t <strong>macro<\/strong> s\u1ebd ghi l\u1ea1i to\u00e0n b\u1ed9 nh\u1eefng b\u01b0\u1edbc thao t\u00e1c v\u00e0 th\u1ec3 hi\u1ec7n qua code Visual Basic for Applications (VBA). Nh\u1eefng b\u01b0\u1edbc thao t\u00e1c n\u00e0y c\u00f3 th\u1ec3 bao g\u1ed3m\u00a0<strong>nh\u1eadp ch\u1eef ho\u1eb7c s\u1ed1<\/strong>,\u00a0<strong>ch\u1ecdn \u00f4<\/strong><strong>, ch\u1ecdn l\u1ec7nh trong thanh ribbon<\/strong>\u00a0<strong>hay trong menu<\/strong>,\u00a0<strong>\u0111\u1ecbnh d\u1ea1ng \u00f4, \u0111\u1ecbnh d\u1ea1ng c\u1ed9t\/h\u00e0ng, import d\u1eef li\u1ec7u t\u1eeb ngu\u1ed3n ngo\u00e0i nh\u01b0 Access\u2026<\/strong> VBA l\u00e0 m\u1ed9t ph\u1ea7n t\u1eed c\u1ee7a b\u1ed9 ng\u00f4n ng\u1eef l\u1eadp tr\u00ecnh Visual Basic \u0111\u01b0\u1ee3c t\u00edch h\u1ee3p v\u00e0o h\u1ea7u h\u1ebft c\u00e1c \u1ee9ng d\u1ee5ng Office. M\u1eb7c d\u00f9 VBA cung c\u1ea5p cho b\u1ea1n kh\u1ea3 n\u0103ng t\u1ef1 \u0111\u1ed9ng h\u00f3a c\u00e1c thao t\u00e1c \u0111\u1ed1i v\u1edbi c\u00e1c \u1ee9ng d\u1ee5ng Office, \u0111\u00f4i khi ta kh\u00f4ng c\u1ea7n thi\u1ebft ph\u1ea3i s\u1eed d\u1ee5ng \u0111\u1ebfn n\u1ebfu tr\u00ecnh ghi Macro c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111i\u1ec1u \u0111\u00f3 h\u1ed9 b\u1ea1n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27537\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bo-ghi-macro-1.jpg\" width=\"900\" height=\"440\" title=\"bo-ghi-macro-1\"><\/p>\n<p>M\u1ed9t \u0111i\u1ec1u quan tr\u1ecdng b\u1ea1n c\u1ea7n bi\u1ebft \u0111\u00f3 l\u00e0 khi ghi m\u1ed9t <strong>macro<\/strong>, tr\u00ecnh ghi s\u1ebd ghi l\u1ea1i h\u1ea7u h\u1ebft t\u1ea5t c\u1ea3 nh\u1eefng thao t\u00e1c b\u1ea1n th\u1ef1c hi\u1ec7n, ch\u1eb3ng h\u1ea1n nh\u01b0 d\u00f9 b\u1ea1n c\u00f3 click nh\u1ea7m v\u00e0o m\u1ed9t n\u00fat n\u00e0o \u0111\u00f3. Gi\u1ea3i ph\u00e1p cho \u0111i\u1ec1u \u0111\u00f3 l\u00e0 ghi l\u1ea1i m\u1ed9t macro m\u1edbi, ho\u1eb7c ch\u1ec9nh s\u1eeda code VBA. \u0110\u00e2y c\u0169ng l\u00e0 l\u00fd do khi b\u1ea1n ghi m\u1ed9t thao t\u00e1c n\u00e0o \u0111\u00f3, t\u1ed1t nh\u1ea5t h\u00e3y l\u00e0m vi\u1ec7c v\u1edbi nh\u1eefng th\u1ee9 quen thu\u1ed9c. C\u00e0ng quen c\u00e0ng t\u1ed1t.<\/p>\n<p>Macro v\u00e0 c\u00e1c c\u00f4ng c\u1ee5 VBA c\u00f3 th\u1ec3 t\u00ecm th\u1ea5y trong <a href=\"http:\/\/blog.ezworkapp.com\/cach-hien-developer-de-ghi-macro-hoac-viet-code-vba-trong-excel.html\"><strong>th\u1ebb\u00a0Developer<\/strong><\/a>. V\u1ec1 m\u1eb7c \u0111\u1ecbnh th\u1ebb n\u00e0y b\u1ecb \u1ea9n \u0111i, b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00e1ch hi\u1ec7n th\u1ebb<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27541\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bo-ghi-macro-2.png\" width=\"826\" height=\"126\" title=\"bo-ghi-macro-2\"><\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-350.gif\" title=\"vba101_92019-nho-350\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-791.gif\" title=\"ex101_92019-nho-791\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h4><span class=\"ez-toc-section\" id=\"Ghi_mot_macro_trong_Excel\"><\/span>Ghi m\u1ed9t macro trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>M\u1ed9t s\u1ed1 tip h\u1eefu d\u1ee5ng sau \u0111\u00e2y v\u1ec1 macro m\u00e0 b\u1ea1n n\u00ean bi\u1ebft:<\/p>\n<ul>\n<li>Khi b\u1ea1n ghi m\u1ed9t b\u1ea3n ghi \u0111\u1ec3 l\u00e0m m\u1ed9t s\u1ed1 t\u00e1c v\u1ee5, Excel s\u1ebd ch\u1ec9 ch\u1ea1y t\u00e1c v\u1ee5 \u0111\u00f3 trong v\u00f9ng \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh s\u1eb5n. \u0110i\u1ec1u n\u00e0y c\u00f3 ngh\u0129a l\u00e0 n\u1ebfu b\u1ea1n th\u00eam h\u00e0ng\/c\u1ed9t v\u00e0o trong v\u00f9ng \u0111\u00e3 ghi, macro s\u1ebd kh\u00f4ng ch\u1ea1y thao t\u00e1c cho v\u00f9ng m\u1edbi th\u00eam v\u00e0o.<\/li>\n<li>N\u1ebfu b\u1ea1n mu\u1ed1n x\u1eed l\u00fd m\u1ed9t t\u00e1c v\u1ee5 d\u00e0i, h\u00e3y chia th\u00e0nh nh\u1eefng b\u1ea3n ghi nh\u1ecf h\u01a1n thay v\u00ec m\u1ed9t b\u1ea3n ghi l\u1edbn.<\/li>\n<li>Macro kh\u00f4ng ch\u1ec9 \u00e1p d\u1ee5ng trong ph\u1ea1m vi Excel. B\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o m\u1ed9t b\u1ea3n ghi li\u00ean k\u1ebft t\u1edbi c\u00e1c \u1ee9ng d\u1ee5ng Office kh\u00e1c c\u00f3 h\u1ed7 tr\u1ee3 VBA. Ch\u1eb3ng h\u1ea1n nh\u01b0 ghi m\u1ed9t macro \u0111\u1ec3 t\u1ea1o b\u1ea3ng trong Excel, sau \u0111\u00f3 \u0111\u01b0a v\u00e0o Outlook \u0111\u1ec3 g\u1eedi t\u1edbi \u0111\u1ecba ch\u1ec9 trong b\u1ea3ng.<\/li>\n<\/ul>\n<p>\u0110\u1ec3 ghi ta l\u00e0m nh\u01b0 sau:<\/p>\n<ol>\n<li>Trong th\u1ebb\u00a0<strong>Developer<\/strong>, nh\u00f3m\u00a0<strong>Code<\/strong>, ch\u1ecdn\u00a0<strong>Record Macro<\/strong><\/li>\n<li>Trong m\u1ee5c\u00a0<strong>Macro name<\/strong>, \u0111i\u1ec1n t\u00ean theo \u00fd mu\u1ed1n. L\u01b0u \u00fd h\u00e3y \u0111\u1eb7t m\u1ed9t c\u00e1i t\u00ean li\u00ean quan t\u1edbi t\u00e1c v\u1ee5 v\u1eadn h\u00e0nh nh\u00e9.<\/li>\n<li>\u0110\u1ec3 li\u00ean k\u1ebft v\u1edbi m\u1ed9t t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft, trong m\u1ee5c\u00a0<strong>Shortcut key<\/strong>, d\u00f9ng b\u1ea5t c\u1ee9 ph\u00edm n\u00e0o theo \u00fd mu\u1ed1n.\u00a0 V\u00e0 khi ph\u00edm t\u1eaft n\u00e0y tr\u00f9ng v\u1edbi c\u00e1c ph\u00edm t\u1eaft m\u1eb7c \u0111\u1ecbnh, ch\u1eb3ng h\u1ea1n nh\u01b0\u00a0<strong>Ctrl + Z<\/strong>, b\u1ea1n s\u1ebd m\u1ea5t \u0111i t\u00ednh n\u0103ng\u00a0<strong>Ctrl + Z c\u00f3<\/strong> <strong>s\u1eb5n trong Excel\u00a0(Undo)<\/strong>.<\/li>\n<li>T\u1ea1i\u00a0<strong>Store macro in<\/strong>, ch\u1ecdn v\u1ecb tr\u00ed b\u1ea1n mu\u1ed1n \u0111\u1eb7t b\u1ea3n ghi.<\/li>\n<li>Trong m\u1ee5c\u00a0<strong>Description<\/strong>, ghi nh\u1eefng ghi ch\u00fa v\u1ec1 b\u1ea3n ghi.<\/li>\n<li>Click\u00a0<strong>OK\u00a0<\/strong>\u0111\u1ec3 b\u1eaft \u0111\u1ea7u.<\/li>\n<li>\u0110\u1ec3 ng\u1eebng vi\u1ec7c ghi, v\u00e0o l\u1ea1i th\u1ebb <strong>Developer<\/strong>,\u00a0nh\u00f3m\u00a0<strong>Code<\/strong> v\u00e0 ch\u1ecdn\u00a0<strong>Stop Recording.<\/strong><\/li>\n<\/ol>\n<h4><span class=\"ez-toc-section\" id=\"Lam_viec_voi_Macro_trong_Excel\"><\/span>L\u00e0m vi\u1ec7c v\u1edbi Macro trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Trong th\u1ebb\u00a0<strong>Developer<\/strong>, click\u00a0<strong>Macros<\/strong> \u0111\u1ec3 xem nh\u1eefng b\u1ea3n ghi. Ta c\u00f3 th\u1ec3 thao t\u00e1c nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-27542\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bo-ghi-macro-3.png\" width=\"512\" height=\"375\" title=\"bo-ghi-macro-3\"><\/p>\n<p>L\u01b0u \u00fd: File ch\u1ee9a macro ph\u1ea3i \u0111\u01b0\u1ee3c l\u01b0u d\u01b0\u1edbi d\u1ea1ng Excel Macro-Enabled Workbook (.xlsm)<\/p>\n<hr>\n<p>T\u00ecm hi\u1ec3u th\u00eam v\u1ec1 VBA qua nh\u1eefng b\u00e0i vi\u1ebft sau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/vba101-landing.html\"><strong>Kh\u00f3a VBA101 \u2013 VBA cho ng\u01b0\u1eddi m\u1edbi<\/strong><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/form-nhap-du-lieu-co-ban-voi-vba-trong-excel.html\"><strong>Form nh\u1eadp li\u1ec7u c\u01a1 b\u1ea3n v\u1edbi VBA<\/strong><\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-350.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8578,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-8577","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8577","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=8577"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8577\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8578"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8577"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8577"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8577"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}