{"id":522,"date":"2024-12-02T02:11:10","date_gmt":"2024-12-02T02:11:10","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-tao-menu-chuyen-dong-dep-trong-excel-su-dung-vba\/"},"modified":"2024-12-02T02:11:10","modified_gmt":"2024-12-02T02:11:10","slug":"cach-tao-menu-chuyen-dong-dep-trong-excel-su-dung-vba","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-tao-menu-chuyen-dong-dep-trong-excel-su-dung-vba\/","title":{"rendered":"C\u00e1ch t\u1ea1o menu chuy\u1ec3n \u0111\u1ed9ng \u0111\u1eb9p trong Excel s\u1eed d\u1ee5ng VBA"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-Z6AnmM-O#1\">\n<p>Trong khi tr\u00ecnh b\u00e0y m\u1ed9t b\u00e1o c\u00e1o \u0111\u1ed9ng, m\u1ed9t Dashboard, \u0111\u00e3 khi n\u00e0o b\u1ea1n c\u1ea3m th\u1ea5y thi\u1ebfu v\u1ecb tr\u00ed cho nh\u1eefng menu n\u00fat b\u1ea5m v\u00e0 t\u00f9y ch\u1ecdn tr\u00ean b\u1ea3ng t\u00ednh Excel ch\u01b0a? N\u1ebfu b\u1ea1n \u0111\u00e3 g\u1eb7p ph\u1ea3i v\u1ea5n \u0111\u1ec1 n\u00e0y, th\u00ec m\u1ed9t menu c\u00f3 th\u1ec3 \u1ea9n \u0111i khi kh\u00f4ng c\u1ea7n v\u00e0 m\u1edf ra khi c\u1ea7n s\u1ebd gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u v\u1ecb tr\u00ed tr\u00ean b\u1ea3ng t\u00ednh c\u1ee7a m\u00ecnh. Ngo\u00e0i vi\u1ec7c \u00e1p d\u1ee5ng cho b\u00e1o c\u00e1o trong Excel, k\u1ef9 thu\u1eadt trong b\u00e0i n\u00e0y c\u00f2n c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng cho tr\u01b0\u1eddng h\u1ee3p b\u1ea1n \u0111ang x\u00e2y d\u1ef1ng menu \u0111i\u1ec1u h\u01b0\u1edbng cho b\u1ea3ng t\u00ednh ho\u1eb7c th\u1eadm ch\u00ed cho c\u1ea3 ph\u1ea7n m\u1ec1m Excel c\u1ee7a b\u1ea1n. Tr\u0103m nghe kh\u00f4ng b\u1eb1ng m\u1ed9t th\u1ea5y, b\u1ea1n h\u00e3y tham kh\u1ea3o \u0111o\u1ea1n video ng\u1eafn sau \u0111\u00e2y \u0111\u1ec3 bi\u1ebft ch\u00fang ta s\u1ebd l\u00e0m g\u00ec c\u00f9ng nhau trong b\u00e0i vi\u1ebft n\u00e0y<\/p>\n<div><a class=\"uk-button uk-button-default uk-align-center uk-width-1-2\" href=\"https:\/\/www.youtube.com\/watch?v=t-zjqXPuiQA\" data-caption=\"C\u00e1ch t\u1ea1o menu \u1ea9n hi\u1ec7n, chuy\u1ec3n \u0111\u1ed9ng trong Excel v\u1edbi VBA\" data-attrs=\"width: 1280; height: 720;\">Click \u0111\u1ec3 xem demo<\/a><\/div>\n<p>\u1ede b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd b\u1eaft \u0111\u1ea7u b\u1eb1ng vi\u1ec7c thi\u1ebft l\u1eadp c\u00e1c Shapes s\u1eed d\u1ee5ng l\u00e0m n\u00fat b\u1ea5m v\u00e0 menu, sau \u0111\u00f3 ch\u00fang ta s\u1ebd \u0111i vi\u1ebft code VBA \u0111\u1ec3 \u0111i\u1ec3u khi\u1ec3n menu c\u00f3 th\u1ec3 \u1ea9n \/ hi\u1ec7n ho\u1eb7c chuy\u1ec3n \u0111\u1ed9ng. \u0110i k\u00e8m theo b\u00e0i vi\u1ebft c\u00f3 m\u1ed9t video, \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00f9ng v\u1edbi n\u1ed9i dung b\u00e0i vi\u1ebft n\u00e0y.<\/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-674d173d69514\" 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-tao-menu-chuyen-dong-dep-trong-excel-su-dung-vba.html#Thiet_lap_cac_Shapes_va_Icon_cho_Menu_trong_Excel\" title=\"Thi\u1ebft l\u1eadp c\u00e1c Shapes v\u00e0 Icon cho Menu trong Excel\">Thi\u1ebft l\u1eadp c\u00e1c Shapes v\u00e0 Icon cho Menu trong Excel<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-menu-chuyen-dong-dep-trong-excel-su-dung-vba.html#Thiet_lap_cac_Shape_lam_nut_bam_va_Menu\" title=\"Thi\u1ebft l\u1eadp c\u00e1c Shape l\u00e0m n\u00fat b\u1ea5m v\u00e0 Menu\">Thi\u1ebft l\u1eadp c\u00e1c Shape l\u00e0m n\u00fat b\u1ea5m v\u00e0 Menu<\/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-tao-menu-chuyen-dong-dep-trong-excel-su-dung-vba.html#Thiet_lap_cac_bieu_tuong_cho_Menu_su_dung_Icon\" title=\"Thi\u1ebft l\u1eadp c\u00e1c bi\u1ec3u t\u01b0\u1ee3ng cho Menu s\u1eed d\u1ee5ng Icon\">Thi\u1ebft l\u1eadp c\u00e1c bi\u1ec3u t\u01b0\u1ee3ng cho Menu s\u1eed d\u1ee5ng Icon<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cach-tao-menu-chuyen-dong-dep-trong-excel-su-dung-vba.html#Dat_ten_cho_cac_Shape_Icon_trong_Selection_Pane\" title=\"\u0110\u1eb7t t\u00ean cho c\u00e1c Shape, Icon trong Selection Pane\">\u0110\u1eb7t t\u00ean cho c\u00e1c Shape, Icon trong Selection Pane<\/a><\/li>\n<\/ul>\n<\/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-tao-menu-chuyen-dong-dep-trong-excel-su-dung-vba.html#Code_VBA_giup_an_hien_menu\" title=\"Code VBA gi\u00fap \u1ea9n hi\u1ec7n menu\">Code VBA gi\u00fap \u1ea9n hi\u1ec7n menu<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Thiet_lap_cac_Shapes_va_Icon_cho_Menu_trong_Excel\"><\/span>Thi\u1ebft l\u1eadp c\u00e1c Shapes v\u00e0 Icon cho Menu trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Thiet_lap_cac_Shape_lam_nut_bam_va_Menu\"><\/span>Thi\u1ebft l\u1eadp c\u00e1c Shape l\u00e0m n\u00fat b\u1ea5m v\u00e0 Menu<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ea7u ti\u00ean, tr\u00ean m\u1ed9t t\u00e0i li\u1ec7u Excel c\u1ee7a b\u1ea1n, ch\u00fang ta s\u1ebd th\u00eam 2 h\u00ecnh ch\u1eef nh\u1eadt, m\u1ed9t h\u00ecnh l\u00e0m n\u00fat \u1ea9n hi\u1ec7n Menu, v\u00e0 1 n\u00fat l\u00e0m Menu b\u1eb1ng c\u00e1ch b\u1ea5m v\u00e0o th\u1ebb <strong>Insert\u00a0<\/strong>&gt; Ch\u1ecdn <strong>Shapes\u00a0<\/strong>trong nh\u00f3m l\u1ec7nh Illustrations &gt; sau \u0111\u00f3 ch\u1ecdn h\u00ecnh d\u1ea1ng c\u1ee7a n\u00fat b\u1ea5m m\u00e0 b\u1ea1n mu\u1ed1n. \u1ede \u0111\u00e2y, m\u00ecnh ch\u1ecdn c\u1ea3 ph\u1ea7n Menu v\u00e0 ph\u1ea7n n\u00fat b\u1ea5m l\u00e0 h\u00ecnh ch\u1eef nh\u1eadt.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-36691 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-tao-menu-chuyen-dong-dep-trong-excel-01-300x171-1.jpg\" alt=\"C\u00e1ch t\u1ea1o menu chuy\u1ec3n \u0111\u1ed9ng \u0111\u1eb9p trong Excel\" width=\"300\" height=\"171\" title=\"cach-tao-menu-chuyen-dong-dep-trong-excel-01-300x171-1\"><\/p>\n<p>Sau \u0111\u00f3, b\u1ea1n b\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o h\u00ecnh ch\u1eef nh\u1eadt s\u1ebd d\u00f9ng l\u00e0m Menu v\u00e0 b\u1ea5m <strong>Edit<\/strong> <strong>Text <\/strong>\u0111\u1ec3 c\u00f3 th\u1ec3 vi\u1ebft n\u1ed9i dung cho n\u00fat b\u1ea5m n\u00e0y<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-36692 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-tao-menu-chuyen-dong-dep-trong-excel-02-300x213-1.jpg\" alt=\"cach-tao-menu-chuyen-dong-dep-trong-excel-02\" width=\"300\" height=\"213\" title=\"cach-tao-menu-chuyen-dong-dep-trong-excel-02-300x213-1\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Thiet_lap_cac_bieu_tuong_cho_Menu_su_dung_Icon\"><\/span>Thi\u1ebft l\u1eadp c\u00e1c bi\u1ec3u t\u01b0\u1ee3ng cho Menu s\u1eed d\u1ee5ng Icon<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>N\u1ebfu phi\u00ean b\u1ea3n Excel c\u1ee7a b\u1ea1n c\u00f3 h\u1ed7 tr\u1ee3 s\u1eed d\u1ee5ng Icon \u2013 c\u00e1c bi\u1ec3u t\u01b0\u1ee3ng tr\u1ef1c ti\u1ebfp t\u1eeb Microsoft, b\u1ea1n c\u00f3 th\u1ec3 b\u1ea5m v\u00e0o th\u1ebb <strong>Insert\u00a0<\/strong>&gt; sau \u0111\u00f3 b\u1ea5m ch\u1ecdn\u00a0<strong>Icon\u00a0<\/strong>v\u00e0 ch\u1ecdn cho m\u00ecnh nh\u1eefng bi\u1ec3u t\u01b0\u1ee3ng menu ph\u00f9 h\u1ee3p v\u1edbi Dashboard b\u00e1o c\u00e1o v\u00e0 \u1ee9ng d\u1ee5ng Excel c\u1ee7a b\u1ea1n.<\/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-2.gif\" title=\"vba101_92019-nho-2\"><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-23.gif\" title=\"ex101_92019-nho-23\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-36693 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-tao-menu-chuyen-dong-dep-trong-excel-03-300x300-1.jpg\" alt=\"cach-tao-menu-chuyen-dong-dep-trong-excel-03\" width=\"300\" height=\"300\" title=\"cach-tao-menu-chuyen-dong-dep-trong-excel-03-300x300-1\"><\/p>\n<p>Sau \u0111\u00f3, khi b\u1ea1n \u0111ang \u1edf trong ch\u1ebf \u0111\u1ed9 ch\u1ec9nh s\u1eeda c\u1ee7a 1 Shape ho\u1eb7c Icon, h\u00e3y b\u1ea5m v\u00e0o th\u1ebb\u00a0<strong>Shape Format, Selection Pane.\u00a0<\/strong>Th\u01b0\u1eddng Selection Pane s\u1ebd xu\u1ea5t hi\u1ec7n b\u00ean tay ph\u1ea3i c\u1ee7a b\u1ea3ng t\u00ednh, \u0111\u1ec3 d\u1ec5 d\u00e0ng l\u00e0m vi\u1ec7c h\u01a1n, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 k\u00e9o sang ph\u00eda b\u00ean tr\u00e1i nh\u01b0 trong h\u00ecnh v\u1ebd Thanh l\u00e0m:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-36694 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-tao-menu-chuyen-dong-dep-trong-excel-04-1024x411-1.jpg\" alt=\"cach-tao-menu-chuyen-dong-dep-trong-excel-04\" width=\"1024\" height=\"411\" title=\"cach-tao-menu-chuyen-dong-dep-trong-excel-04-1024x411-1\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Dat_ten_cho_cac_Shape_Icon_trong_Selection_Pane\"><\/span>\u0110\u1eb7t t\u00ean cho c\u00e1c Shape, Icon trong Selection Pane<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u01b0\u1edbc ti\u1ebfp theo, ch\u00fang ta s\u1ebd \u0111i \u0111\u1eb7t t\u00ean cho t\u1eebng th\u00e0nh ph\u1ea7n giao di\u1ec7n c\u1ee7a ch\u00fang ta nh\u01b0 ch\u00fa th\u00edch trong h\u00ecnh sau b\u1eb1ng c\u00e1ch click \u0111\u00fap chu\u1ed9t v\u00e0o t\u00ean t\u01b0\u01a1ng \u1ee9ng trong Selection Pane<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-36695 size-large aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dat-ten-cac-thanh-phan-tren-giao-dien-1024x441-1.jpg\" alt=\"dat-ten-cac-thanh-phan-tren-giao-dien\" width=\"1024\" height=\"441\" title=\"dat-ten-cac-thanh-phan-tren-giao-dien-1024x441-1\"><\/p>\n<p>Sau \u0111\u00f3, ch\u00fang ta b\u1ea5m gi\u1eef Ctrl v\u00e0 ch\u1ecdn t\u1eebng Shape trong Selection Pane, tr\u1eeb n\u00fat <strong>btnShowHide<\/strong>, ti\u1ebfp theo, b\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o c\u00e1c h\u00ecnh \u0111\u01b0\u1ee3c l\u1ef1a ch\u1ecdn v\u00e0 b\u1ea5m ti\u1ebfp <strong>Group &gt; Group<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-36696 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-tao-menu-chuyen-dong-dep-trong-excel-05-1024x529-1.jpg\" alt=\"cach-tao-menu-chuyen-dong-dep-trong-excel-05\" width=\"1024\" height=\"529\" title=\"cach-tao-menu-chuyen-dong-dep-trong-excel-05-1024x529-1\"><\/p>\n<p>Sau khi nh\u00f3m xong c\u00e1c h\u00ecnh \u1ea3nh, ch\u00fang ta \u0111\u1eb7t t\u00ean cho Group n\u00e0y l\u00e0 <em>MenuGroup<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-36697 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-tao-menu-chuyen-dong-dep-trong-excel-06-300x293-1.jpg\" alt=\"cach-tao-menu-chuyen-dong-dep-trong-excel-06\" width=\"300\" height=\"293\" title=\"cach-tao-menu-chuyen-dong-dep-trong-excel-06-300x293-1\"><\/p>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta \u0111\u00e3 thi\u1ebft l\u1eadp xong h\u1ec7 th\u1ed1ng menu r\u1ed3i. B\u01b0\u1edbc ti\u1ebfp theo ch\u00fang ta s\u1ebd \u0111i vi\u1ebft code VBA \u0111\u1ec3 gi\u00fap Menu c\u00f3 th\u1ec3 \u1ea9n ho\u1eb7c hi\u1ec7n khi click v\u00e0o n\u00fat <em>\u1ea8n \/ Hi\u1ec7n Menu<\/em><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Code_VBA_giup_an_hien_menu\"><\/span>Code VBA gi\u00fap \u1ea9n hi\u1ec7n menu<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 gi\u00fap Menu c\u1ee7a ch\u00fang ta chu\u1ea9n b\u1ecb \u1edf ph\u1ea7n tr\u00ean c\u00f3 th\u1ec3 \u1ea9n hi\u1ec7n khi click v\u00e0o n\u00fat <em>\u1ea8n \/ Hi\u1ec7n Menu<\/em>, th\u00ec ch\u00fang ta s\u1ebd b\u1eaft \u0111\u1ea7u b\u1eb1ng vi\u1ec7c b\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o n\u00fat <em>\u1ea8n \/ Hi\u1ec7n Menu\u00a0<\/em>sau \u0111\u00f3 ch\u1ecdn <strong>Assign Macro \u2026<\/strong><\/p>\n<p>\u1ede c\u1eeda s\u1ed5 Assign Macro, c\u00e1c b\u1ea1n s\u1ebd nh\u00ecn th\u1ea5y c\u00f4ng s\u1ee9c \u0111i \u0111\u1ed5i t\u00ean l\u1ea1i c\u00e1c Shape n\u00e3y gi\u1edd qu\u1ea3 l\u00e0 kh\u00f4ng l\u00e3ng ph\u00ed, khi Excel \u0111\u00e3 g\u1ee3i \u00fd \u0111\u00fang cho ch\u00fang ta t\u00ean Macro v\u00e0 m\u1ee5c \u0111\u00edch s\u1eed d\u1ee5ng trong \u00f4 Macro name, n\u1ebfu b\u1ea1n \u0111\u1ed3ng \u00fd v\u1edbi s\u1ef1 g\u1ee3i \u00fd n\u00e0y, h\u00e3y b\u1ea5m n\u00fat\u00a0<strong>New<\/strong> \u0111\u1ec3 t\u1ea1o 1 Macro m\u1edbi.<\/p>\n<p>N\u1ebfu b\u1ea1n ch\u01b0a bi\u1ebft b\u1eaft \u0111\u1ea7u h\u1ecdc l\u1eadp tr\u00ecnh VBA c\u01a1 b\u1ea3n \u1edf \u0111\u00e2u v\u00e0 nh\u01b0 th\u1ebf n\u00e0o, h\u00e3y tham kh\u1ea3o kh\u00f3a h\u1ecdc: <a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\">VBA101 \u2013 T\u1ef1 \u0111\u1ed9ng ho\u00e1 Excel v\u1edbi l\u1eadp tr\u00ecnh VBA cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u<\/a><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-36698 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cach-tao-menu-chuyen-dong-dep-trong-excel-07-1024x483-1.jpg\" alt=\"cach-tao-menu-chuyen-dong-dep-trong-excel-07\" width=\"1024\" height=\"483\" title=\"cach-tao-menu-chuyen-dong-dep-trong-excel-07-1024x483-1\"><\/p>\n<p>Trong <em>Sub btnShowHide_Click <\/em>h\u00e3y \u0111i\u1ec1n d\u00f2ng code VBA sau \u0111\u00e2y v\u00e0o<\/p>\n<pre><code class=\"language-vba\">Sheet1.Shapes(\"MenuGroup\").Visible = Not Sheet1.Shapes(\"MenuGroup\").Visible\r\n<\/code><\/pre>\n<p>T\u01b0\u01a1ng t\u1ef1 v\u1edbi c\u00e1c n\u00fat Icon tr\u00ean menu, b\u1ea1n c\u00f3 th\u1ec3 vi\u1ebft code s\u1ef1 ki\u1ec7n t\u01b0\u01a1ng t\u1ef1 \u0111\u1ec3 th\u1ef1c hi\u1ec7n code m\u00e0 b\u1ea1n mu\u1ed1n, v\u00ed d\u1ee5 nh\u01b0 sau<\/p>\n<pre><code class=\"language-vba\">Sub MenuItemMail_Click()\r\n  MsgBox \"MenuItemMail\" 'Thay b\u1eb1ng code VBA c\u1ee7a b\u1ea1n\r\nEnd Sub\r\nSub MenuItemDownload_Click()\r\n  MsgBox \"MenuItemDownload\"\r\nEnd Sub\r\nSub MenuItemContact_Click()\r\n  MsgBox \"MenuItemContact\"\r\nEnd Sub\r\n<\/code><\/pre>\n<p>V\u00e0 ch\u1ec9 \u0111\u01a1n gi\u1ea3n v\u1eady th\u00f4i, b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 t\u1ea1o ra \u0111\u01b0\u1ee3c Menu \u1ea9n hi\u1ec7n b\u1eb1ng c\u00e1c Shapes v\u00e0 m\u1ed9t \u00edt code VBA r\u1ed3i. H\u00e3y theo d\u00f5i th\u00eam video k\u00e8m theo b\u00e0i vi\u1ebft n\u00e0y \u0111\u1ec3 c\u00f3 th\u1ec3 l\u00e0m theo c\u00e1c thao t\u00e1c trong b\u00e0i m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c nh\u1ea5t nh\u00e9. Ph\u1ea7n t\u1ea1o Menu chuy\u1ec3n \u0111\u1ed9ng, m\u00ecnh s\u1ebd c\u1eadp nh\u1eadt trong <a href=\"https:\/\/dtnguyen.business\/course\/vba201-lap-trinh-vba-nang-cao-trong-excel\" target=\"_blank\" rel=\"noopener\">kh\u00f3a h\u1ecdc l\u1eadp tr\u00ecnh VBA201 n\u00e2ng cao<\/a><\/p>\n<div><a class=\"uk-button uk-button-default uk-align-center uk-width-1-2\" href=\"https:\/\/www.youtube.com\/watch?v=30gf2GbZ_ZE\" data-caption=\"C\u00e1ch t\u1ea1o menu \u1ea9n hi\u1ec7n, chuy\u1ec3n \u0111\u1ed9ng trong Excel v\u1edbi VBA\" data-attrs=\"width: 1280; height: 720;\">Click \u0111\u1ec3 xem video<\/a><\/div>\n<div id=\"erdyt-674d173d6457c\" data-id=\"30gf2GbZ_ZE\" class=\"erd-youtube-responsive\" style=\"position:relative;clear:both;width:100%;max-width:88%;margin-left:auto;margin-right:auto\">\n<div style=\"padding-bottom:56.25%\">\n<div class=\"erd-ytplay\" id=\"erdytp-30gf2GbZ_ZE-674d173d6457c\" data-vid=\"30gf2GbZ_ZE\" data-src=\"https:\/\/www.youtube.com\/embed\/30gf2GbZ_ZE?loop=1&amp;autoplay=1&amp;rel=0\" data-allowfullscreen=\"true\"><img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/hqdefault-4.jpg\" alt=\"YouTube video\" title=\"hqdefault-4\"><\/div>\n<\/div>\n<\/div>\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-2.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-522","post","type-post","status-publish","format-standard","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/522","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=522"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/522\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=522"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=522"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=522"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}