{"id":3866,"date":"2024-12-03T09:48:40","date_gmt":"2024-12-03T09:48:40","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/cach-hien-the-developer-de-ghi-macro-hoac-viet-code-vba-trong-excel\/"},"modified":"2024-12-03T09:48:40","modified_gmt":"2024-12-03T09:48:40","slug":"cach-hien-the-developer-de-ghi-macro-hoac-viet-code-vba-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/cach-hien-the-developer-de-ghi-macro-hoac-viet-code-vba-trong-excel\/","title":{"rendered":"C\u00e1ch hi\u1ec7n th\u1ebb Developer \u0111\u1ec3 ghi Macro ho\u1eb7c vi\u1ebft code VBA trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>C\u00f2n nhi\u1ec1u b\u1ea1n th\u1eafc m\u1eafc v\u00ec sao kh\u00f4ng th\u1ec3 <strong>hi\u1ec7n th\u1ebb Developer<\/strong> trong Excel, sau \u0111\u00e2y\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a>\u00a0<\/strong>se\u0303 h\u01b0\u1edbng d\u1eabn\u00a0c\u00e1c b\u1ea1n ca\u0301ch c\u00f3 th\u1ec3 cho hi\u1ec7n th\u1ebb Developer trong phi\u00ean b\u1ea3n Excel c\u1ee7a m\u00ecnh. Trong Excel, c\u00e1c b\u1ea1n b\u1ea5m v\u00e0o th\u1ebb <strong>File<\/strong> &gt; <strong>Options\u00a0<\/strong>sau \u0111\u00f3 l\u00e0m nh\u01b0 sau:<\/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-674ed3f80b0ff\" 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-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-hien-developer-de-ghi-macro-hoac-viet-code-vba-trong-excel.html#Mo_the_Developer_trong_Excel_2016_Excel_2013_Excel_2010\" title=\"M\u1edf th\u1ebb Developer trong Excel 2016, Excel 2013, Excel 2010\">M\u1edf th\u1ebb Developer trong Excel 2016, Excel 2013, Excel 2010<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-hien-developer-de-ghi-macro-hoac-viet-code-vba-trong-excel.html#Mo_the_Visual_Basic_Control_Toolbox_trong_Office_2003\" title=\"M\u1edf th\u1ebb Visual Basic, Control Toolbox trong Office 2003\">M\u1edf th\u1ebb Visual Basic, Control Toolbox trong Office 2003<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-hien-developer-de-ghi-macro-hoac-viet-code-vba-trong-excel.html#Mo_Excel_Options_trong_Excel_2007\" title=\"M\u1edf Excel Options trong Excel 2007\">M\u1edf Excel Options trong Excel 2007<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cach-hien-developer-de-ghi-macro-hoac-viet-code-vba-trong-excel.html#Mo_the_developer_trong_Excel_2007\" title=\"M\u1edf th\u1ebb developer trong Excel 2007\">M\u1edf th\u1ebb developer trong Excel 2007<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cach-hien-developer-de-ghi-macro-hoac-viet-code-vba-trong-excel.html#Doi_voi_may_MacOS_ban_vao_theo_huong_dan_sau\" title=\"\u0110\u1ed1i v\u1edbi m\u00e1y MacOS, b\u1ea1n v\u00e0o theo h\u01b0\u1edbng d\u1eabn sau:\">\u0110\u1ed1i v\u1edbi m\u00e1y MacOS, b\u1ea1n v\u00e0o theo h\u01b0\u1edbng d\u1eabn sau:<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Mo_the_Developer_trong_Excel_2016_Excel_2013_Excel_2010\"><\/span><strong>M\u1edf th\u1ebb Developer trong Excel 2016, Excel 2013, Excel 2010<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>M\u1edf th\u1ebb Developer c\u0169ng \u0111\u01b0\u1ee3c coi nh\u01b0 l\u00e0 vi\u1ec7c m\u1edf VBA trong Excel v\u1eady, v\u00ec khi kh\u00f4ng m\u1edf \u0111\u01b0\u1ee3c th\u1ec3 n\u00e0y b\u1ea1n s\u1ebd kh\u00f4ng th\u1ec3 n\u00e0o nh\u1eadp code \u0111\u01b0\u1ee3c.<\/p>\n<figure id=\"attachment_2855\" aria-describedby=\"caption-attachment-2855\" style=\"width: 1016px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/artboard-5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2855\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/artboard-5.png\" alt=\"m\u1edf th\u1ebb developer trong excel\" width=\"1016\" height=\"679\" title=\"artboard-5\"><\/a><figcaption id=\"caption-attachment-2855\" class=\"wp-caption-text\">M\u1edf th\u1ebb Developer trong excel<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Mo_the_Visual_Basic_Control_Toolbox_trong_Office_2003\"><\/span><b>M\u1edf th\u1ebb Visual Basic, Control Toolbox trong Office 2003<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Kh\u00e1c v\u1edbi Office phi\u00ean b\u1ea3n m\u1edbi, Office 2003 s\u1ebd c\u00f3 c\u00e1c thanh Toolbar ri\u00eang bi\u1ec7t. B\u1ea1n c\u1ea7n ch\u1ecdn menu <strong>View<\/strong> =&gt; Ch\u1ecdn <strong>Toolbar<\/strong> =&gt; Ch\u1ecdn ti\u1ebfp <strong>Visual Basic<\/strong>, v\u00e0 <strong>Control Toolbox<\/strong>. (ho\u1eb7c click ph\u1ea3i v\u00e0o thanh toolbar \u0111\u1ec3 ch\u1ecdn t\u01b0\u01a1ng \u1ee9ng).<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/02\/Hien-thanh-Visual-Basic-Control-box-trong-Office-2003.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-26137\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/hien-thanh-visual-basic-control-box-trong-office-2003.jpg\" width=\"1163\" height=\"605\" title=\"hien-thanh-visual-basic-control-box-trong-office-2003\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Mo_Excel_Options_trong_Excel_2007\"><\/span><strong>M\u1edf Excel Options trong Excel 2007<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00e1ch m\u1edf VBA trong Excel 2007<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Mo_the_developer_trong_Excel_2007\"><\/span><strong>M\u1edf th\u1ebb developer trong Excel 2007<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-2007-show-the-developer-tab.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2858 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-2007-show-the-developer-tab.png\" alt=\"m\u1edf th\u1ebb developer trong excel 2007\" width=\"603\" height=\"288\" title=\"excel-2007-show-the-developer-tab\"><\/a><\/p>\n<p>\u00a0<\/p>\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-306.gif\" title=\"ex101_92019-nho-306\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Doi_voi_may_MacOS_ban_vao_theo_huong_dan_sau\"><\/span><strong>\u0110\u1ed1i v\u1edbi m\u00e1y MacOS, b\u1ea1n v\u00e0o theo h\u01b0\u1edbng d\u1eabn sau:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ol type=\"1\">\n<li>\u1ede ph\u1ea7n <strong>Excel<\/strong> Menu, ch\u1ecdn\u00a0<b class=\"ocpUI\">Preferences<\/b>.<\/li>\n<li>\u1ede ph\u1ea7n\u00a0<b class=\"ocpUI\">Authoring and Proofing Tools<\/b>, ch\u1ecdn\u00a0<b class=\"ocpUI\">View<\/b>.<\/li>\n<li>\n<p class=\"\">Ph\u1ea7n d\u01b0\u1edbi\u00a0<b class=\"ocpUI\">Ribbon<\/b>,\u00a0ch\u1ecdn [x]\u00a0<b class=\"ocpUI\">Show Developer tab<\/b>.<\/p>\n<\/li>\n<\/ol>\n<p>Ri\u00eang v\u1edbi Office 2016 tr\u00ean m\u00e1y MacOS, c\u00e1c b\u1ea1n v\u00e0o theo \u0111\u01b0\u1eddng d\u1eabn sau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/02\/office-2016-macos.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-24775 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/office-2016-macos.jpg\" width=\"1062\" height=\"660\" title=\"office-2016-macos\"><\/a><\/p>\n<p>\u0110\u1ebfn \u0111\u00e2y b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 b\u1eaft \u0111\u1ea7u t\u00ecm hi\u1ec3u\u00a0nh\u1eefng\u00a0\u0111i\u1ec1u th\u00fa v\u1ecb c\u1ee7a VBA \u0111\u01b0\u1ee3c r\u1ed3i. VBA\u00a0gi\u00fap \u00edch\u00a0r\u1ea5t nhi\u1ec1u trong c\u00f4ng vi\u1ec7c: gi\u00fap b\u1ea1n t\u0103ng t\u1ed1c trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd tr\u00ean Excel, gi\u00fap l\u1eadp c\u00e1c b\u00e1o c\u00e1o t\u1ef1 \u0111\u1ed9ng, \u0111i\u1ec1u khi\u1ec3n c\u00e1c ch\u01b0\u01a1ng tr\u00ecnh kh\u00e1c nh\u01b0 Word, Power Point, Outlook\u2026 gi\u00fap bi\u1ebfn file Excel c\u1ee7a b\u1ea1n tr\u1edf th\u00e0nh 1 ph\u1ea7n m\u1ec1m chuy\u00ean nghi\u1ec7p\u2026<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 h\u1ecdc VBA m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, c\u00f3 h\u1ec7 th\u1ed1ng, b\u1ea1n h\u00e3y tham gia kho\u00e1 h\u1ecdc\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\">VBA101 \u2013 VBA c\u01a1 b\u1ea3n d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u<\/a> c\u1ee7a h\u1ec7 th\u1ed1ng H\u1ecdc Excel Online. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i khi b\u1ea1n \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y. Chi ti\u1ebft xem t\u1ea1i: VBA101 \u2013 VBA c\u01a1 b\u1ea3n d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u<\/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\/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-306.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3867,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-3866","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\/3866","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=3866"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3866\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3867"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3866"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3866"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3866"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}