{"id":10729,"date":"2025-01-14T23:23:51","date_gmt":"2025-01-14T23:23:51","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/cach-lay-thong-tin-trong-bang-danh-sach-chi-voi-1-click-chuot-bang-vba-trong-excel\/"},"modified":"2025-01-14T23:23:51","modified_gmt":"2025-01-14T23:23:51","slug":"cach-lay-thong-tin-trong-bang-danh-sach-chi-voi-1-click-chuot-bang-vba-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/cach-lay-thong-tin-trong-bang-danh-sach-chi-voi-1-click-chuot-bang-vba-trong-excel\/","title":{"rendered":"C\u00e1ch l\u1ea5y th\u00f4ng tin trong b\u1ea3ng danh s\u00e1ch ch\u1ec9 v\u1edbi 1 click chu\u1ed9t b\u1eb1ng VBA trong Excel"},"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\u00a03 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\/2025\/01\/pic1.png\" width=\"583\" height=\"248\" title=\"pic1\"><\/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-6786f206d8d59\" 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-lay-thong-tin-trong-bang-danh-sach-chi-voi-1-click-chuot.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-lay-thong-tin-trong-bang-danh-sach-chi-voi-1-click-chuot.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-lay-thong-tin-trong-bang-danh-sach-chi-voi-1-click-chuot.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-lay-thong-tin-trong-bang-danh-sach-chi-voi-1-click-chuot.html#2_Cach_thuc_hien\" title=\"2. C\u00e1ch th\u1ef1c hi\u1ec7n\">2. C\u00e1ch th\u1ef1c hi\u1ec7n<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Yeu_cau\"><\/span><strong>Y\u00eau c\u1ea7u<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>L\u1ea5y d\u1eef li\u1ec7u t\u1eeb B\u1ea3ng danh s\u00e1ch v\u00e0o c\u00e1c\u00a0\u00f4 nh\u1eadp d\u1eef li\u1ec7u t\u01b0\u01a1ng\u00a0\u1ee9ng m\u1ed7i khi click chu\u1ed9t v\u00e0o d\u00f2ng b\u1ea5t k\u1ef3 c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u<\/li>\n<li>Th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y ngay khi sheet\u00a0\u0111ang kh\u00f3a<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Cach_lam\"><\/span><strong>C\u00e1ch l\u00e0m<\/strong><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 l\u00e0m quen v\u1edbi c\u00e1c s\u1ef1 ki\u1ec7n x\u1ea3y ra trong\u00a0Work Sheet. M\u1ed7i khi ch\u00fang ta l\u00e0m m\u1ed9t h\u00e0nh\u00a0\u0111\u1ed9ng g\u00ec tr\u00ean Sheet th\u00ec\u00a0\u0111\u1ec1u c\u00f3 th\u1ec3 coi l\u00e0 1 s\u1ef1 ki\u1ec7n: Thay\u00a0\u0111\u1ed5i cell\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn, thay\u00a0\u0111\u1ed5i n\u1ed9i dung trong 1 cell, double click v\u00e0o 1 v\u1ecb tr\u00ed\u2026<\/p>\n<p>C\u1ee5 th\u1ec3 trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ch\u00fang ta s\u1ebd l\u00e0m vi\u1ec7c v\u1edbi s\u1ef1 ki\u1ec7n; Thay\u00a0\u0111\u1ed5i cell\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn, c\u1ee5 th\u1ec3 h\u01a1n l\u00e0:<\/p>\n<ul>\n<li>D\u00f2ng ch\u1ee9a\u00a0\u00f4\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn n\u1eb1m trong v\u00f9ng B\u1ea3ng d\u1eef li\u1ec7u<\/li>\n<li>D\u00f2ng n\u00e0y ph\u1ea3i ch\u1ee9a n\u1ed9i dung, kh\u00f4ng ph\u1ea3i d\u00f2ng tr\u1ed1ng<\/li>\n<li>Th\u1ef1c hi\u1ec7n s\u1ef1 ki\u1ec7n bao g\u1ed3m vi\u1ec7c\u00a0\u0111\u1ea3m b\u1ea3o sheet v\u1eabn\u00a0\u1edf ch\u1ebf\u00a0\u0111\u1ed9 Protect (kh\u00f3a sheet) m\u1ed7i khi k\u1ebft th\u00fac s\u1ef1 ki\u1ec7n<\/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>\u0110\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y, ch\u00fang ta c\u1ea7n ch\u00fa\u00a0\u00fd m\u1ed9t s\u1ed1 v\u1ea5n\u00a0\u0111\u1ec1 sau:<\/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\/2025\/01\/vba101_92019-nho-14.gif\" title=\"vba101_92019-nho-14\"><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-215.gif\" title=\"ex101_92019-nho-215\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>L\u1ec7nh x\u00e1c\u00a0\u0111\u1ecbnh d\u00f2ng\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn<\/li>\n<li>L\u1ec7nh l\u1ea5y d\u1eef li\u1ec7u\u00a0\u1edf d\u00f2ng\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn\u00a0\u0111\u1ec3\u00a0\u0111\u01b0a v\u00e0o n\u1ed9i dung c\u00e1c\u00a0\u00f4 B3, B5, D3, D5 t\u01b0\u01a1ng\u00a0\u1ee9ng theo t\u1eebng c\u1ed9t<\/li>\n<\/ul>\n<p>Trong VBA, l\u1ec7nh x\u00e1c\u00a0\u0111\u1ecbnh d\u00f2ng\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn l\u00e0:<\/p>\n<blockquote>\n<p>ActiveCell.Row<\/p>\n<\/blockquote>\n<p>L\u1ea5y d\u1eef li\u1ec7u\u00a0\u1edf d\u00f2ng\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn v\u00e0o c\u00e1c\u00a0\u00f4 nh\u1eadp d\u1eef li\u1ec7u nh\u01b0 sau:<\/p>\n<blockquote>\n<p>With Sheet1<br \/>\n.Cells(3, 2).Value = .Cells(a, 1).Value\u00a0 \u00a0 \u2018Ma nhan vien<br \/>\n.Cells(5, 2).Value = .Cells(a, 2).Value\u00a0 \u00a0 \u2018Ho ten<br \/>\n.Cells(3, 4).Value = .Cells(a, 3).Value\u00a0 \u00a0 \u2018Ngay sinh<br \/>\n.Cells(5, 4).Value = .Cells(a, 4).Value\u00a0 \u00a0 \u2018Bo phan<br \/>\nEnd With<\/p>\n<\/blockquote>\n<p>K\u1ebft h\u1ee3p v\u1edbi c\u00e1c thao t\u00e1c M\u1edf kh\u00f3a, kh\u00f3a sheet ch\u00fang ta c\u00f3 c\u00e2u l\u1ec7nh nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13045 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/le1bb87nh-lc6b0u-ne1bb99i-dung-pic04.png\" width=\"674\" height=\"295\" title=\"le1bb87nh-lc6b0u-ne1bb99i-dung-pic04\"><\/p>\n<p>B\u01b0\u1edbc ti\u1ebfp theo, ch\u00fang ta g\u00e1n Sub n\u00e0y v\u00e0o s\u1ef1 ki\u1ec7n Thay\u00a0\u0111\u1ed5i trong Sheet1 nh\u01b0 sau:<\/p>\n<ul>\n<li>Double click v\u00e0o Sheet 1 trong ph\u1ea7n VBA Project<\/li>\n<li>Ch\u1ecdn\u00a0WorkSheet &gt; SelectionChange<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13046 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/le1bb87nh-lc6b0u-ne1bb99i-dung-pic05.png\" width=\"988\" height=\"207\" title=\"le1bb87nh-lc6b0u-ne1bb99i-dung-pic05\"><\/p>\n<p>Trong s\u1ef1 ki\u1ec7n n\u00e0y, ch\u00fang ta c\u1ea7n thi\u1ebft l\u1eadp m\u1ed9t s\u1ed1\u00a0\u0111i\u1ec1u ki\u1ec7n nh\u01b0 sau:<\/p>\n<ul>\n<li>D\u00f2ng\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn ph\u1ea3i n\u1eb1m trong b\u1ea3ng danh s\u00e1ch: c\u1ee5 th\u1ec3 l\u00e0 s\u1ed1 d\u00f2ng ph\u1ea3i &gt;7<\/li>\n<li>D\u00f2ng c\u00f3 ch\u1ee9a n\u1ed9i dung: X\u00e9t t\u1edbi d\u00f2ng cu\u1ed1i c\u00f9ng c\u00f3 d\u1eef li\u1ec7u trong b\u1ea3ng danh s\u00e1ch &lt;= D\u00f2ng cu\u1ed1i<\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13048 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/le1bb87nh-lc6b0u-ne1bb99i-dung-pic07.png\" width=\"1591\" height=\"355\" title=\"le1bb87nh-lc6b0u-ne1bb99i-dung-pic07\"><\/p>\n<p>B\u00e2y gi\u1edd ch\u00fang ta th\u1eed click v\u00e0o d\u00f2ng b\u1ea5t k\u1ef3 trong b\u1ea3ng Danh s\u00e1ch\u00a0\u0111\u1ec3 ki\u1ec3m tra xem l\u1ec7nh VBA\u00a0\u0111\u00e3 ch\u1ea1y\u00a0\u0111\u00fang ch\u01b0a 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 4: X\u00f3a n\u1ed9i dung trong b\u1ea3ng danh s\u00e1ch<\/p>\n<p>\u00a0<\/p>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/kRNLDgwY9JE\" width=\"854\" height=\"480\" frameborder allowfullscreen=\"allowfullscreen\"><\/iframe>\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\/2025\/01\/vba101_92019-nho-14.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10730,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10729","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\/10729","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=10729"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10729\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10730"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10729"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10729"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10729"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}