{"id":5525,"date":"2024-12-16T03:25:41","date_gmt":"2024-12-16T03:25:41","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/16\/tu-dong-to-mau-dong-cua-o-duoc-chon-trong-bang-bang-vba\/"},"modified":"2024-12-16T03:25:41","modified_gmt":"2024-12-16T03:25:41","slug":"tu-dong-to-mau-dong-cua-o-duoc-chon-trong-bang-bang-vba","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/16\/tu-dong-to-mau-dong-cua-o-duoc-chon-trong-bang-bang-vba\/","title":{"rendered":"T\u1ef1 \u0111\u1ed9ng t\u00f4 m\u00e0u d\u00f2ng c\u1ee7a \u00f4 \u0111\u01b0\u1ee3c ch\u1ecdn trong b\u1ea3ng b\u1eb1ng VBA"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>M\u1ed9t ng\u00e0y x\u1ea5u tr\u1eddi n\u00e0o\u00a0\u0111\u00f3 b\u1ea1n ph\u1ea3i l\u00e0m vi\u1ec7c v\u1edbi 1 b\u1ea3ng t\u00ednh h\u00e0ng ngh\u00ecn d\u00f2ng, h\u00e0ng ch\u1ee5c c\u1ed9t v\u00e0 n\u00f3 khi\u1ebfn b\u1ea1n hoa m\u1eaft lu\u00f4n.\u00a0\u1ee8c ch\u1ebf nh\u1ea5t l\u00e0 b\u1ea1n kh\u00f4ng bi\u1ebft v\u1ecb tr\u00ed\u00a0b\u1ea1n\u00a0\u0111ang ch\u1ecdn l\u00e0 d\u00f2ng n\u00e0o d\u00f9\u00a0excel c\u00f3 h\u1ed7 tr\u1ee3 b\u1ea1n nh\u01b0ng b\u1ea1n mu\u1ed1n tr\u1ef1c quan h\u01a1n, d\u1ec5 nh\u00ecn h\u01a1n. H\u00e3y\u00a0\u0111\u1ec3 H\u1ecdc\u00a0Excel Online gi\u00fap b\u1ea1n m\u1ed9t th\u1ee7 thu\u1eadt nh\u1ecf\u00a0\u0111\u1ec3 gi\u1ea3i t\u1ecfa s\u1ef1\u00a0\u1ee9c ch\u1ebf n\u00e0y nh\u00e9:<\/p>\n<p>=&gt;\u00a0\u1ee8ng d\u1ee5ng VBA\u00a0\u0111\u1ec3 t\u1ef1\u00a0\u0111\u1ed9ng t\u00f4 m\u00e0u d\u00f2ng c\u1ee7a\u00a0\u00f4\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn trong b\u1ea3ng.<\/p>\n<p>Ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u th\u00f4ng qua v\u00ed d\u1ee5 sau nh\u00e9:<\/p>\n<p>Cho b\u1ea3ng t\u00ednh:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13210 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/te1bbb1-tc3b4-mc3a0u-ve1bb8b-trc3ad-c3b4-pic01.png\" width=\"1675\" height=\"387\" title=\"te1bbb1-tc3b4-mc3a0u-ve1bb8b-trc3ad-c3b4-pic01\"><\/p>\n<p><strong>B\u01b0\u1edbc 1<\/strong>: Th\u1ef1c hi\u1ec7n ghi macro v\u1edbi thao t\u00e1c t\u00f4 m\u00e0u\u00a0n\u1ec1n\u00a0t\u1ea1i v\u1ecb tr\u00ed b\u1ea5t k\u1ef3\u00a0\u0111ang ch\u1ecdn<\/p>\n<ul>\n<li>Trong tab Developer &gt; Ch\u1ecdn Record macro<\/li>\n<li>Th\u1ef1c hi\u1ec7n t\u00f4 m\u00e0u cho d\u00f2ng t\u1ea1i v\u1ecb tr\u00ed\u00a0\u0111ang ch\u1ecdn<\/li>\n<li>T\u1eaft ch\u1ee9c n\u0103ng Record Macro sau khi ho\u00e0n th\u00e0nh thao t\u00e1c<\/li>\n<li>M\u1edf c\u1eeda s\u1ed5 VBA\u00a0\u0111\u1ec3 ki\u1ec3m tra k\u1ebft qu\u1ea3 c\u00e2u l\u1ec7nh<\/li>\n<\/ul>\n<p>\u0110\u00e2y l\u00e0 c\u00e2u l\u1ec7nh ch\u00fang ta thu\u00a0\u0111\u01b0\u1ee3c:<\/p>\n<p>\u00a0<\/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-197.gif\" title=\"vba101_92019-nho-197\"><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-480.gif\" title=\"ex101_92019-nho-480\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13212 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/te1bbb1-tc3b4-mc3a0u-ve1bb8b-trc3ad-c3b4-pic03.png\" width=\"712\" height=\"338\" title=\"te1bbb1-tc3b4-mc3a0u-ve1bb8b-trc3ad-c3b4-pic03\"><\/p>\n<p>\u1ede\u00a0\u0111\u00e2y c\u00e1c c\u00e2u l\u1ec7nh Select ch\u00fang ta kh\u00f4ng c\u1ea7n quan t\u00e2m, v\u00ec m\u1ee5c ti\u00eau l\u00e0 vi\u1ec7c t\u00f4 m\u00e0u v\u00e0o v\u1ecb tr\u00ed ch\u00fang ta ch\u1ecdn, n\u00ean ch\u00fang ta c\u00f3 th\u1ec3 ch\u1ec9 ra trong VBA r\u00f5 n\u1ed9i dung n\u00e0y.<\/p>\n<p>\u0110i\u1ec1u c\u1ea7n quan t\u00e2m l\u00e0 c\u00e2u l\u1ec7nh t\u00f4 m\u00e0u n\u1ec1n.<\/p>\n<blockquote>\n<p><strong> With Selection.Interior<\/strong><br \/>\n.Pattern = xlSolid<br \/>\n.PatternColorIndex = xlAutomatic<br \/>\n.ThemeColor = xlThemeColorAccent6<br \/>\n.TintAndShade = 0.799981688894314<br \/>\n.PatternTintAndShade = 0<br \/>\n<strong>End With<\/strong><\/p>\n<\/blockquote>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Ti\u1ebfp theo ch\u00fang ta ghi l\u1ea1i Macro cho thao t\u00e1c b\u1ecf t\u00f4 m\u00e0u n\u1ec1n (No Fill)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13213 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/te1bbb1-tc3b4-mc3a0u-ve1bb8b-trc3ad-c3b4-pic04.png\" width=\"600\" height=\"402\" title=\"te1bbb1-tc3b4-mc3a0u-ve1bb8b-trc3ad-c3b4-pic04\"><\/p>\n<p>C\u00e2u l\u1ec7nh b\u1ecf t\u00f4 m\u00e0u n\u1ec1n trong VBA thu\u00a0\u0111\u01b0\u1ee3c nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong> With Selection.Interior<\/strong><br \/>\n.Pattern = xlNone<br \/>\n.TintAndShade = 0<br \/>\n.PatternTintAndShade = 0<br \/>\n<strong>End With<\/strong><\/p>\n<\/blockquote>\n<p><strong>B\u01b0\u1edbc 3<\/strong>: T\u1ea1o s\u1ef1 ki\u1ec7n SelectionChange trong\u00a0Worksheet<\/p>\n<p>Trong c\u1eeda s\u1ed5 VBA, click\u00a0\u0111\u00fap v\u00e0o sheet\u00a0c\u1ea7n\u00a0\u00e1p d\u1ee5ng, ch\u1ecdn s\u1ef1 ki\u1ec7n SelectionChange<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13214 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/te1bbb1-tc3b4-mc3a0u-ve1bb8b-trc3ad-c3b4-pic05.png\" width=\"1082\" height=\"234\" title=\"te1bbb1-tc3b4-mc3a0u-ve1bb8b-trc3ad-c3b4-pic05\"><\/p>\n<p><strong>B\u01b0\u1edbc 4<\/strong>: X\u00e2y d\u1ef1ng quy tr\u00ecnh ho\u1ea1t\u00a0\u0111\u1ed9ng cho l\u1ec7nh VBA<\/p>\n<p>Tr\u00ecnh t\u1ef1 nh\u01b0 sau:<\/p>\n<ul>\n<li>X\u00e1c\u00a0\u0111\u1ecbnh v\u1ecb tr\u00ed\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn v\u00e0 gi\u1edbi h\u1ea1n b\u1ea3ng d\u1eef li\u1ec7u<\/li>\n<li>B\u1ecf t\u00f4 m\u00e0u to\u00e0n b\u1ed9 n\u1ed9i dung trong b\u1ea3ng (b\u1ecf t\u00f4 m\u00e0u c\u1ee7a c\u00e1c d\u00f2ng\u00a0\u0111\u00e3 ch\u1ecdn tr\u01b0\u1edbc\u00a0\u0111\u00f3)<\/li>\n<li>T\u00f4 m\u00e0u cho v\u1ecb tr\u00ed d\u00f2ng\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn<\/li>\n<li>N\u1ebfu ch\u1ecdn t\u1edbi v\u1ecb tr\u00ed b\u00ean ngo\u00e0i b\u1ea3ng th\u00ec s\u1ebd b\u1ecf t\u00f4 m\u00e0u to\u00e0n b\u1ed9 b\u1ea3ng<\/li>\n<\/ul>\n<p>\u1ede\u00a0\u0111\u00e2y ch\u00fang ta c\u00f3 th\u1ec3 gi\u1edbi h\u1ea1n b\u1ea3ng t\u00ednh\u00a0\u0111\u1ec3\u00a0\u00e1p d\u1ee5ng th\u1eed v\u1edbi v\u00f9ng A5:M10<\/p>\n<p>C\u00e2u l\u1ec7nh VBA s\u1ebd l\u00e0:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13216 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/te1bbb1-tc3b4-mc3a0u-ve1bb8b-trc3ad-c3b4-pic06.png\" width=\"737\" height=\"601\" title=\"te1bbb1-tc3b4-mc3a0u-ve1bb8b-trc3ad-c3b4-pic06\"><\/p>\n<p>C\u00e1c b\u1ea1n l\u01b0u\u00a0\u00fd\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng Target\u00a0\u1edf\u00a0\u0111\u00e2y l\u00e0\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng\u00a0\u0111\u01b0\u1ee3c quy\u00a0\u0111\u1ecbnh s\u1eb5n c\u1ee7a\u00a0Excel,\u00a0\u0111\u01b0\u1ee3c hi\u1ec3u l\u00e0 v\u1ecb tr\u00ed\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn trong b\u1ea3ng t\u00ednh.<\/p>\n<p>T\u00f9y theo\u00a0\u0111\u1ed9 r\u1ed9ng c\u1ee7a b\u1ea3ng t\u00ednh m\u00e0 ch\u00fang ta thi\u1ebft l\u1eadp gi\u1edbi h\u1ea1n cho ph\u00f9 h\u1ee3p<\/p>\n<p>T\u01b0\u01a1ng t\u1ef1 nh\u01b0 v\u1eady c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n th\u00eam vi\u1ec7c t\u00f4 m\u00e0u cho c\u1ed9t c\u1ee7a d\u00f2ng\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn.<\/p>\n<p>Quy tr\u00ecnh\u00a0\u0111\u00fang ph\u1ea3i l\u00e0 B\u1ecf t\u00f4 m\u00e0u c\u1ea3 b\u1ea3ng tr\u01b0\u1edbc, sau\u00a0\u0111\u00f3 m\u1edbi t\u00f4 m\u00e0u v\u00e0o v\u1ecb tr\u00ed\u00a0\u0111\u01b0\u1ee3c ch\u1ecdn.<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n th\u00e0nh c\u00f4ng!<\/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-197.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5526,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5525","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\/5525","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=5525"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5525\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5526"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5525"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5525"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5525"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}