{"id":12519,"date":"2025-01-15T09:15:12","date_gmt":"2025-01-15T09:15:12","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/tao-bang-du-lieu-khong-cong-thuc-voi-vba\/"},"modified":"2025-01-15T09:15:12","modified_gmt":"2025-01-15T09:15:12","slug":"tao-bang-du-lieu-khong-cong-thuc-voi-vba","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/tao-bang-du-lieu-khong-cong-thuc-voi-vba\/","title":{"rendered":"T\u1ea1o b\u1ea3ng d\u01b0 li\u1ec7u kh\u00f4ng c\u00f4ng th\u1ee9c v\u1edbi Vba."},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\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-67877c9ebcdb4\" 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-1\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/tao-bang-du-lieu-khong-cong-thuc-voi-vba.html#Tao_bang_du_lieu_khong_cong_thuc_voi_Vba_trong_Excel\" title=\"T\u1ea1o b\u1ea3ng d\u1eef li\u1ec7u kh\u00f4ng c\u00f4ng th\u1ee9c v\u1edbi Vba trong Excel.\">T\u1ea1o b\u1ea3ng d\u1eef li\u1ec7u kh\u00f4ng c\u00f4ng th\u1ee9c v\u1edbi Vba trong Excel.<\/a>\n<ul class=\"ez-toc-list-level-2\">\n<li class=\"ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/tao-bang-du-lieu-khong-cong-thuc-voi-vba.html#Tao_bang_du_lieu_khong_cong_thuc_voi_vba_tao_bang_du_lieu_khong_cong_thuc_voi_vba_trong_excel\" title=\"T\u1ea1o b\u1ea3ng d\u1eef li\u1ec7u kh\u00f4ng c\u00f4ng th\u1ee9c v\u1edbi vba (tao bang du lieu khong cong thuc voi vba trong excel)\">T\u1ea1o b\u1ea3ng d\u1eef li\u1ec7u kh\u00f4ng c\u00f4ng th\u1ee9c v\u1edbi vba (tao bang du lieu khong cong thuc voi vba trong excel)<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1><span class=\"ez-toc-section\" id=\"Tao_bang_du_lieu_khong_cong_thuc_voi_Vba_trong_Excel\"><\/span>T\u1ea1o b\u1ea3ng d\u1eef li\u1ec7u kh\u00f4ng c\u00f4ng th\u1ee9c v\u1edbi Vba trong Excel.<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p><em>(tao bang du lieu khong cong thuc voi vba trong excel)<\/em><\/p>\n<p>B\u00ecnh th\u01b0\u1eddng b\u1ea3ng d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n th\u01b0\u1eddng c\u00f3 r\u1ea5t nhi\u1ec1u c\u00f4ng th\u1ee9c, ch\u00ednh ch\u00fang l\u00e0 th\u1ee7 ph\u1ea1m cho s\u1ef1 l\u00e0m vi\u1ec7c \u00ec \u1ea1ch c\u1ee7a Excel, V\u1edbi gi\u1ea3i ph\u00e1p sau, b\u1ea1n kh\u00f4ng c\u1ea7n d\u00f9ng c\u00f4ng th\u1ee9c n\u1eefa, gi\u00fap b\u1ea1n t\u0103ng t\u1ed1c excel, gi\u1ea3m dung l\u01b0\u1ee3ng c\u1ee7a file excel. V\u1edbi c\u01a1 ch\u1ebf \u0111\u1ed9ng, d\u1ec5 thi\u1ebft l\u1eadp, kh\u00f4ng c\u1ea7n qu\u00e1 th\u00f4ng th\u1ea1o vba b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng \u00e1p d\u1ee5ng cho b\u1ea3ng t\u00ednh c\u1ee7a m\u00ecnh.<br \/>\nTrong video c\u0169ng cung c\u1ea5p m\u1ed9t s\u1ed1 l\u1eddi gi\u1ea3i cho nh\u1eefng b\u00e0i to\u00e1n nh\u01b0 ch\u1ed1t th\u1eddi gian khi nh\u1eadp d\u1eef li\u1ec7u, hay ch\u1ec9nh s\u1eeda d\u1eef li\u1ec7u v\u1eeba nh\u1eadp.<em>(tao bang du lieu khong cong thuc voi vba trong excel)<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-984 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/functionvba-time-0_13_3419__-1024x576-1.png\" alt=\"tao bang du lieu khong cong thuc voi vba\" width=\"1024\" height=\"576\" title=\"functionvba-time-0_13_3419__-1024x576-1\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tao_bang_du_lieu_khong_cong_thuc_voi_vba_tao_bang_du_lieu_khong_cong_thuc_voi_vba_trong_excel\"><\/span>T\u1ea1o b\u1ea3ng d\u1eef li\u1ec7u kh\u00f4ng c\u00f4ng th\u1ee9c v\u1edbi vba<em> (tao bang du lieu khong cong thuc voi vba trong excel)<\/em><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n:<\/strong><\/p>\n<p>+T\u1ea1o m\u1ed9t b\u1ea3ng setting<\/p>\n<p>-G\u1ed3m nhi\u1ec1u h\u00e0ng.<\/p>\n<p>-T\u1ed1i thi\u1ec3u ph\u1ea3i c\u00f3 4 c\u1ed9t.<\/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-79.gif\" title=\"vba101_92019-nho-79\"><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-408.gif\" title=\"ex101_92019-nho-408\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>+Th\u00eam code vba \u0111\u00e3 vi\u1ebft s\u1eb5n, v\u00e0 vi\u1ebft m\u1ed9t v\u00e0i d\u00f2ng l\u1ec7nh \u0111\u01a1n gi\u1ea3n.<\/p>\n<p>+C\u1ea5u h\u00ecnh b\u1ea3ng setting \u0111\u1ec3 \u0111\u1eb7t \u0111\u01b0\u1ee3c ch\u1ee9c n\u0103ng mong mu\u1ed1n ( c\u00e1i n\u00e0y v\u00f4 c\u00f9ng \u0111\u01a1n gi\u1ea3n).<\/p>\n<p>-M\u1ed7i m\u1ed9t d\u00f2ng \u0111\u1ea1i di\u1ec7n cho m\u1ed9t c\u1ed9t d\u1eef li\u1ec7u.<\/p>\n<p>\u2013 C\u1ed9t \u0111\u1ea7u ti\u00ean ch\u1ee9a c\u00f4ng th\u1ee9c ch\u1ec9 t\u1edbi c\u1ed9t k\u1ebft qu\u1ea3.<\/p>\n<p>-C\u1ed9t th\u1ee9 2 ch\u1ee9a c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n, b\u1ea1n vi\u1ebft c\u00f4ng th\u1ee9c n\u00e0y nh\u01b0 b\u00ecnh th\u01b0\u1eddng, n\u00f3 ch\u00ednh l\u00e0 c\u00f4ng th\u1ee9c cho \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a c\u1ed9t k\u1ebft qu\u1ea3. ( g\u1ecdi l\u00e0 c\u1ed9t \u0111i\u1ec1u ki\u1ec7n v\u1edbi c\u00f4ng th\u1ee9c \u0111i\u1ec1u ki\u1ec7n)<\/p>\n<p>-C\u1ed9t th\u1ee9 3 ch\u1ee9a m\u1ed9t c\u00f4ng th\u1ee9c tr\u1ea3 l\u1ea1i True ho\u1eb7c False<\/p>\n<p>\u2013 C\u00e1c c\u1ed9t c\u00f2n l\u1ea1i ch\u1ee9a c\u00e1c\u00a0 tham chi\u1ebfu \u0111\u1ea7u v\u00e0o c\u1ee7a c\u1ed9t k\u1ebft qu\u1ea3.( g\u1ecdi l\u00e0 c\u00e1c c\u1ed9t input)<\/p>\n<p>+C\u00e1ch l\u00e0m vi\u1ec7c:<\/p>\n<p>-M\u1ed7i khi m\u1ed9t \u00f4 b\u1ecb thay \u0111\u1ed5i, Excel ki\u1ec3m tra xem \u00f4 \u0111\u00f3 c\u00f3 n\u1eb1m trong c\u00e1c v\u00f9ng input kh\u00f4ng, n\u1ebfu c\u00f3 th\u00ec n\u00f3 ti\u1ebfp t\u1ee5c b\u01b0\u1edbc sau.<\/p>\n<p>-T\u1eeb v\u1ecb tr\u00ed \u00f4 thay \u0111\u1ed5i n\u00f3 t\u00ednh to\u00e1n xem \u00f4 k\u1ebft qu\u1ea3 t\u01b0\u01a1ng \u1ee9ng l\u00e0 g\u00ec.<\/p>\n<p>-T\u1eeb \u0111\u00f3 n\u00f3 t\u00ednh c\u00f4ng th\u1ee9c\u00a0 \u0111i\u1ec1u ki\u1ec7n, n\u1ebfu c\u00f4ng th\u1ee9c \u0111i\u1ec1u ki\u1ec7n tr\u1ea3 l\u1ea1i true th\u00ec n\u00f3 ti\u1ebfp t\u1ee5c.<\/p>\n<p>-T\u00ecm c\u00f4ng th\u1ee9c t\u01b0\u01a1ng \u1ee9ng v\u1edbi \u00f4 thay \u0111\u1ed5i v\u00e0 t\u00ednh to\u00e1n c\u00f4ng th\u1ee9c \u1ea5y, r\u1ed3i ghi k\u1ebft qu\u1ea3 l\u1ea1i.<\/p>\n<p>-B\u1ea3ng d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n kh\u00f4ng c\u1ea7n m\u1ed9t c\u00f4ng th\u1ee9c m\u00e0 v\u1eabn ho\u1ea1t \u0111\u1ed9ng \u1ed5n \u1ed5n.<\/p>\n<p>To\u00e0n b\u1ed9 n\u1ed9i dung, file code v\u00e0 file th\u1ef1c h\u00e0nh \u0111\u01b0\u1ee3c \u0111\u0103ng t\u1ea3i tr\u00ean video:<\/p>\n<iframe loading=\"lazy\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/H1JFztdOw3c?feature=oembed\" frameborder allowfullscreen><\/iframe>\n<p><em>(tao bang du lieu khong cong thuc voi vba trong excel)<\/em><\/p>\n<p style=\"text-align: right\">Ngu\u1ed3n: Nguy\u1ec5n Ng\u1ecdc Thu Hi\u1ec1n<\/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\/2025\/01\/vba101_92019-nho-79.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":12520,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-12519","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\/12519","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=12519"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/12519\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/12520"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=12519"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=12519"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=12519"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}