{"id":4539,"date":"2024-12-06T11:28:48","date_gmt":"2024-12-06T11:28:48","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/06\/huong-dan-tao-userform-tra-cuu-du-lieu\/"},"modified":"2024-12-06T11:28:48","modified_gmt":"2024-12-06T11:28:48","slug":"huong-dan-tao-userform-tra-cuu-du-lieu","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/06\/huong-dan-tao-userform-tra-cuu-du-lieu\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn t\u1ea1o userform tra c\u1ee9u d\u1eef li\u1ec7u"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>C\u00f3 kh\u00e1 nhi\u1ec1u b\u1ea1n h\u1ecfi v\u1ec1 c\u00e1ch tra c\u1ee9u theo t\u1eeb kh\u00f3a, d\u1eef li\u1ec7u g\u1eafn v\u00e0o <strong>Textbox<\/strong>. H\u00f4m nay m\u00ecnh xin gi\u1edbi thi\u1ec7u m\u1ed9t c\u00e1ch \u0111\u1ec3 th\u1ef1c hi\u1ec7n \u0111i\u1ec1u n\u00e0y. B\u1ea1n c\u00f3 th\u1ebb theo d\u00f5i video \u0111\u1ec3 h\u00ecnh dung ra Userform n\u00e0y gi\u00fap ch\u00fang ta nh\u1eadp li\u1ec7u nhanh v\u00e0 ch\u00ednh x\u00e1c c\u0169ng nh\u01b0 hi\u1ec7u qu\u1ea3 h\u01a1n \u0111\u1ebfn m\u1ee9c n\u00e0o:<\/p>\n<p style=\"text-align: center\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/Qg4HwXedZgk\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p><strong>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t Sheet DMHH nh\u01b0 sau:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2639 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-300x267-1.jpg\" width=\"300\" height=\"267\" title=\"1-300x267-1\"><\/p>\n<p>V\u00e0 1 Sheet <strong>TEST<\/strong> khi c\u00e1c b\u1ea1n click \u0111\u00fap v\u00e0o m\u1ed9t \u00f4 trong c\u1ed9t A th\u00ec hi\u1ec7n ra c\u00e1i form , b\u1ea1n g\u00f5 t\u1eeb kh\u00f3a v\u00e0o \u00f4 tra c\u1ee9u d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c l\u1ecdc ra.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-2640 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-300x169-1.jpg\" width=\"542\" height=\"305\" title=\"2-300x169-1\"><\/p>\n<p>Sau \u0111\u00f3 b\u1ea1n ch\u1ecdn c\u00e1c m\u00e3 c\u1ea7n g\u1eafn v\u00e0o sheet Test:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2641 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-205x300-1.jpg\" width=\"213\" height=\"312\" title=\"3-205x300-1\"><\/p>\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-366.gif\" title=\"ex101_92019-nho-366\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y kh\u00f4ng kh\u00f3 . \u0110\u1ea7u ti\u00ean c\u00e1c b\u1ea1n Nh\u00e1n alt + F11 v\u00e0o Visual basic editor, v\u00e0o th\u1ebb Insert\/Userform t\u1ea1o 1 form m\u1edbi v\u00e0 \u0111\u1ed5i t\u00ean th\u00e0nh FrmDMHH<\/p>\n<p>V\u1ebd 1 textbox mang t\u00ean TXTFIND v\u1edbi th\u00f4ng s\u1ed1 nh\u01b0 h\u00ecnh :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2643 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/5-300x169-1.jpg\" width=\"504\" height=\"284\" title=\"5-300x169-1\"><\/p>\n<p>V\u1ebd ti\u1ebfp 1 c\u00e1i combobox mang t\u00ean CBDMHH v\u1edbi th\u00f4ng s\u1ed1 nh\u01b0 h\u00ecnh :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2644 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/6-300x169-1.jpg\" width=\"300\" height=\"169\" title=\"6-300x169-1\"><\/p>\n<p>V\u1ebd ti\u1ebfp 1 c\u00e1i listbox mang t\u00ean LBDMHH v\u1edbi th\u00f4ng s\u1ed1 nh\u01b0 h\u00ecnh :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2645 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/7-300x169-1.jpg\" width=\"300\" height=\"169\" title=\"7-300x169-1\"><\/p>\n<p>V\u1ebd ti\u1ebfp 1 c\u00e1i button\u00a0 mang t\u00ean CMDADD v\u1edbi th\u00f4ng s\u1ed1 nh\u01b0 h\u00ecnh :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-2646 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/9-300x169-1.jpg\" width=\"300\" height=\"169\" title=\"9-300x169-1\"><\/p>\n<p>C\u00e1c b\u1ea1n v\u00e0o th\u1ebb insert \/module t\u1ea1o 1 module m\u1edbi sau \u0111\u00f3 d\u00e1n v\u00e0o c\u00e1c h\u00e0m sau : (H\u00e0m n\u00e0y \u0111\u01b0\u1ee3c m\u00ecnh s\u1eeda l\u1ea1i c\u1ee7a\u00a0<strong>ndu96081631 <\/strong>b\u00ean di\u1ec5n \u0111\u00e0n gi\u1ea3i ph\u00e1p excel. Xin ch\u00e2n th\u00e0nh c\u1ea3m \u01a1n th\u1ea7y<\/p>\n<blockquote>\n<p>Xem th\u00eam: Kh\u00f3a <a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-ke-toan.html\">h\u1ecdc Excel k\u1ebf to\u00e1n \u01a1\u0309 Ha\u0300 N\u00f4\u0323i<\/a><\/p>\n<\/blockquote>\n<ul>\n<li>H\u00e0m n\u00e0y \u0111\u1ec3 tra c\u1ee9u t\u1eeb kh\u00f3a theo 1 c\u1ed9t \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh<\/li>\n<\/ul>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/1f9bafda7a71bbd4ac8c2617d5d87dda\">Gist<\/a>.<\/div>\n<ul>\n<li>H\u00e0m n\u00e0y \u0111\u1ec3 tra c\u1ee9u t\u1eeb kh\u00f3a trong t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t<\/li>\n<\/ul>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/9a995d7b5788d883b3ea69ef7f296350\">Gist<\/a>.<\/div>\n<ul>\n<li>H\u00e0m n\u00e0y \u0111\u1ec3 \u0111o th\u1eddi gian khi ta g\u00f5 k\u00fd t\u1ef1 v\u00e0o textbox<\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/e297d360d1c606c4c46f0115fbdd534d\">Gist<\/a>.<\/div>\n<p>Sau \u0111\u00f3 c\u00e1c b\u1ea1n click chu\u1ed9t ph\u1ea3i l\u00ean userform ch\u1ecdn view code g\u1eafn v\u00e0o c\u00e1c code :<\/p>\n<ol>\n<li><strong>N\u1ea1p c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng c\u1ea7n thi\u1ebft khi Userform kh\u1edfi \u0111\u1ed9ng<\/strong><\/li>\n<\/ol>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/db632f0c03a896b6d24335cd8bbbc6ef\">Gist<\/a>.<\/div>\n<blockquote>\n<p>\u0110\u0103ng k\u00ed ngay:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-lap-trinh-vba-trong-excel\">l\u1edbp h\u1ecdc VBA \u1edf H\u00e0 N\u1ed9i<\/a>\u00a01 th\u1ea7y 1 tr\u00f2<\/p>\n<\/blockquote>\n<ol start=\"2\">\n<li><strong>S\u1ef1 ki\u1ec7n textbox change khi ta g\u00f5 k\u00fd t\u1ef1 v\u00e0o :<\/strong><\/li>\n<\/ol>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/a0096fa2b22d9a2ceffc60469edd85a4\">Gist<\/a>.<\/div>\n<ol start=\"3\">\n<li><strong>S\u1ef1 ki\u1ec7n Listbox change<br \/>\n<\/strong><\/li>\n<\/ol>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/4f24e91fd9260ec00b7d4ec793955377\">Gist<\/a>.<\/div>\n<ol start=\"4\">\n<li><strong>\u0110\u01b0a c\u00e1c m\u00e3 \u0111\u01b0\u1ee3c ch\u1ecdn xu\u1ed1ng sheet b\u1eb1ng Button<\/strong><\/li>\n<\/ol>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/409f4cd4d4f6ae54773f28a85f5e0fa9\">Gist<\/a>.<\/div>\n<ol start=\"5\">\n<li><strong>Gi\u1ea3i ph\u00f3ng b\u1ed9 nh\u1edb khi tho\u00e1t form<\/strong><\/li>\n<\/ol>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/d2df27a90965b8aa31620c750d1cde31\">Gist<\/a>.<\/div>\n<ol start=\"6\">\n<li><strong>Quay l\u1ea1i sheet TEST \u0111\u1eb7t s\u1ef1 ki\u1ec7n :<\/strong><\/li>\n<\/ol>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/e5e32ff317b79206d09c313a07a91f7d\">Gist<\/a>.<\/div>\n<p>Xong r\u1ed3i \u0111\u1ea5y b\u00e2y gi\u1edd c\u00e1c b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng . Trong sheet TEST trong c\u1ed9t A t\u1eeb \u00f4 A2 tr\u1edf xu\u1ed1ng b\u1ea1n ch\u1ecdn 1 \u00f4 r\u1ed3i nh\u00e1y \u0111\u00fap chu\u1ed9t, userform s\u1ebd hi\u1ec7n ra \u0111\u1ec3 tra c\u1ee9u v\u00e0 ch\u1ecdn m\u00e3\u00a0 g\u1eafn xu\u1ed1ng sheet.<\/p>\n<p>\u0110\u1ec3 hi\u1ec3u \u0111\u01b0\u1ee3c c\u00e1c \u0111o\u1ea1n code tr\u00ean b\u1ea1n c\u1ea7n ph\u1ea3i c\u00f3 ki\u1ebfn th\u1ee9c t\u01b0\u01a1ng \u0111\u1ed1i v\u1eefng v\u1ec1 VBA. Nh\u01b0ng kh\u00f4ng c\u00f3 vi\u1ec7c g\u00ec kh\u00f3 n\u1ebfu b\u1ea1n l\u00e0 ng\u01b0\u1eddi ham h\u1ecdc h\u1ecfi.<\/p>\n<p>M\u00ecnh xin c\u1ea3m \u01a1n anh <strong>CHANH_TQ<\/strong> di\u1ec5n \u0111\u00e0n giaiphapexcel \u0111\u00e3 gi\u00fap m\u00ecnh v\u1ec1 k\u1ef9 thu\u1eadt s\u1eed d\u1ee5ng Dictionary. B\u1ea1n <strong>Duc Thanh Nguyen <\/strong>t\u1eeb <a href=\"http:\/\/blog.ezworkapp.com\" target=\"_blank\" rel=\"noopener noreferrer\">H\u1ecdc Excel Online<\/a> \u0111\u00e3 gi\u00fap \u0111\u1ee1 m\u00ecnh c\u00e1ch s\u1eed d\u1ee5ng s\u1ef1 ki\u1ec7n v\u00e0 c\u00e1c k\u1ef9 thu\u1eadt kh\u00e1c. Hy v\u1ecdng t\u00e0i li\u1ec7u tr\u00ean h\u1eefu \u00edch v\u1edbi c\u00f4ng vi\u1ec7c c\u1ee7a c\u00e1c b\u1ea1n!<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u1ee9ng d\u1ee5ng t\u1ed1t Excel v\u00e0o trong c\u00f4ng vi\u1ec7c, ch\u00fang ta kh\u00f4ng ch\u1ec9 n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m m\u00e0 c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u1ea3 c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel. Nh\u1eefng h\u00e0m n\u00e2ng cao gi\u00fap \u00e1p d\u1ee5ng t\u1ed1t v\u00e0o c\u00f4ng vi\u1ec7c nh\u01b0 SUMIFS, COUNTIFS, SUMPRODUCT, INDEX + MATCH\u2026 Nh\u1eefng c\u00f4ng c\u1ee5 th\u01b0\u1eddng s\u1eed d\u1ee5ng l\u00e0 Data validation, Conditional formatting, Pivot table\u2026<\/p>\n<p>To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc<\/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\/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-366.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4540,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-4539","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\/4539","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=4539"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4539\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4540"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4539"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4539"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4539"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}