{"id":8282,"date":"2024-12-22T04:28:39","date_gmt":"2024-12-22T04:28:39","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/tao-formdata-trong-excel\/"},"modified":"2024-12-22T04:28:39","modified_gmt":"2024-12-22T04:28:39","slug":"tao-formdata-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/tao-formdata-trong-excel\/","title":{"rendered":"Tao FormData trong Excel"},"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-676795766ef16\" 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-formdata.html#Tao_FormData_trong_Excel\" title=\"T\u1ea1o FormData trong Excel\">T\u1ea1o FormData 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-formdata.html#1_Tao_FormData_ban_dau\" title=\"1. T\u1ea1o FormData ban \u0111\u1ea7u.\">1. T\u1ea1o FormData ban \u0111\u1ea7u.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/tao-formdata.html#2_Tao_mot_bang_setting\" title=\"2. T\u1ea1o m\u1ed9t b\u1ea3ng setting.\">2. T\u1ea1o m\u1ed9t b\u1ea3ng setting.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/tao-formdata.html#3_Them_code_va_Edit_code_vba\" title=\"3. Th\u00eam code v\u00e0 Edit code vba.\">3. Th\u00eam code v\u00e0 Edit code vba.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/tao-formdata.html#4_Thiet_lap_bang_setting\" title=\"4. Thi\u1ebft l\u00e2p b\u1ea3ng setting.\">4. Thi\u1ebft l\u00e2p b\u1ea3ng setting.<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1 style=\"text-align: center\"><span class=\"ez-toc-section\" id=\"Tao_FormData_trong_Excel\"><\/span>T\u1ea1o FormData trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>Trong Excel, nhi\u1ec1u khi b\u1ea1n c\u1ea7n nh\u1eadp d\u1eef li\u1ec7u, sau \u0111\u00f3 mu\u1ed1n \u0111\u01b0a d\u1eef li\u1ec7u \u0111\u00f3 v\u00e0o trong m\u1ed9t b\u1ea3ng. Ng\u01b0\u1eddi ta g\u1ecdi vi\u1ec7c \u0111\u00f3 l\u00e0 t\u1ea1o FormData, d\u1eef li\u1ec7u nh\u1eadp tr\u00ean m\u1ed9t Form \u0111\u1ecbnh s\u1eb5n, d\u1eef li\u1ec7u nh\u1eadp v\u00e0o Form s\u1ebd \u0111\u01b0\u1ee3c Save \u1edf m\u1ed9t n\u01a1i n\u00e0o \u0111\u00f3. N\u00f3i chung Excel c\u0169ng h\u1ed7 tr\u1ee3 vi\u1ec7c \u0111\u00f3, tuy nhi\u00ean kh\u00e1 ngh\u00e8o n\u00e0n. M\u00e0 b\u1ea1n mu\u1ed1n tho\u00e1t kh\u1ecfi s\u1ef1 ngh\u00e8o n\u00e0n \u0111\u00f3 th\u00ec ph\u1ea3i d\u00f9ng \u0111\u1ebfn VBA. VBA th\u00ec l\u1ea1i qu\u00e1 s\u1ee9c \u0111\u1ed1i v\u1edbi b\u1ea1n, b\u1edfi c\u00e1c c\u00e2u l\u1ec7nh, c\u00e1c quan h\u1ec7 ph\u1ee9c t\u1ea1p\u2026 B\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u00fap b\u1ea1n t\u1ea1o FormData m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng, nhanh ch\u00f3ng, h\u1ea7u nh\u01b0 kh\u00f4ng ph\u1ea3i vi\u1ebft code, v\u1edbi c\u00e1c \u0111\u1eb7c \u0111i\u1ec3m n\u1ed5i b\u1eadt:<\/p>\n<p>+Vi\u1ebft code r\u1ea5t \u00edt, h\u1ea7u nh\u01b0 ch\u1ec9 c\u00f3 c\u00f4ng th\u1ee9c v\u00e0 c\u00f4ng th\u1ee9c, nh\u1eefng th\u1ee9 b\u1ea1n r\u1ea5t th\u00e0nh th\u1ea1o.<\/p>\n<p>+ \u00c1p d\u1ee5ng \u0111\u01b0\u1ee3c cho m\u1ecdi lo\u1ea1i b\u1ea3ng d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n.<\/p>\n<p>+ T\u00e1i s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3cc nhi\u1ec1u l\u1ea7n.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"1_Tao_FormData_ban_dau\"><\/span>1. T\u1ea1o FormData ban \u0111\u1ea7u.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-2358\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/untitled-time-0_00_2606__-1024x576-1.png\" alt=\"T\u1ea1o FormData\" width=\"1024\" height=\"576\" title=\"untitled-time-0_00_2606__-1024x576-1\"><\/p>\n<p>\u1ede b\u01b0\u1edbc n\u00e0y b\u1ea1n t\u1ea1o m\u1ed9t Form nh\u1eadp li\u1ec7u nh\u01b0 b\u00ecnh th\u01b0\u1eddng, \u1edf \u0111\u00e2y m\u00ecnh l\u00e0 cho n\u00f3 gi\u1ed1ng v\u1edbi m\u1ed9t c\u1eeda s\u1ed5 Window. Form c\u1ee7a b\u1ea1n c\u00f3 th\u1ec3 l\u00e0 t\u00f9y th\u00edch, d\u1ea1ng b\u1ea3ng, d\u1ea1ng c\u00e1c \u00f4 ph\u00e2n t\u00e1n. Sau \u0111\u00f3 thi\u1ebft k\u1ebf b\u1ea3ng d\u1eef li\u1ec7u, n\u01a1i d\u1eef li\u1ec7u c\u1ee7a Form s\u1ebd \u0111\u01b0\u1ee3c l\u01b0u. Form c\u1ee7a m\u00ecnh c\u00f3 5 tham s\u1ed1, b\u1ea3ng d\u1eef li\u1ec7u s\u1ebd c\u00f3 8 c\u1ed9t.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"2_Tao_mot_bang_setting\"><\/span>2. T\u1ea1o m\u1ed9t b\u1ea3ng setting.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2359 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/untitled-time-0_01_1017__-1024x576-1.png\" alt=\"FormData\" width=\"1024\" height=\"576\" title=\"untitled-time-0_01_1017__-1024x576-1\"><\/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-341.gif\" title=\"vba101_92019-nho-341\"><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-753.gif\" title=\"ex101_92019-nho-753\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>M\u1ed7i m\u1ed9t FormData s\u1ebd c\u1ea7n c\u00f3 m\u1ed9t b\u1ea3ng setting, b\u1ea3ng n\u00e0y s\u1ebd ch\u1ee9a c\u00e1c c\u00f4ng th\u1ee9c, n\u01a1i b\u1ea1n d\u00e0nh nhi\u1ec1u th\u1eddi gian nh\u1ea5t \u0111\u1ec3 x\u00e2y d\u1ef1ng. N\u00f3 g\u1ed3m hai d\u00f2ng, s\u1ed1 c\u1ed9t th\u00ec nhi\u1ec1u h\u01a1n 1 c\u1ed9t so v\u1edbi s\u1ed1 c\u1ed9t trong b\u1ea3ng d\u1eef li\u1ec7u. \u1ede \u0111\u00e2y b\u1ea3ng d\u1eef li\u1ec7u c\u00f3 8 c\u1ed9t, v\u1eady n\u00f3 s\u1ebd l\u00e0 9 c\u1ed9t, m\u00ecnh \u0111\u1eb7t t\u00ean b\u1ea3ng n\u00e0y m\u1ed9t c\u00e1i Name l\u00e0 \u201cBangSetting\u201d.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"3_Them_code_va_Edit_code_vba\"><\/span>3. Th\u00eam code v\u00e0 Edit code vba.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2360 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/untitled-time-0_09_4518__-1024x576-1.png\" alt=\"Form Data\" width=\"1024\" height=\"576\" title=\"untitled-time-0_09_4518__-1024x576-1\"><\/p>\n<p>+ \u0110\u1ea7u ti\u00ean c\u00e1c b\u1ea1n t\u1ea3i\u00a0 module<strong> mFormData<\/strong> v\u1ec1 m\u00e1y, v\u00e0 import n\u00f3 v\u00e0o trong VBA.<\/p>\n<p>+ Sau \u0111\u00f3 ch\u00e8n th\u00eam m\u1ed9t module m\u1edbi.<\/p>\n<p>+ \u1ee8ng v\u1edbi m\u1ed9t FormData b\u1ea1n t\u1ea1o m\u1ed9t Sub Vba nh\u01b0 tr\u00ean h\u00ecnh. B\u1ea1n c\u00f3 th\u1ec3 copy cho nhanh, ch\u00fang ch\u1ec9 kh\u00e1c nhau \u1edf \u201cBangSetting\u201d, \u0111\u00f3 l\u00e0 t\u00ean c\u1ee7a b\u1ea3ng setting m\u00e0 li\u00ean k\u1ebft v\u1edbi FormData c\u1ee7a b\u1ea1n.<\/p>\n<p>+ Sau \u0111\u00f3 g\u1eafn macro cho n\u00fat b\u1ea5m \u201cTh\u00eam\u201d v\u00e0o sub n\u00e0y.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"4_Thiet_lap_bang_setting\"><\/span>4. Thi\u1ebft l\u00e2p b\u1ea3ng setting.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2361 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/untitled-time-0_06_0621__-1024x576-1.png\" alt=\"form data\" width=\"1024\" height=\"576\" title=\"untitled-time-0_06_0621__-1024x576-1\"><\/p>\n<p>T\u1ea1o li\u00ean k\u1ebft b\u1ea3ng d\u1eef li\u1ec7u v\u1edbi b\u1ea3ng setting:<\/p>\n<p>+T\u1ea1i \u00f4 \u0111\u1ea7u ti\u00ean c\u1ee7a b\u1ea3ng setting, b\u1ea1n g\u00f5 c\u00f4ng th\u1ee9c =XXX, v\u1edbi XXX ch\u00ednh l\u00e0 \u0111\u1ecba ch\u1ec9 c\u1ee7a h\u00e0ng d\u1eef li\u1ec7u cu\u1ed1i c\u00f9ng c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u.<\/p>\n<p>T\u1ea1o th\u00f4ng b\u00e1o:<\/p>\n<p>+ C\u00e1c \u00f4 c\u1ee7a h\u00e0ng th\u1ee9 2 trong b\u1ea3ng setting b\u1ea1n nh\u1eadn c\u00e1c c\u00f4ng th\u1ee9c d\u00f9ng \u0111\u1ec3 ki\u1ec3m tra d\u1eef li\u1ec7u.C\u00e1c c\u00f4ng th\u1ee9c n\u00e0y b\u1ea1n d\u00f9ng \u0111\u1ec3 ki\u1ec3m tra t\u00ednh h\u1ee3p l\u1ec7 c\u1ee7a d\u1eef li\u1ec7u trong Form. \u201c\u201d c\u00f3 ngh\u0129a l\u00e0 ok.<\/p>\n<p>T\u1ea1o li\u00ean k\u1ebft d\u1eef li\u1ec7u:<\/p>\n<p>+ M\u1ed7i khi nh\u1ea5n n\u00fat \u201cTh\u00eam\u201d, gi\u00e1 tr\u1ecb c\u00f4ng th\u1ee9c c\u1ee7a \u00f4 th\u1ee9 (1,x) b\u1ea3ng setting s\u1ebd \u0111\u01b0\u1ee3c ghi v\u00e0o m\u1ed9t h\u00e0ng m\u1edbi c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u t\u1ea1i v\u1ecb tr\u00ed (*,x-1), x&gt;1.<\/p>\n<p>C\u01a1 ch\u1ebf ho\u1ea1t \u0111\u1ed9ng:<\/p>\n<p>+ M\u1ed7i khi ng\u01b0\u1eddi d\u00f9ng nh\u1ea5n n\u00fat \u201cTh\u00eam\u201d, Excel ki\u1ec3m tra gi\u00e1 tr\u1ecb c\u1ee7a c\u00e1c \u00f4 n\u1eb1m \u1edf h\u00e0ng 2 c\u1ee7a b\u1ea3ng setting. N\u1ebfu c\u00f3 m\u1ed9t \u00f4 c\u00f3 n\u1ed9i dung kh\u00e1c r\u1ed7ng, m\u1ed9t th\u00f4ng b\u00e1o s\u1ebd xu\u1ea5t hi\u1ec7n \u0111\u1ec3 h\u1ecfi ng\u01b0\u1eddi d\u00f9ng c\u00f3 ti\u1ebfp t\u1ee5c l\u01b0u d\u1eef li\u1ec7u n\u1eefa hay kh\u00f4ng? Sau \u0111\u00f3 n\u00f3 s\u1ebd th\u00eam c\u00e1c h\u00e0ng m\u1edbi v\u00e0o trong b\u1ea3ng d\u1eef li\u1ec7u, v\u00e0 copy c\u00e1c gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng \u1edf b\u1ea3ng setting v\u00e0o c\u00e1c d\u00f2ng m\u1edbi n\u00e0y. T\u1ea1o ra h\u00e0nh \u0111\u1ed9ng l\u01b0u d\u1eef li\u1ec7u.<\/p>\n<p>To\u00e0n b\u1ed9 n\u1ed9i dung h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o video sau, r\u1ea5t chi ti\u1ebft v\u00e0 \u0111\u1ea7y \u0111\u1ee7.<\/p>\n<iframe loading=\"lazy\" title=\"T\u1ea1o FormData trong excel.\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/RGUkX9Bz4iY?feature=oembed\" frameborder allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\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\/2024\/12\/vba101_92019-nho-341.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8283,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8282","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\/8282","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=8282"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8282\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8283"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8282"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8282"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8282"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}