{"id":11529,"date":"2025-01-15T03:57:46","date_gmt":"2025-01-15T03:57:46","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-kiem-tra-dung-luong-moi-trang-tinh-trong-bang-tinh\/"},"modified":"2025-01-15T03:57:46","modified_gmt":"2025-01-15T03:57:46","slug":"cach-kiem-tra-dung-luong-moi-trang-tinh-trong-bang-tinh","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-kiem-tra-dung-luong-moi-trang-tinh-trong-bang-tinh\/","title":{"rendered":"C\u00e1ch ki\u1ec3m tra dung l\u01b0\u1ee3ng m\u1ed7i trang t\u00ednh trong b\u1ea3ng t\u00ednh"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3\u00a0 m\u1ed9t b\u1ea3ng t\u00ednh l\u1edbn ch\u1ee9a nhi\u1ec1u trang t\u00ednh. B\u1ea1n mu\u1ed1n ki\u1ec3m tra dung l\u01b0\u1ee3ng c\u1ee7a m\u1ed7i trang t\u00ednh \u0111\u1ec3 quy\u1ebft \u0111\u1ecbnh b\u1ecf trang t\u00ednh n\u00e0o. Sau \u0111\u00e2y l\u00e0 ph\u01b0\u01a1ng ph\u00e1p \u0111\u1ec3 gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1.<\/p>\n<p>V\u1edbi m\u00e3 VBA sau, b\u1ea1n c\u00f3 th\u1ec3 nhanh ch\u00f3ng bi\u1ebft \u0111\u01b0\u1ee3c dung l\u01b0\u1ee3ng m\u1ed7i trang t\u00ednh trong b\u1ea3ng t\u00ednh c\u1ee7a m\u00ecnh. H\u00e3y l\u00e0m nh\u01b0 sau:<\/p>\n<p>1. Nh\u1ea5n <strong>ALT +F11<\/strong>, m\u1edf <strong>Microsoft Visual Basic for Applications<\/strong>.<\/p>\n<p>2. Nh\u1ea5n <strong>Insert<\/strong> &gt; <strong>Module<\/strong>, d\u00e1n \u0111o\u1ea1n m\u00e3 sau v\u00e0o c\u1eeda s\u1ed5 <strong>Module<\/strong>.<\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/2d3f11c6282e66674556c4f086840df1\">Gist<\/a>.<\/div>\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><\/div>\n<div class=\"line number38 index37 alt1\">3. Nh\u1ea5n <strong>F5 <\/strong>\u0111\u1ec3 ch\u1ea1y m\u00e3, m\u1ed9t trang t\u00ednh m\u1edbi s\u1ebd \u0111\u01b0\u1ee3c ch\u00e8n v\u00e0o b\u1ea3ng t\u00ednh hi\u1ec7n h\u00e0nh, trong \u0111\u00f3 ch\u1ee9a t\u00ean v\u00e0 dung l\u01b0\u1ee3ng c\u1ee7a m\u1ed7i trang t\u00ednh, \u0111\u01a1n v\u1ecb l\u00e0 Bit.<\/div>\n<div class=\"line number38 index37 alt1\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"\/\/www.w3.org\/2000\/svg'%20viewBox='0%200%20488%20250'%3E%3C\/svg%3E\" alt=\"doc-check-sheet-size1\" width=\"488\" height=\"250\" data-lazy-src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/doc-check-sheet-size1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/doc-check-sheet-size1.png\" alt=\"doc-check-sheet-size1\" width=\"488\" height=\"250\" title=\"doc-check-sheet-size1\"><\/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":"<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3\u00a0 m\u1ed9t b\u1ea3ng t\u00ednh l\u1edbn ch\u1ee9a nhi\u1ec1u trang t\u00ednh. B\u1ea1n mu\u1ed1n ki\u1ec3m..<\/p>\n","protected":false},"author":1,"featured_media":11530,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11529","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\/11529","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=11529"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11529\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11530"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11529"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11529"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11529"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}