{"id":5098,"date":"2024-12-09T04:26:22","date_gmt":"2024-12-09T04:26:22","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/vba-tu-dong-dinh-dang-cac-tai-khoan-ke-toan-trong-danh-muc-he-thong-tk-tren-excel\/"},"modified":"2024-12-09T04:26:22","modified_gmt":"2024-12-09T04:26:22","slug":"vba-tu-dong-dinh-dang-cac-tai-khoan-ke-toan-trong-danh-muc-he-thong-tk-tren-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/vba-tu-dong-dinh-dang-cac-tai-khoan-ke-toan-trong-danh-muc-he-thong-tk-tren-excel\/","title":{"rendered":"(VBA) T\u1ef1 \u0111\u1ed9ng \u0111\u1ecbnh d\u1ea1ng c\u00e1c t\u00e0i kho\u1ea3n k\u1ebf to\u00e1n trong danh m\u1ee5c h\u1ec7 th\u1ed1ng TK tr\u00ean Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>T\u1eeb b\u00e0i vi\u1ebft\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/tu-dong-dinh-dang-cac-tai-khoan-ke-toan-trong-danh-muc-thong-tk-tren-excel.html\">https:\/\/blog.hocexcel.online\/tu-dong-dinh-dang-cac-tai-khoan-ke-toan-trong-danh-muc-thong-tk-tren-excel.html<\/a>\u00a0c\u1ee7a\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/author\/duongquan211287\">D\u01b0\u01a1ng Qu\u00e2n<\/a>\u00a0T\u00f4i xin gi\u1edbi thi\u1ec7u m\u1ed9t ph\u01b0\u01a1ng ph\u00e1p kh\u00e1c d\u00f9ng VBA nh\u01b0 sau :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-15111 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dmtk1.jpg\" width=\"857\" height=\"453\" title=\"dmtk1\"><\/p>\n<p>B\u00e2y gi\u1edd ta s\u1ebd \u0111\u1ecbnh d\u1ea1ng n\u00f3 theo quy lu\u1eadt nh\u01b0 sau\u00a0 :<\/p>\n<ul>\n<li>N\u1ebfu l\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/danh-muc-he-thong-tai-khoan-moi-nhat-theo-thong-tu-1332016tt-btc.html\">t\u00e0i kho\u1ea3n<\/a> c\u1ea5p 1 (C\u00f3 3 k\u00fd t\u1ef1) th\u00ec c\u1ea3 h\u00e0ng \u0111\u00f3 ch\u1eef \u0111\u1eadm. c\u00e1c c\u1ed9t s\u1ed1 [S\u1ed1 t\u00e0i kho\u1ea3n] v\u00e0 [c\u1ea5p ] \u0111\u01b0\u1ee3c c\u0103n l\u1ec1 b\u00ean tr\u00e1i<\/li>\n<li>N\u1ebfu l\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/danh-muc-he-thong-tai-khoan-moi-nhat-theo-thong-tu-1332016tt-btc.html\">t\u00e0i kho\u1ea3n<\/a> c\u1ea5p\u00a02 (C\u00f3\u00a04 k\u00fd t\u1ef1) th\u00ec c\u1ea3 h\u00e0ng \u0111\u00f3 ch\u1eef th\u01b0\u1eddng. c\u00e1c c\u1ed9t s\u1ed1 [S\u1ed1 t\u00e0i kho\u1ea3n] v\u00e0 [c\u1ea5p ] \u0111\u01b0\u1ee3c c\u0103n l\u1ec1\u00a0v\u00e0o gi\u1eefa<\/li>\n<li>N\u1ebfu l\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/danh-muc-he-thong-tai-khoan-moi-nhat-theo-thong-tu-1332016tt-btc.html\">t\u00e0i kho\u1ea3n<\/a> c\u1ea5p 3 (C\u00f3\u00a05 k\u00fd t\u1ef1) th\u00ec c\u1ea3 h\u00e0ng \u0111\u00f3 ch\u1eef nghi\u00eam. c\u00e1c c\u1ed9t s\u1ed1 [S\u1ed1 t\u00e0i kho\u1ea3n] v\u00e0 [c\u1ea5p ] \u0111\u01b0\u1ee3c c\u0103n l\u1ec1 b\u00ean ph\u1ea3i<\/li>\n<\/ul>\n<p>Ta s\u1eed d\u1ee5ng module sau :<\/p>\n<blockquote>\n<p>Sub DingDang()<br \/>\nDim Cls As Range, Nguon As Range<br \/>\nSet Nguon = Sheet2.Range(\u201cA2:A\u201d &amp; Sheet2.Cells(Sheet2.Rows.Count, \u201cA\u201d).End(xlUp).Row)<br \/>\nFor Each Cls In Nguon<br \/>\nSelect Case Cls(1, 3).Value<br \/>\nCase Is = 1<br \/>\nCls.Resize(1, 3).Font.Bold = True<br \/>\nUnion(Cls, Cls(1, 3)).HorizontalAlignment = xlLeft<br \/>\nCase Is = 2<br \/>\nUnion(Cls, Cls(1, 3)).HorizontalAlignment = xlCenter<br \/>\nCase Is = 3<br \/>\nCls.Resize(1, 3).Font.Italic = True<br \/>\nUnion(Cls, Cls(1, 3)).HorizontalAlignment = xlRight<br \/>\nEnd Select<br \/>\nNext Cls<br \/>\nSet Cls = Nothing<br \/>\nEnd Sub<\/p>\n<\/blockquote>\n<p>v\u00e0 \u0111\u00e2y l\u00e0 th\u00e0nh qu\u1ea3 :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-15112\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dmtk2.jpg\" width=\"797\" height=\"453\" title=\"dmtk2\"><\/p>\n<p>VBA \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng cho nhi\u1ec1u l\u0129nh v\u1ef1c, trong \u0111\u00f3 c\u00f3 c\u1ea3 k\u1ebf to\u00e1n. C\u00e1c b\u1ea1n n\u00ean t\u00ecm hi\u1ec3u s\u00e2u h\u01a1n v\u1ec1 VBA \u0111\u1ec3 nh\u1eefng \u1ee9ng d\u1ee5ng c\u1ee7a VBA gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft s\u1ed1 li\u1ec7u tr\u00ean k\u1ebf to\u00e1n nhanh ch\u00f3ng, khoa h\u1ecdc.<\/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 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\/2024\/12\/ex101_92019-nho-430.gif\" title=\"ex101_92019-nho-430\"><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\/2024\/12\/vba101_92019-nho-168.gif\" title=\"vba101_92019-nho-168\"><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-430.gif\" title=\"ex101_92019-nho-430\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u00a0<\/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\/2024\/12\/ex101_92019-nho-430.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5099,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5098","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\/5098","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=5098"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5098\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5099"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5098"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5098"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5098"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}