{"id":10512,"date":"2025-01-14T11:50:59","date_gmt":"2025-01-14T11:50:59","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/cach-gan-macro-vao-bieu-tuong-nut-dieu-khien-tao-boi-shapes-trong-excel\/"},"modified":"2025-01-14T11:50:59","modified_gmt":"2025-01-14T11:50:59","slug":"cach-gan-macro-vao-bieu-tuong-nut-dieu-khien-tao-boi-shapes-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/cach-gan-macro-vao-bieu-tuong-nut-dieu-khien-tao-boi-shapes-trong-excel\/","title":{"rendered":"C\u00e1ch g\u00e1n macro v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng n\u00fat \u0111i\u1ec1u khi\u1ec3n t\u1ea1o b\u1edfi Shapes trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Ch\u1eafc h\u1eb3n b\u1ea1n \u0111\u00e3 r\u1ea5t m\u1eebng khi b\u1eaft \u0111\u1ea7u vi\u1ebft \u0111\u01b0\u1ee3c 1 macro trong VBA Excel. Nh\u01b0ng b\u1ea1n\u00a0l\u1ea1i b\u0103n kho\u0103n kh\u00f4ng bi\u1ebft l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u00f3 th\u1ec3 ch\u1ee7 \u0111\u1ed9ng \u0111i\u1ec1u khi\u1ec3n cho ph\u00e9p ch\u1ea1y macro khi l\u00e0m vi\u1ec7c tr\u00ean Excel? Hay n\u00f3i c\u00e1ch kh\u00e1c l\u00e0 ch\u1ec9 c\u1ea7n b\u1ea5m v\u00e0o 1 n\u00fat, 1 bi\u1ec3u t\u01b0\u1ee3ng \u0111\u01b0\u1ee3c th\u00eam v\u00e0o b\u1edfi m\u1ee5c Shapes l\u00e0 ch\u00fang ta c\u00f3 th\u1ec3 ch\u1ea1y \u0111\u01b0\u1ee3c c\u00e2u l\u1ec7nh Macro mong mu\u1ed1n? H\u00e3y c\u00f9ng H\u1ecdc Excel Online t\u00ecm hi\u1ec3u c\u00e1ch g\u00e1n macro v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng\u00a0n\u00fat \u0111i\u1ec1u khi\u1ec3n t\u1ea1o b\u1edfi Shapes trong Excel nh\u00e9:<\/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-67864fa2af244\" 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\/cach-gan-macro-vao-bieu-tuong-nut-dieu-khien-tao-boi-shapes-trong-excel.html#1_Nhung_luu_y_khi_bat_dau\" title=\"1.\u00a0Nh\u1eefng l\u01b0u \u00fd khi b\u1eaft \u0111\u1ea7u\">1.\u00a0Nh\u1eefng l\u01b0u \u00fd khi b\u1eaft \u0111\u1ea7u<\/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\/cach-gan-macro-vao-bieu-tuong-nut-dieu-khien-tao-boi-shapes-trong-excel.html#2_Ve_hoac_them_bieu_tuong_nut_dieu_khien_tao_boi_Shapes\" title=\"2. V\u1ebd ho\u1eb7c th\u00eam\u00a0bi\u1ec3u t\u01b0\u1ee3ng n\u00fat \u0111i\u1ec1u khi\u1ec3n t\u1ea1o b\u1edfi Shapes\">2. V\u1ebd ho\u1eb7c th\u00eam\u00a0bi\u1ec3u t\u01b0\u1ee3ng n\u00fat \u0111i\u1ec1u khi\u1ec3n t\u1ea1o b\u1edfi Shapes<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-gan-macro-vao-bieu-tuong-nut-dieu-khien-tao-boi-shapes-trong-excel.html#3_Cach_gan_macro_vao_bieu_tuong_nut_dieu_khien\" title=\"3. C\u00e1ch g\u00e1n macro v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng n\u00fat \u0111i\u1ec1u khi\u1ec3n\">3. C\u00e1ch g\u00e1n macro v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng n\u00fat \u0111i\u1ec1u khi\u1ec3n<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"1_Nhung_luu_y_khi_bat_dau\"><\/span>1.\u00a0Nh\u1eefng l\u01b0u \u00fd khi b\u1eaft \u0111\u1ea7u<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>L\u01b0u \u00fd \u0111\u1ea7u ti\u00ean \u0111\u00f3 l\u00e0 file Excel c\u1ee7a ch\u00fang ta \u0111\u00e3 c\u00f3 s\u1eed d\u1ee5ng macro, n\u00ean c\u1ea7n l\u01b0u file d\u01b0\u1edbi \u0111\u1ecbnh d\u1ea1ng cho ph\u00e9p s\u1eed d\u1ee5ng macro. B\u1edfi n\u1ebfu kh\u00f4ng th\u00ec b\u1ea1n c\u00f3 th\u1ec3 m\u1ea5t h\u1ebft to\u00e0n b\u1ed9 c\u00f4ng s\u1ee9c m\u00e0 kh\u00f4ng th\u1ec3 l\u1ea5y l\u1ea1i \u0111\u01b0\u1ee3c.<\/p>\n<p style=\"padding-left: 30px\">T\u00ecm hi\u1ec3u \u1edf b\u00e0i vi\u1ebft:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-luu-file-excel-khong-bi-mat-macro-vba-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u01b0u file excel kh\u00f4ng b\u1ecb m\u1ea5t macro VBA excel<\/a><\/p>\n<p>L\u01b0u \u00fd ti\u1ebfp theo l\u00e0 ch\u00fang ta c\u1ea7n c\u00f3 s\u1eb5n 1 macro trong Module.\u00a0Trong file \u0111\u00ednh k\u00e8m theo b\u00e0i vi\u1ebft n\u00e0y c\u00f3 s\u1eb5n 1 macro \u0111\u1ec3 c\u00e1c b\u1ea1n \u00e1p d\u1ee5ng. C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i v\u1ec1 file m\u1eabu t\u1ea1i \u0111\u1ecba ch\u1ec9:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Ve_hoac_them_bieu_tuong_nut_dieu_khien_tao_boi_Shapes\"><\/span>2. V\u1ebd ho\u1eb7c th\u00eam\u00a0bi\u1ec3u t\u01b0\u1ee3ng n\u00fat \u0111i\u1ec1u khi\u1ec3n t\u1ea1o b\u1edfi Shapes<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong Excel c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 v\u1ebd (ho\u1eb7c ch\u00e8n th\u00eam) bi\u1ec3u t\u01b0\u1ee3ng n\u00fat \u0111i\u1ec1u khi\u1ec3n trong m\u1ee5c Shapes nh\u01b0 sau:<\/p>\n<p>Trong th\u1ebb Insert ch\u1ecdn m\u1ee5c Shapes:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19026\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/cach-them-1-shapes-trong-excel.png\" width=\"669\" height=\"257\" title=\"cach-them-1-shapes-trong-excel\"><\/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\/2025\/01\/ex101_92019-nho-181.gif\" title=\"ex101_92019-nho-181\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Bi\u1ec3u t\u01b0\u1ee3ng n\u00fat \u0111i\u1ec1u khi\u1ec3n th\u01b0\u1eddng n\u1eb1m \u1edf m\u1ee5c Rectangles (h\u00ecnh ch\u1eef nh\u1eadt)<\/p>\n<p>Ch\u1ecdn 1 h\u00ecnh r\u1ed3i v\u1ebd v\u00e0o trong Sheet \u0111ang l\u00e0m vi\u1ec7c<\/p>\n<p>Sau khi v\u1ebd ra h\u00ecnh \u0111\u00f3 r\u1ed3i th\u00ec ch\u00fang ta s\u1ebd \u0111\u1ecbnh d\u1ea1ng l\u1ea1i c\u00e1c n\u1ed9i dung: M\u00e0u s\u1eafc, Font ch\u1eef, k\u00edch c\u1ee1, nh\u1eadp Text\u2026<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19027\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/format-shapes-excel.png\" width=\"603\" height=\"335\" title=\"format-shapes-excel\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_Cach_gan_macro_vao_bieu_tuong_nut_dieu_khien\"><\/span>3. C\u00e1ch g\u00e1n macro v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng n\u00fat \u0111i\u1ec1u khi\u1ec3n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o n\u00fat bi\u1ec3u t\u01b0\u1ee3ng v\u00e0 ch\u1ecdn m\u1ee5c Assign Macro<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19028\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/shapes-assign-macro-gan-macro-vao-shapes.png\" width=\"379\" height=\"528\" title=\"shapes-assign-macro-gan-macro-vao-shapes\"><\/p>\n<p>Trong c\u1eeda s\u1ed5 Assign Macro ch\u00fang ta s\u1ebd ch\u1ecdn Macro mu\u1ed1n g\u00e1n r\u1ed3i b\u1ea5m OK<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19038\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/gan-macro-vao-shape.png\" width=\"594\" height=\"367\" title=\"gan-macro-vao-shape\"><\/p>\n<p>Sau khi\u00a0g\u00e1n macro qua thao t\u00e1c Assign Macro\u00a0xong\u00a0ch\u00fang ta ch\u1ec9 c\u1ea7n b\u1ea5m v\u00e0o n\u00fat bi\u1ec3u t\u01b0\u1ee3ng\u00a0\u0111\u1ec3 g\u1ecdi ra macro\u00a0\u0111\u00f3.<\/p>\n<p>\u0110\u1ec3 t\u00ecm hi\u1ec3u th\u00eam nhi\u1ec1u ki\u1ebfn th\u1ee9c v\u1ec1 VBA, m\u1eddi b\u1ea1n tham d\u1ef1 kh\u00f3a h\u1ecdc\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><strong>VBA101 \u2013 T\u1ef1\u00a0\u0111\u1ed9ng h\u00f3a\u00a0Excel v\u1edbi l\u1eadp tr\u00ecnh VBA<\/strong><\/a>.\u00a0\u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc r\u1ea5t h\u1eefu\u00a0\u00edch d\u00e0nh cho b\u1ea1n: Ngo\u00e0i ki\u1ebfn th\u1ee9c v\u1ec1 k\u1ef9 thu\u1eadt b\u1eaby l\u1ed7i trong VBA ch\u00fang ta c\u00f2n \u0111\u01b0\u1ee3c h\u1ecdc th\u00eam r\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c kh\u00e1c v\u1ec1 VBA, \u1ee9ng d\u1ee5ng VBA v\u00e0o c\u00f4ng vi\u1ec7c. H\u00e3y c\u00f9ng kh\u00e1m ph\u00e1 n\u00e0o:<\/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\/2025\/01\/ex101_92019-nho-181.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10513,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10512","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\/10512","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=10512"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10512\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10513"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10512"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10512"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10512"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}