{"id":10737,"date":"2025-01-14T23:25:29","date_gmt":"2025-01-14T23:25:29","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/excel-vba-lam-moi-noi-dung-vung-nhap-du-lieu\/"},"modified":"2025-01-14T23:25:29","modified_gmt":"2025-01-14T23:25:29","slug":"excel-vba-lam-moi-noi-dung-vung-nhap-du-lieu","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/excel-vba-lam-moi-noi-dung-vung-nhap-du-lieu\/","title":{"rendered":"Excel VBA: L\u00e0m m\u1edbi n\u1ed9i dung v\u00f9ng nh\u1eadp d\u1eef li\u1ec7u"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>\u0110\u00e2y l\u00e0 Seri b\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn vi\u1ec7c\u00a0\u1ee9ng d\u1ee5ng VBA trong qu\u1ea3n l\u00fd n\u1ed9i dung trong b\u1ea3ng\u00a0danh s\u00e1ch (danh s\u00e1ch h\u00e0ng h\u00f3a, danh s\u00e1ch nh\u00e2n vi\u00ean\u2026), g\u1ed3m\u00a05 ph\u1ea7n:<\/p>\n<ul>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/excel-vba-lam-moi-noi-dung-vung-nhap-du-lieu.html\">Ph\u1ea7n\u00a01: L\u00e0m m\u1edbi n\u1ed9i dung v\u00f9ng nh\u1eadp d\u1eef li\u1ec7u<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/excel-vba-moi-noi-dung-vao-bang-danh-sach.html\">Ph\u1ea7n 2: Th\u00eam m\u1edbi n\u1ed9i dung v\u00e0o danh s\u00e1ch<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/excel-vba-lay-thong-tin-trong-bang-danh-sach-chi-voi-1-click-chuot.html\">Ph\u1ea7n 3: L\u1ea5y th\u00f4ng tin b\u1ea5t k\u1ef3 trong b\u1ea3ng danh s\u00e1ch v\u00e0o form<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/excel-vba-xoa-noi-dung-bat-ky-trong-bang-danh-sach.html\">Ph\u1ea7n 4: X\u00f3a n\u1ed9i dung b\u1ea5t k\u1ef3 trong b\u1ea3ng danh s\u00e1ch<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/excel-vba-cap-nhat-noi-dung-tu-form-vao-bang-danh-sach.html\">Ph\u1ea7n 5: C\u1eadp nh\u1eadt n\u1ed9i dung t\u1eeb Form v\u00e0o b\u1ea3ng danh s\u00e1ch<\/a><\/li>\n<\/ul>\n<p><strong>Sau\u00a0\u0111\u00e2y ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u n\u1ed9i dung c\u1ee7a ph\u1ea7n 1 qua b\u00e0i t\u1eadp sau:<\/strong><\/p>\n<p>Cho b\u1ea3ng d\u1eef li\u1ec7u v\u1ec1 Danh s\u00e1ch nh\u00e2n vi\u00ean nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13030 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/pic1-1.png\" width=\"583\" height=\"248\" title=\"pic1-1\"><\/p>\n<p>\u00a0<\/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-6786f268393d0\" 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\/excel-vba-lam-moi-noi-dung-vung-nhap-du-lieu.html#Yeu_cau\" title=\"Y\u00eau c\u1ea7u:\">Y\u00eau c\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\/excel-vba-lam-moi-noi-dung-vung-nhap-du-lieu.html#Cach_lam\" title=\"C\u00e1ch l\u00e0m:\">C\u00e1ch l\u00e0m:<\/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\/excel-vba-lam-moi-noi-dung-vung-nhap-du-lieu.html#1_Phan_tich_yeu_cau_bai_toan\" title=\"1. Ph\u00e2n t\u00edch y\u00eau c\u1ea7u b\u00e0i to\u00e1n\">1. Ph\u00e2n t\u00edch y\u00eau c\u1ea7u b\u00e0i to\u00e1n<\/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\/excel-vba-lam-moi-noi-dung-vung-nhap-du-lieu.html#2_Cach_thuc_hien_lenh_Tao_moi\" title=\"2. C\u00e1ch th\u1ef1c hi\u1ec7n l\u1ec7nh T\u1ea1o m\u1edbi\">2. C\u00e1ch th\u1ef1c hi\u1ec7n l\u1ec7nh T\u1ea1o m\u1edbi<\/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\/excel-vba-lam-moi-noi-dung-vung-nhap-du-lieu.html#3_Thiet_lap_dinh_dang_cho_cac_vung_nhap_du_lieu\" title=\"3. Thi\u1ebft l\u1eadp\u00a0\u0111\u1ecbnh d\u1ea1ng cho c\u00e1c v\u00f9ng nh\u1eadp d\u1eef li\u1ec7u\">3. Thi\u1ebft l\u1eadp\u00a0\u0111\u1ecbnh d\u1ea1ng cho c\u00e1c v\u00f9ng nh\u1eadp d\u1eef li\u1ec7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/excel-vba-lam-moi-noi-dung-vung-nhap-du-lieu.html#4_Gan_Macro_vao_nut_lenh_Tao_moi\" title=\"4. G\u00e1n\u00a0Macro v\u00e0o n\u00fat l\u1ec7nh T\u1ea1o m\u1edbi\">4. G\u00e1n\u00a0Macro v\u00e0o n\u00fat l\u1ec7nh T\u1ea1o m\u1edbi<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Yeu_cau\"><\/span><strong>Y\u00eau c\u1ea7u:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>T\u1ea1o n\u00fat l\u1ec7nh T\u1ea1o m\u1edbi\u00a0\u0111\u1ec3 l\u00e0m m\u1edbi v\u00f9ng nh\u1eadp n\u1ed9i dung A3:A5 (N\u00fat l\u1ec7nh T\u1ea1o m\u1edbi)<\/li>\n<li>K\u1ebft h\u1ee3p vi\u1ec7c kh\u00f3a sheet\u00a0\u0111\u1ec3 kh\u00f4ng cho ph\u00e9p t\u1ef1\u00a0\u00fd thay\u00a0\u0111\u1ed5i n\u1ed9i dung trong b\u1ea3ng<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Cach_lam\"><\/span><strong>C\u00e1ch l\u00e0m:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u00e2y l\u00e0 m\u1ed9t d\u1ea1ng c\u01a1 b\u1ea3n c\u1ee7a c\u1ea5u tr\u00fac b\u1ea3ng qu\u1ea3n l\u00fd theo danh s\u00e1ch, c\u1ee5 th\u1ec3 l\u00e0 danh s\u00e1ch nh\u00e2n vi\u00ean.<\/p>\n<p>Thay v\u00ec t\u1ea1o\u00a0UserForm trong VBA th\u00ec ch\u00fang ta c\u00f3 th\u1ec3\u00a0t\u1ea1o\u00a0tr\u1ef1c ti\u1ebfp form\u00a0\u1edf trong c\u00f9ng Sheet v\u1edbi b\u1ea3ng danh s\u00e1ch. Khi\u00a0\u0111\u00f3 vi\u1ec7c Th\u00eam + S\u1eeda + X\u00f3a n\u1ed9i dung\u00a0\u1edf b\u1ea3ng Danh s\u00e1ch nh\u00e2n vi\u00ean s\u1ebd c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n 1 c\u00e1ch d\u1ec5 d\u00e0ng, nhanh ch\u00f3ng.<\/p>\n<div class=\"code-block code-block-3\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-216.gif\" title=\"ex101_92019-nho-216\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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\/2025\/01\/vba101_92019-nho-15.gif\" title=\"vba101_92019-nho-15\"><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\/2025\/01\/ex101_92019-nho-216.gif\" title=\"ex101_92019-nho-216\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h4><span class=\"ez-toc-section\" id=\"1_Phan_tich_yeu_cau_bai_toan\"><\/span>1. Ph\u00e2n t\u00edch y\u00eau c\u1ea7u b\u00e0i to\u00e1n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>Cho ph\u00e9p nh\u1eadp d\u1eef li\u1ec7u v\u00e0o c\u00e1c\u00a0\u00f4 B3 (m\u00e3 nh\u00e2n vi\u00ean), B5 (h\u1ecd t\u00ean), D3 (ng\u00e0y sinh), D5 (b\u1ed9 ph\u1eadn) khi sheet\u00a0\u0111ang\u00a0\u1edf tr\u1ea1ng th\u00e1i kh\u00f3a (Protect sheet). Ngo\u00e0i ra c\u00e1c v\u1ecb tr\u00ed kh\u00e1c kh\u00f4ng\u00a0\u0111\u01b0\u1ee3c thay\u00a0\u0111\u1ed5i.<\/li>\n<li>D\u00f9ng VBA\u00a0\u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u\u00a0\u0111\u01b0\u1ee3c nh\u1eadp\u00a0\u1edf c\u00e1c\u00a0\u00f4 B3, B5, D3, D5 v\u00e0o b\u1ea3ng danh s\u00e1ch (th\u00eam v\u00e0o d\u00f2ng ti\u1ebfp theo \u1edf d\u01b0\u1edbi c\u00f9ng trong b\u1ea3ng) =&gt; Sau khi th\u00eam d\u1eef li\u1ec7u v\u00e0o b\u1ea3ng th\u00ec v\u1eabn gi\u1eef nguy\u00ean tr\u1ea1ng th\u00e1i kh\u00f3a b\u1ea3ng (l\u01b0u t\u1ef1\u00a0\u0111\u1ed9ng b\u1eb1ng l\u1ec7nh L\u01b0u)<\/li>\n<li>D\u00f9ng VBA\u00a0\u0111\u1ec3 x\u00f3a d\u1eef li\u1ec7u\u00a0\u1edf c\u00e1c\u00a0\u00f4\u00a0B3, B5, D3, D5 (x\u00f3a t\u1ef1\u00a0\u0111\u1ed9ng b\u1eb1ng l\u1ec7nh T\u1ea1o m\u1edbi)<\/li>\n<\/ul>\n<h4><span class=\"ez-toc-section\" id=\"2_Cach_thuc_hien_lenh_Tao_moi\"><\/span>2. C\u00e1ch th\u1ef1c hi\u1ec7n l\u1ec7nh T\u1ea1o m\u1edbi<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>M\u1edf c\u1eeda s\u1ed5 VBA (ph\u00edm t\u1eaft Alt + F11)<\/li>\n<li>T\u1ea1o m\u1edbi 1 Module &gt; Trong Module\u00a0\u0111\u00f3 t\u1ea1o m\u1edbi 1 Sub l\u1ea5y t\u00ean l\u00e0 Lenh_Tao_Moi<\/li>\n<li>Ghi ch\u00fa c\u00e1c n\u1ed9i dung c\u1ea7n th\u1ef1c hi\u1ec7n trong sub n\u00e0y nh\u01b0 sau<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13032 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/pic2-2.png\" width=\"524\" height=\"246\" title=\"pic2-2\"><\/li>\n<li>V\u00ec to\u00e0n b\u1ed9 n\u1ed9i dung\u00a0\u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n t\u1ea1i Sheet1, n\u00ean ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e2u l\u1ec7nh<\/li>\n<\/ul>\n<blockquote>\n<p>With Sheet1<\/p>\n<p>\u2026<\/p>\n<p>End\u00a0with<\/p>\n<\/blockquote>\n<p>Do\u00a0\u0111\u00f3 khi c\u00e1c c\u00e2u l\u1ec7nh kh\u00e1c \u0111\u1eb7t trong With Sheet1 th\u00ec ch\u00fang ta kh\u00f4ng c\u1ea7n nh\u1eafc l\u1ea1i t\u00ean sheet n\u1eefa<\/p>\n<ul>\n<li>L\u1ec7nh m\u1edf kh\u00f3a sheet\u00a0\u0111\u01b0\u1ee3c vi\u1ebft d\u01b0\u1edbi d\u1ea1ng:<\/li>\n<\/ul>\n<blockquote>\n<p>T\u00ean sheet.Unprotect<\/p>\n<\/blockquote>\n<ul>\n<li>L\u1ec7nh x\u00f3a n\u1ed9i dung c\u1ee7a 1 v\u00f9ng\u00a0\u0111\u01b0\u1ee3c vi\u1ebft d\u01b0\u1edbi d\u1ea1ng<\/li>\n<\/ul>\n<blockquote>\n<p>T\u00ean sheet.V\u00f9ng c\u1ea7n x\u00f3a.ClearContents<\/p>\n<\/blockquote>\n<p>\u1ede\u00a0\u0111\u00e2y v\u00f9ng c\u1ea7n x\u00f3a l\u00e0 c\u00e1c \u00f4 B3, B5, D3, D5<\/p>\n<p>V\u00ec\u00a0\u00f4 B4 v\u00e0 D4 kh\u00f4ng c\u00f3 n\u1ed9i dung g\u00ec, n\u00ean ch\u00fang ta c\u00f3 th\u1ec3 g\u1ed9p B3 v\u00e0 B5 th\u00e0nh B3:B5; g\u1ed9p D3 v\u00e0 D5 th\u00e0nh D3:D5<\/p>\n<p>=&gt; Ch\u00fang ta c\u00f3 c\u00e2u l\u1ec7nh sau:<\/p>\n<blockquote>\n<p>T\u00ean Sheet.Range(\u201cB3:B5\u201d).ClearContents<\/p>\n<p>T\u00ean Sheet.Range(\u201cD3:D5\u201d).ClearContents<\/p>\n<\/blockquote>\n<ul>\n<li>L\u1ec7nh kh\u00f3a sheet\u00a0\u0111\u01b0\u1ee3c vi\u1ebft d\u01b0\u1edbi d\u1ea1ng<\/li>\n<\/ul>\n<blockquote>\n<p>T\u00ean Sheet.Protect<\/p>\n<\/blockquote>\n<p>Nh\u01b0 v\u1eady khi\u00a0\u0111\u01b0a v\u00e0o trong c\u00f9ng 1 Sub\u00a0th\u00ec ta c\u00f3 to\u00e0n b\u1ed9 c\u00e2u l\u1ec7nh nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13033 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/pic3-2.png\" width=\"258\" height=\"219\" title=\"pic3-2\"><\/p>\n<blockquote>\n<p>\u0110\u1eebng b\u1ecf qua:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-lap-trinh-vba-trong-excel\">l\u1edbp h\u1ecdc VBA \u1edf H\u00e0 N\u1ed9i<\/a><\/p>\n<\/blockquote>\n<h4><span class=\"ez-toc-section\" id=\"3_Thiet_lap_dinh_dang_cho_cac_vung_nhap_du_lieu\"><\/span>3. Thi\u1ebft l\u1eadp\u00a0\u0111\u1ecbnh d\u1ea1ng cho c\u00e1c v\u00f9ng nh\u1eadp d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>T\u1ea1i nh\u1eefng\u00a0\u00f4 cho ph\u00e9p nh\u1eadp d\u1eef li\u1ec7u khi sheet\u00a0\u1edf ch\u1ebf\u00a0\u0111\u1ed9 kh\u00f3a th\u00ec ch\u00fang ta c\u1ea7n ph\u1ea3i\u00a0\u0111\u1ecbnh d\u1ea1ng (Format Cells) cho nh\u1eefng\u00a0\u00f4\u00a0\u0111\u00f3\u00a0\u1edf ch\u1ebf\u00a0\u0111\u1ed9 kh\u00f4ng kh\u00f3a (<strong>Format Cells<\/strong> &gt;<strong>\u00a0Protection\u00a0<\/strong>&gt; B\u1ecf d\u1ea5u ch\u1ecdn\u00a0\u1edf m\u1ee5c <strong>Locked<\/strong>)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13034 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/pic4-2.png\" width=\"830\" height=\"478\" title=\"pic4-2\"><\/p>\n<h4><span class=\"ez-toc-section\" id=\"4_Gan_Macro_vao_nut_lenh_Tao_moi\"><\/span>4. G\u00e1n\u00a0Macro v\u00e0o n\u00fat l\u1ec7nh T\u1ea1o m\u1edbi<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>V\u1ebd n\u00fat l\u1ec7nh T\u1ea1o m\u1edbi b\u1eb1ng ch\u1ee9c n\u0103ng\u00a0Insert &gt; Shapes &gt; V\u1ebd 1 h\u00ecnh ch\u1eef nh\u1eadt &gt;\u00a0\u0110\u1ecbnh d\u1ea1ng n\u1ed9i dung trong h\u00ecnh theo\u00a0\u00fd mu\u1ed1n,\u00a0\u0111\u1eb7t t\u00ean (edit text) th\u00e0nh T\u1ea1o m\u1edbi<\/li>\n<li>Click chu\u1ed9t ph\u1ea3i v\u00e0o n\u00fat l\u1ec7nh T\u1ea1o m\u1edbi, ch\u1ecdn\u00a0Assign Macro<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13035 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/pic5-2.png\" width=\"236\" height=\"492\" title=\"pic5-2\"><\/li>\n<li>Ch\u1ecdn Macro Lenh_Tao_Moi r\u1ed3i b\u1ea5m ok<\/li>\n<\/ul>\n<p>Ch\u00fang ta ki\u1ec3m tra th\u1eed n\u00fat l\u1ec7nh v\u1eeba t\u1ea1o b\u1eb1ng c\u00e1ch Nh\u1eadp d\u1eef li\u1ec7u v\u00e0o c\u00e1c\u00a0\u00f4 B3, B5, D3, D5 r\u1ed3i b\u1ea5m l\u1ec7nh T\u1ea1o m\u1edbi xem th\u1ebf n\u00e0o nh\u00e9.<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng!<\/p>\n<p>\u0110\u00f3n xem b\u00e0i sau: Ph\u1ea7n 2: T\u1ea1o n\u00fat l\u1ec7nh l\u01b0u d\u1eef li\u1ec7u t\u1eeb v\u00f9ng Nh\u1eadp d\u1eef li\u1ec7u v\u00e0o B\u1ea3ng k\u00ea danh s\u00e1ch nh\u00e2n vi\u00ean.<\/p>\n<p>C\u00f9ng H\u1ecdc Excel Online kh\u00e1m ph\u00e1 th\u1ebf gi\u1edbi c\u1ee7a Excel VBA n\u00e0o!<\/p>\n<p>VBA c\u00f3 r\u1ea5t nhi\u1ec1u \u1ee9ng d\u1ee5ng, gi\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=\"http:\/\/bit.ly\/2OAUBOg\">VBA101 \u2013 VBA c\u01a1 b\u1ea3n d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u<\/a>\u00a0c\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:<\/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<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-216.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10738,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10737","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\/10737","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=10737"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10737\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10738"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10737"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10737"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10737"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}