{"id":5565,"date":"2024-12-16T05:56:51","date_gmt":"2024-12-16T05:56:51","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/16\/huong-dan-cach-xoa-noi-dung-bat-ky-trong-bang-danh-sach-trong-excel-bang-vba\/"},"modified":"2024-12-16T05:56:51","modified_gmt":"2024-12-16T05:56:51","slug":"huong-dan-cach-xoa-noi-dung-bat-ky-trong-bang-danh-sach-trong-excel-bang-vba","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/16\/huong-dan-cach-xoa-noi-dung-bat-ky-trong-bang-danh-sach-trong-excel-bang-vba\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch x\u00f3a n\u1ed9i dung b\u1ea5t k\u1ef3 trong b\u1ea3ng danh s\u00e1ch trong Excel b\u1eb1ng VBA"},"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>Sau\u00a0\u0111\u00e2y ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u n\u1ed9i dung c\u1ee7a ph\u1ea7n\u00a04 qua b\u00e0i t\u1eadp sau:<\/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\/2024\/12\/pic1-1.png\" width=\"583\" height=\"248\" title=\"pic1-1\"><\/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-675fc12317136\" 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\/excel-vba-xoa-noi-dung-bat-ky-trong-bang-danh-sach.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-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/excel-vba-xoa-noi-dung-bat-ky-trong-bang-danh-sach.html#Cach_lam\" title=\"C\u00e1ch l\u00e0m\">C\u00e1ch l\u00e0m<\/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-3\" href=\"https:\/\/blog.hocexcel.online\/excel-vba-xoa-noi-dung-bat-ky-trong-bang-danh-sach.html#1_Phan_tich_yeu_cau\" title=\"1. Ph\u00e2n t\u00edch y\u00eau c\u1ea7u\">1. Ph\u00e2n t\u00edch 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-4\" href=\"https:\/\/blog.hocexcel.online\/excel-vba-xoa-noi-dung-bat-ky-trong-bang-danh-sach.html#2_Cach_thuc_hien\" title=\"2. C\u00e1ch th\u1ef1c hi\u1ec7n\">2. C\u00e1ch th\u1ef1c hi\u1ec7n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/excel-vba-xoa-noi-dung-bat-ky-trong-bang-danh-sach.html#3_Gan_Macro_vao_nut_lenh_Xoa\" title=\"3. G\u00e1n Macro v\u00e0o n\u00fat l\u1ec7nh X\u00f3a\">3. G\u00e1n Macro v\u00e0o n\u00fat l\u1ec7nh X\u00f3a<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/excel-vba-xoa-noi-dung-bat-ky-trong-bang-danh-sach.html#4_Ket_luan\" title=\"4. K\u1ebft lu\u1eadn\">4. K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Yeu_cau\"><\/span>Y\u00eau c\u1ea7u<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>X\u00f3a n\u1ed9i dung b\u1ea5t k\u1ef3 trong b\u1ea3ng danh s\u00e1ch nh\u00e2n vi\u00ean t\u01b0\u01a1ng\u00a0\u1ee9ng theo v\u1ecb tr\u00ed\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn<\/li>\n<li>Th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y ngay khi sheet \u0111ang kh\u00f3a<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Cach_lam\"><\/span>C\u00e1ch l\u00e0m<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"1_Phan_tich_yeu_cau\"><\/span>1. Ph\u00e2n t\u00edch y\u00eau c\u1ea7u<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u00e0i t\u1eadp n\u00e0y gi\u00fap ch\u00fang ta k\u1ebft h\u1ee3p v\u1edbi n\u1ed9i dung b\u00e0i h\u1ecdc tr\u01b0\u1edbc (S\u1ef1 ki\u1ec7n ch\u1ecdn 1 v\u1ecb tr\u00ed trong b\u1ea3ng) v\u1edbi logic v\u1ec1 vi\u1ec7c x\u00f3a d\u1eef li\u1ec7u, c\u1eadp nh\u1eadt n\u1ed9i dung b\u1ea3ng d\u1eef li\u1ec7u. T\u1ea5t c\u1ea3 c\u00e1c n\u1ed9i dung n\u00e0y ch\u00fang ta\u00a0\u0111\u00e3 bi\u1ebft t\u1eeb trong c\u00e1c b\u00e0i h\u1ecdc tr\u01b0\u1edbc,\u00a0\u1edf\u00a0\u0111\u00e2y ch\u1ec9 l\u00e0 vi\u1ec7c ch\u00fang ta s\u1eafp x\u1ebfp th\u1ee9 t\u1ef1 c\u00e1c c\u00f4ng vi\u1ec7c di\u1ec5n ra theo tr\u00ecnh t\u1ef1 ph\u00f9 h\u1ee3p v\u1edbi mong mu\u1ed1n.<\/p>\n<p>=&gt; X\u00e1c\u00a0\u0111\u1ecbnh r\u00f5 logic c\u1ee7a vi\u1ec7c ch\u1ecdn v\u00e0 x\u00f3a n\u1ed9i dung\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn.<\/p>\n<ul>\n<li>Ch\u1ecdn n\u1ed9i dung trong b\u1ea3ng =&gt; X\u00e1c\u00a0\u0111\u1ecbnh v\u1ecb tr\u00ed d\u00f2ng\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn. D\u00f2ng n\u00e0y ph\u1ea3i n\u1eb1m trong b\u1ea3ng v\u00e0 ph\u1ea3i c\u00f3 d\u1eef li\u1ec7u<\/li>\n<li>X\u00f3a n\u1ed9i dung d\u00f2ng\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn<\/li>\n<li>S\u1eafp x\u1ebfp l\u1ea1i d\u1eef li\u1ec7u trong b\u1ea3ng sau khi x\u00f3a\u00a0\u0111\u1ec3 tr\u00e1nh vi\u1ec7c xu\u1ea5t hi\u1ec7n d\u00f2ng tr\u1ed1ng xen k\u1ebd d\u1eef li\u1ec7u trong b\u1ea3ng<\/li>\n<li>M\u1edf kh\u00f3a tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n c\u00e2u l\u1ec7nh, kh\u00f3a l\u1ea1i b\u1ea3ng t\u00ednh sau khi ho\u00e0n th\u00e0nh c\u00e2u l\u1ec7nh.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"2_Cach_thuc_hien\"><\/span>2. C\u00e1ch th\u1ef1c hi\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>X\u00e1c\u00a0\u0111\u1ecbnh d\u00f2ng\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn: T\u01b0\u01a1ng t\u1ef1 b\u00e0i h\u1ecdc Ph\u1ea7n 3, l\u1ec7nh x\u00e1c\u00a0\u0111\u1ecbnh d\u00f2ng\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn l\u00e0:<\/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-200.gif\" title=\"vba101_92019-nho-200\"><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-484.gif\" title=\"ex101_92019-nho-484\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<blockquote>\n<p>ActiveCell.Row<\/p>\n<\/blockquote>\n<p>D\u00f2ng\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn ph\u1ea3i n\u1eb1m trong b\u1ea3ng v\u00e0 ph\u1ea3i c\u00f3 d\u1eef li\u1ec7u: T\u00ednh t\u1eeb d\u00f2ng b\u1eaft\u00a0\u0111\u1ea7u c\u1ee7a b\u1ea3ng t\u1edbi d\u00f2ng cu\u1ed1i c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u trong b\u1ea3ng<\/p>\n<p>D\u00f2ng\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn &gt;= D\u00f2ng b\u1eaft\u00a0\u0111\u1ea7u trong b\u1ea3ng (D\u00f2ng 8)<\/p>\n<p>D\u00f2ng\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn &lt;= D\u00f2ng cu\u1ed1i c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u trong b\u1ea3ng (C\u00e2u l\u1ec7nh t\u00ecm d\u00f2ng cu\u1ed1i c\u1ee7a b\u1ea3ng \u2013 Xem l\u1ea1i b\u00e0i Ph\u1ea7n 2)<\/p>\n<blockquote>\n<p>If\u00a0ActiveCell.Row &lt;= <strong>8<\/strong> And ActiveCell.Row &gt;= <strong>DongCuoi<\/strong> Then<\/p>\n<p>\u2026<\/p>\n<p>End\u00a0If<\/p>\n<\/blockquote>\n<p>L\u01b0u\u00a0\u00fd l\u00e0 N\u1ebfu D\u00f2ng Cu\u1ed1i c\u1ee7a b\u1ea3ng &lt;8 (B\u1ea3ng kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u)\u00a0th\u00ec ch\u00fang ta ph\u1ea3i lo\u1ea1i tr\u01b0\u1eddng h\u1ee3p n\u00e0y\u00a0\u0111i =&gt; C\u1ea7n l\u1ed3ng th\u00eam 1 h\u00e0m\u00a0IF<\/p>\n<blockquote>\n<p>IF DongCuoi &lt;8 Then<\/p>\n<p>Exit Sub<\/p>\n<p>ElseIf\u00a0ActiveCell.Row &lt;=\u00a0<strong>8<\/strong>\u00a0And ActiveCell.Row &gt;=\u00a0<strong>DongCuoi<\/strong>\u00a0Then<\/p>\n<p>\u2026<\/p>\n<p>End\u00a0If<\/p>\n<\/blockquote>\n<p>X\u00f3a n\u1ed9i dung\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn: L\u00e0m tr\u1ed1ng n\u1ed9i dung\u00a0\u1edf d\u00f2ng\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn, t\u1eeb c\u1ed9t A t\u1edbi c\u1ed9t D trong Sheet1<\/p>\n<blockquote>\n<p>Sheet1.Range(\u201cA\u201d &amp; ActiveCell.Row &amp; \u201c:\u201d &amp; \u201cD\u201d &amp; ActiveCell.Row).ClearContents<\/p>\n<\/blockquote>\n<p>S\u1eafp x\u1ebfp l\u1ea1i n\u1ed9i dung trong b\u1ea3ng\u00a0\u0111\u1ec3 lo\u1ea1i b\u1ecf d\u00f2ng tr\u1ed1ng xen k\u1ebd: Record macro\u00a0\u0111\u1ec3 t\u00ecm hi\u1ec3u l\u1ec7nh S\u1eafp x\u1ebfp d\u1eef li\u1ec7u trong b\u1ea3ng danh s\u00e1ch =&gt; Vi\u1ec7c s\u1eafp x\u1ebfp n\u00e0y s\u1ebd lo\u1ea1i b\u1ecf d\u00f2ng tr\u1ed1ng xen k\u1ebd v\u1edbi d\u1eef li\u1ec7u trong b\u1ea3ng.<\/p>\n<blockquote>\n<p>ActiveWorkbook.Worksheets(\u201cSheet1\u201d).Sort.SortFields.Clear<br \/>\nActiveWorkbook.Worksheets(\u201cSheet1\u201d).Sort.SortFields.Add Key:=Range(\u201cA8:A24\u201d), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal<br \/>\nWith ActiveWorkbook.Worksheets(\u201cSheet1\u201d).Sort<br \/>\n.SetRange Range(\u201cA7:D24\u201d)<br \/>\n.Header = xlYes<br \/>\n.MatchCase = False<br \/>\n.Orientation = xlTopToBottom<br \/>\n.SortMethod = xlPinYin<br \/>\n.Apply<br \/>\nEnd With<\/p>\n<\/blockquote>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta c\u00f3 Sub X\u00f3a d\u1eef li\u1ec7u trong VBA nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13081 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic08.png\" width=\"1300\" height=\"486\" title=\"pic08\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_Gan_Macro_vao_nut_lenh_Xoa\"><\/span>3. G\u00e1n Macro v\u00e0o n\u00fat l\u1ec7nh X\u00f3a<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>T\u1ea1o n\u00fat l\u1ec7nh X\u00f3a gi\u1ed1ng nh\u01b0 n\u00fat l\u1ec7nh Th\u00eam m\u1edbi \/ L\u01b0u (Xem l\u1ea1i Ph\u1ea7n 1)<\/li>\n<li>G\u00e1n Macro v\u00e0o n\u00fat l\u1ec7nh X\u00f3a<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13082 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic09.png\" width=\"672\" height=\"514\" title=\"pic09\"><\/p>\n<p>B\u00e2y gi\u1edd ch\u00fang ta ch\u1ecdn b\u1ea5t k\u1ef3 1 d\u00f2ng trong b\u1ea3ng d\u1eef li\u1ec7u v\u00e0 b\u1ea5m v\u00e0o n\u00fat l\u1ec7nh X\u00f3a\u00a0\u0111\u1ec3 xem k\u1ebft qu\u1ea3\u00a0\u0111\u00e3\u00a0\u0111\u00fang nh\u01b0\u00a0\u00fd mu\u1ed1n ch\u01b0a nh\u00e9.<\/p>\n<p>K\u1ebft qu\u1ea3 ho\u00e0n th\u00e0nh s\u1ebd nh\u01b0 sau (v\u00ed d\u1ee5 v\u1edbi tr\u01b0\u1eddng h\u1ee3p x\u00f3a NV003)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13083 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/pic10.png\" width=\"750\" height=\"426\" title=\"pic10\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_Ket_luan\"><\/span>4. K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Khi\u00a0\u1ee9ng d\u1ee5ng VBA v\u00e0o c\u00f4ng vi\u1ec7c, ch\u00fang ta c\u1ea7n ph\u1ea3i x\u00e1c\u00a0\u0111\u1ecbnh r\u00f5 n\u1ed9i dung tr\u00ecnh t\u1ef1 c\u00f4ng vi\u1ec7c b\u1eb1ng l\u1eddi tr\u01b0\u1edbc, sau\u00a0\u0111\u00f3 m\u1edbi t\u1eebng b\u01b0\u1edbc th\u1ef1c hi\u1ec7n c\u00f4ng vi\u1ec7c th\u00f4ng qua VBA<\/p>\n<p>\u1ede b\u00e0i h\u1ecdc n\u00e0y c\u00f3 th\u00eam vi\u1ec7c S\u1eafp x\u1ebfp n\u1ed9i dung sau m\u1ed7i l\u1ea7n x\u00f3a =&gt; C\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi vi\u1ec7c S\u1eafp x\u1ebfp n\u1ed9i dung sau m\u1ed7i l\u1ea7n L\u01b0u n\u1ed9i dung =&gt; Nh\u01b0 v\u1eady vi\u1ec7c Th\u00eam m\u1edbi n\u1ed9i dung c\u0169ng s\u1ebd\u00a0\u0111\u01b0\u1ee3c t\u1ef1\u00a0\u0111\u1ed9ng s\u1eafp x\u1ebfp l\u1ea1i b\u1ea3ng d\u1eef li\u1ec7u.<\/p>\n<p>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=\"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<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-200.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5566,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5565","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5565","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=5565"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5565\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5566"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5565"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5565"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5565"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}