{"id":10828,"date":"2025-01-14T23:58:24","date_gmt":"2025-01-14T23:58:24","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/huong-dan-cach-tao-sheetform-phieu-thu-phieu-chi-tren-excel-vba-phan-5\/"},"modified":"2025-01-14T23:58:24","modified_gmt":"2025-01-14T23:58:24","slug":"huong-dan-cach-tao-sheetform-phieu-thu-phieu-chi-tren-excel-vba-phan-5","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/huong-dan-cach-tao-sheetform-phieu-thu-phieu-chi-tren-excel-vba-phan-5\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1ea1o SheetForm Phi\u1ebfu thu, Phi\u1ebfu chi tr\u00ean Excel VBA \u2013 Ph\u1ea7n 5"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>Ch\u00e0o c\u00e1c b\u1ea1n,<\/p>\n<p>Khi\u00a0 s\u1eed d\u1ee5ng VBA trong\u00a0excel ,\u00a0 ch\u00fang ta th\u01b0\u1eddng ngh\u0129 t\u1edbi vi\u1ec7c s\u1eed d\u1ee5ng\u00a0userform\u00a0\u0111\u1ec3 t\u1ea1o form nh\u1eadp d\u1eef li\u1ec7u. Nh\u01b0ng vi\u1ec7c thi\u1ebft l\u1eadp\u00a0userform th\u01b0\u1eddng kh\u00e1 ph\u1ee9c t\u1ea1p v\u00e0 s\u1eed d\u1ee5ng nhi\u1ec1u code.\u00a0\u0110\u1ed1i v\u1edbi nh\u1eefng b\u1ea1n m\u1edbi ti\u1ebfp c\u1eadn v\u1ec1 VBA th\u00ec vi\u1ec7c s\u1eed d\u1ee5ng\u00a0userform g\u1eb7p nhi\u1ec1u kh\u00f3 kh\u0103n.<\/p>\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y\u00a0 m\u00ecnh s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng SheetForm (form t\u1ea1o tr\u00ean Sheet)\u00a0\u0111\u1ec3 s\u1eed d\u1ee5ng t\u01b0\u01a1ng t\u1ef1 nh\u01b0\u00a0userform. Ph\u1ea1m vi b\u00e0i vi\u1ebft g\u1ed3m:<\/p>\n<ul>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/excel-vba-tao-sheetform-phieu-thu-phieu-chi.html\">B\u00e0i 1: X\u00e2y d\u1ef1ng c\u1ea5u tr\u00fac SheetForm<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/excel-vba-tao-sheetform-phieu-thu-phieu-chi-phan-2.html\">B\u00e0i 2: Vi\u1ebft Code VBA cho thao t\u00e1c M\u1edf v\u00e0\u00a0\u0110\u00f3ng SheetForm<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/excel-vba-tao-sheetform-phieu-thu-phieu-chi-phan-3.html\">B\u00e0i 3: Vi\u1ebft Code VBA cho thao t\u00e1c L\u00e0m m\u1edbi SheetForm<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/excel-vba-tao-sheetform-phieu-thu-phieu-chi-phan-4.html\">B\u00e0i 4: Vi\u1ebft Code VBA cho thao t\u00e1c L\u01b0u SheetForm<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/excel-vba-tao-sheetform-phieu-thu-phieu-chi-phan-5.html\">B\u00e0i 5: B\u1eaby l\u1ed7i trong SheetForm v\u00e0\u00a0\u0111\u00e1nh gi\u00e1 v\u1ec1 ph\u01b0\u01a1ng ph\u00e1p n\u00e0y<\/a><\/li>\n<\/ul>\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-6786fa1f82709\" 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-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/excel-vba-tao-sheetform-phieu-thu-phieu-chi-phan-5.html#Bai_5_Bay_loi_trong_SheetForm_va_danh_gia_ve_phuong_phap_nay\" title=\"B\u00e0i 5: B\u1eaby l\u1ed7i trong SheetForm v\u00e0\u00a0\u0111\u00e1nh gi\u00e1 v\u1ec1 ph\u01b0\u01a1ng ph\u00e1p n\u00e0y:\">B\u00e0i 5: B\u1eaby l\u1ed7i trong SheetForm v\u00e0\u00a0\u0111\u00e1nh gi\u00e1 v\u1ec1 ph\u01b0\u01a1ng ph\u00e1p n\u00e0y:<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/excel-vba-tao-sheetform-phieu-thu-phieu-chi-phan-5.html#Loi_thu_1_Khong_cho_luu_trung_phieu\" title=\"L\u1ed7i th\u1ee9 1: Kh\u00f4ng cho l\u01b0u tr\u00f9ng phi\u1ebfu\">L\u1ed7i th\u1ee9 1: Kh\u00f4ng cho l\u01b0u tr\u00f9ng phi\u1ebfu<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/excel-vba-tao-sheetform-phieu-thu-phieu-chi-phan-5.html#Loi_thu_2_Kiem_tra_nhap_du_noi_dung_yeu_cau_truoc_khi_luu\" title=\"L\u1ed7i th\u1ee9 2: Ki\u1ec3m tra\u00a0nh\u1eadp\u00a0\u0111\u1ee7 n\u1ed9i dung y\u00eau c\u1ea7u\u00a0tr\u01b0\u1edbc khi l\u01b0u\">L\u1ed7i th\u1ee9 2: Ki\u1ec3m tra\u00a0nh\u1eadp\u00a0\u0111\u1ee7 n\u1ed9i dung y\u00eau c\u1ea7u\u00a0tr\u01b0\u1edbc khi l\u01b0u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/excel-vba-tao-sheetform-phieu-thu-phieu-chi-phan-5.html#Danh_gia_ve_viec_su_dung_SheetForm\" title=\"\u0110\u00e1nh gi\u00e1 v\u1ec1 vi\u1ec7c s\u1eed d\u1ee5ng SheetForm\">\u0110\u00e1nh gi\u00e1 v\u1ec1 vi\u1ec7c s\u1eed d\u1ee5ng SheetForm<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Bai_5_Bay_loi_trong_SheetForm_va_danh_gia_ve_phuong_phap_nay\"><\/span>B\u00e0i 5: B\u1eaby l\u1ed7i trong SheetForm v\u00e0\u00a0\u0111\u00e1nh gi\u00e1 v\u1ec1 ph\u01b0\u01a1ng ph\u00e1p n\u00e0y:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Trong b\u00e0i 4, ch\u00fang ta\u00a0\u0111\u00e3 t\u00ecm hi\u1ec3u c\u00e1ch l\u01b0u n\u1ed9i\u00a0 dung t\u1eeb SheetForm Phi\u1ebfu thu\u00a0sang B\u1ea3ng k\u00ea, v\u00e0 c\u00e2u h\u1ecfi\u00a0\u1edf cu\u1ed1i b\u00e0i ch\u00ednh l\u00e0 n\u1ed9i dung ch\u00fang ta s\u1ebd gi\u1ea3i quy\u1ebft\u00a0\u1edf b\u00e0i n\u00e0y:<\/p>\n<ol>\n<li>L\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 ki\u1ec3m tra xem phi\u1ebfu\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c l\u01b0u tr\u01b0\u1edbc\u00a0\u0111\u00f3 ch\u01b0a?<\/li>\n<li>L\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 y\u00eau c\u1ea7u\u00a0 nh\u1eadp\u00a0\u0111\u1ee7 h\u1ebft n\u1ed9i dung c\u1ee7a phi\u1ebfu thu m\u1edbi cho l\u01b0u phi\u1ebfu.<\/li>\n<\/ol>\n<p>\u0110\u00e2y ch\u00ednh l\u00e0 nh\u1eefng l\u1ed7i th\u01b0\u1eddng g\u1eb7p nh\u1ea5t khi s\u1eed d\u1ee5ng SheetForm. V\u00ec v\u1eady k\u1ef9 n\u0103ng b\u1eaby nh\u1eefng l\u1ed7i n\u00e0y l\u00e0 r\u1ea5t c\u1ea7n thi\u1ebft cho ch\u00fang ta trong qu\u00e1 tr\u00ecnh l\u00e0m vi\u1ec7c tr\u00ean VBA.<\/p>\n<blockquote>\n<p>Ti\u0300m hi\u00ea\u0309u ngay:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-lap-trinh-vba-trong-excel\">kho\u0301a ho\u0323c l\u00e2\u0323p tri\u0300nh VBA trong excel<\/a><\/p>\n<\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"Loi_thu_1_Khong_cho_luu_trung_phieu\"><\/span>L\u1ed7i th\u1ee9 1: Kh\u00f4ng cho l\u01b0u tr\u00f9ng phi\u1ebfu<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh phi\u1ebfu c\u00f3 tr\u00f9ng kh\u00f4ng (t\u01b0\u01a1ng\u00a0\u0111\u01b0\u01a1ng v\u1edbi vi\u1ec7c\u00a0 phi\u1ebfu\u00a0\u0111\u00e3\u00a0\u0111\u01b0\u1ee3c l\u01b0u ch\u01b0a),\u00a0 ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m COUNTIF nh\u01b0 sau:<\/p>\n<blockquote>\n<p>=COUNTIF(Bang_Ke!$B$4:$B$32,Phieu_Thu!$B$4)<\/p>\n<\/blockquote>\n<p>Gi\u1ea3i th\u00edch n\u1ed9i dung h\u00e0m:<\/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\/2025\/01\/ex101_92019-nho-227.gif\" title=\"ex101_92019-nho-227\"><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\/2025\/01\/vba101_92019-nho-24.gif\" title=\"vba101_92019-nho-24\"><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-227.gif\" title=\"ex101_92019-nho-227\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Bang_Ke!$B$4:$B$32\u00a0 l\u00e0 v\u00f9ng ch\u1ee9a n\u1ed9i dung S\u1ed1 phi\u1ebfu trong B\u1ea3ng k\u00ea<\/p>\n<p>Phieu_Thu!$B$4\u00a0 l\u00e0 s\u1ed1\u00a0 phi\u1ebfu trong Phi\u1ebfu thu<\/p>\n<p>Nh\u01b0 v\u1eady h\u00e0m COUNTIF s\u1ebd x\u00e1c\u00a0\u0111\u1ecbnh xem s\u1ed1 phi\u1ebfu trong phi\u1ebfu thu\u00a0\u0111\u00e3 xu\u1ea5t hi\u1ec7n trong c\u1ed9t S\u1ed1 phi\u1ebfu trong B\u1ea3ng k\u00ea ch\u01b0a.<\/p>\n<p>K\u1ebft qu\u1ea3 &gt; 0 th\u00ec s\u1ed1 phi\u1ebfu\u00a0\u0111\u00e3 xu\u1ea5t hi\u1ec7n (\u0111\u00e3 tr\u00f9ng, \u0111\u00e3 l\u01b0u)<\/p>\n<p>K\u1ebft qu\u1ea3\u00a0= 0 th\u00ec s\u1ed1 phi\u1ebfu ch\u01b0a xu\u1ea5t hi\u1ec7n (ch\u01b0a l\u01b0u)<\/p>\n<p>Trong c\u1eeda s\u1ed5 VBA, v\u1edbi Sub Luu_Phieu_Thu ch\u00fang ta vi\u1ebft code nh\u01b0 sau:<\/p>\n<p>\u00a0<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12058\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/pic04-3.png\" width=\"942\" height=\"326\" title=\"pic04-3\"><\/p>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y ph\u1ea7n ghi ch\u00fa B\u1eaby l\u1ed7i l\u01b0u tr\u00f9ng phi\u1ebfu, trong\u00a0\u0111\u00f3 ta th\u00f4ng qua vi\u1ec7c s\u1eed d\u1ee5ng h\u00e0m\u00a0IF trong VBA\u00a0\u0111\u1ec3 bi\u1ec7n lu\u1eadn:<\/p>\n<ul>\n<li>If Sheet3.Cells(4, 3).value &gt; 0 then\u00a0 \u00a0: n\u1ebfu k\u1ebft qu\u1ea3\u00a0\u1edf sheet 3,\u00a0\u00f4 C4 (l\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m COUNTIF\u00a0\u0111\u00e3 l\u00e0m\u00a0\u1edf tr\u00ean) l\u1edbn h\u01a1n 0 th\u00ec\u2026<\/li>\n<li>Msgbox \u201cLoi: Da luu phieu\u201d\u00a0 \u00a0s\u1ebd hi\u1ec7n th\u00f4ng b\u00e1o l\u1ed7i\u00a0\u0111\u00e3 l\u01b0u phi\u1ebfu tr\u00ean m\u00e0n h\u00ecnh<\/li>\n<li>Exit Sub\u00a0 \u00a0tho\u00e1t kh\u1ecfi sub, d\u1eebng l\u1ec7nh ngay sau khi hi\u1ec7n th\u00f4ng b\u00e1o l\u1ed7i (xu\u1ea5t hi\u1ec7n l\u1ed7i n\u00e0y th\u00ec d\u1eebng l\u1ec7nh t\u1ea1i\u00a0\u0111\u00e2y)<\/li>\n<li>Else\u00a0 \u00a0n\u1ebfu kh\u00f4ng th\u1ecfa m\u00e3n n\u1ed9i dung trong\u00a0IF th\u00ec s\u1ebd th\u1ef1c\u00a0 hi\u1ec7n thao t\u00e1c sau (t\u1ee9c l\u00e0 k\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m COUNTIF = 0)<\/li>\n<\/ul>\n<p>L\u01b0u\u00a0\u00fd l\u00e0 khi m\u1edf\u00a0\u0111\u1ea7u b\u1eb1ng\u00a0IF th\u00ec k\u1ebft th\u00fac ph\u1ea3i c\u00f3 End\u00a0IF (v\u1ecb tr\u00ed End\u00a0\u00a0If n\u1eb1m sau d\u00f2ng msgbox \u201cHoan thanh\u201d)<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Loi_thu_2_Kiem_tra_nhap_du_noi_dung_yeu_cau_truoc_khi_luu\"><\/span>L\u1ed7i th\u1ee9 2: Ki\u1ec3m tra\u00a0nh\u1eadp\u00a0\u0111\u1ee7 n\u1ed9i dung y\u00eau c\u1ea7u\u00a0tr\u01b0\u1edbc khi l\u01b0u<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 x\u00e1c\u00a0\u0111\u1ecbnh n\u1ed9i dung y\u00eau c\u1ea7u\u00a0\u0111\u00e3 c\u00f3 d\u1eef\u00a0 li\u1ec7u ch\u01b0a, ch\u00fang ta l\u00e0m nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12057 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/pic02-4.png\" width=\"1026\" height=\"399\" title=\"pic02-4\"><\/p>\n<p>T\u1ea1i\u00a0\u00f4 C5 c\u1ee7a sheet\u00a0\u0110i\u1ec1u ki\u1ec7n, d\u00f9ng h\u00e0m:<\/p>\n<blockquote>\n<p>=IF(OR(Phieu_Thu!B6=\u201d\u201d,Phieu_Thu!B8=\u201d\u201d,Phieu_Thu!B10=\u201d\u201d,Phieu_Thu!B12=\u201d\u201d,Phieu_Thu!B14=\u201d\u201d),0,1)<\/p>\n<\/blockquote>\n<p>T\u1eebng\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng trong h\u00e0m\u00a0OR s\u1ebd l\u00e0 m\u1ed9t n\u1ed9i dung y\u00eau c\u1ea7u\u00a0 ph\u1ea3i nh\u1eadp d\u1eef li\u1ec7u. N\u1ebfu b\u1ea5t k\u1ef3 y\u00eau c\u1ea7u n\u00e0o ch\u01b0a nh\u1eadp ( =\u201d\u201d ) th\u00ec s\u1ebd cho k\u1ebft qu\u1ea3 = 0, c\u00f2n n\u1ebfu t\u1ea5t c\u1ea3 c\u00e1c y\u00eau c\u1ea7u\u00a0\u0111\u1ec1u\u00a0\u0111\u00e3 nh\u1eadp th\u00ec s\u1ebd cho k\u1ebft qu\u1ea3 = 1<\/p>\n<p>Trong c\u1eeda s\u1ed5 VBA, v\u1edbi Sub Luu_Phieu_Thu ch\u00fang ta vi\u1ebft code nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12059 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/pic03-4.png\" width=\"946\" height=\"400\" title=\"pic03-4\"><\/p>\n<p>* L\u01b0u\u00a0\u00fd:<\/p>\n<ul>\n<li>Khi vi\u1ebft ti\u1ebfp 1 h\u00e0m\u00a0IF l\u1ed3ng trong h\u00e0m\u00a0IF tr\u01b0\u1edbc\u00a0\u0111\u00f3 th\u00ec ch\u00fang ta s\u1eed d\u1ee5ng ElseIf ch\u1ee9 kh\u00f4ng ph\u1ea3i l\u00e0\u00a0IF<\/li>\n<li>M\u1ed7i h\u00e0m\u00a0IF s\u1ebd c\u00f3 m\u1edf\u00a0\u0111\u1ea7u l\u00e0\u00a0IF, k\u1ebft th\u00fac l\u00e0 End\u00a0IF. N\u1ebfu l\u1ed3ng 1 h\u00e0m\u00a0if kh\u00e1c\u00a0\u0111\u1ed3ng th\u1eddi th\u00ec s\u1eed d\u1ee5ng ElseIF\u00a0\u1edf gi\u1eefa.<\/li>\n<li>N\u1ebfu vi\u1ebft 2 h\u00e0m\u00a0IF ri\u00eang bi\u1ec7t th\u00ec s\u1ebd d\u00f9ng 2 l\u1ea7n\u00a0IF v\u00e0 2 l\u1ea7n End\u00a0IF, v\u00e0 vi\u1ebft t\u00e1ch r\u1eddi kh\u1ecfi nhau.<\/li>\n<\/ul>\n<p>\u0110\u1ec3 r\u00e8n luy\u1ec7n k\u1ef9 n\u0103ng b\u1eaby l\u1ed7i, ch\u00fang ta c\u1ea7n luy\u1ec7n t\u1eadp nhi\u1ec1u\u00a0\u0111\u1ec3 t\u00f9y bi\u1ebfn theo t\u1eebng tr\u01b0\u1eddng h\u1ee3p.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Danh_gia_ve_viec_su_dung_SheetForm\"><\/span>\u0110\u00e1nh gi\u00e1 v\u1ec1 vi\u1ec7c s\u1eed d\u1ee5ng SheetForm<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><strong>1. \u01afu\u00a0\u0111i\u1ec3m:<\/strong><\/p>\n<ul>\n<li>D\u1ec5 s\u1eed d\u1ee5ng, trang tr\u00ed<\/li>\n<li>\u00cdt l\u1ed7i, d\u1ec5 vi\u1ebft code, code ng\u1eafn<\/li>\n<li>Ch\u1ec9 s\u1eed d\u1ee5ng c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng:\u00a0Sheet, Range, Cell m\u00e0 kh\u00f4ng c\u1ea7n quan t\u00e2m t\u1edbi c\u00e1c\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng trong\u00a0UserForm nh\u01b0 Label, textbox, combobox, command button\u2026 =&gt; Gi\u1ea3m\u00a0\u0111i r\u1ea5t nhi\u1ec1u n\u1ed9i dung c\u1ea7n h\u1ecdc v\u1ec1 VBA\u00a0 m\u00e0 v\u1eabn c\u00f3 hi\u1ec7u qu\u1ea3 t\u01b0\u01a1ng\u00a0\u0111\u01b0\u01a1ng.<\/li>\n<li>V\u1edbi nh\u1eefng form l\u1edbn, ph\u1ee9c t\u1ea1p, nhi\u1ec1u\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng c\u1ea7n nh\u1eadp d\u1eef li\u1ec7u th\u00ec vi\u1ec7c s\u1eed d\u1ee5ng s\u1ebd d\u1ec5 h\u01a1n r\u1ea5t nhi\u1ec1u so v\u1edbi\u00a0UserForm<\/li>\n<\/ul>\n<p><strong>2. Nh\u01b0\u1ee3c\u00a0\u00a0\u0111i\u1ec3m:<\/strong><\/p>\n<ul>\n<li>Kh\u00f4ng ph\u00f9 h\u1ee3p\u00a0 v\u1edbi\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng mu\u1ed1n l\u00e0m vi\u1ec7c chuy\u00ean s\u00e2u v\u1ec1 VBA<\/li>\n<li>M\u1ed7i SheetForm s\u1ebd ph\u1ea3i l\u00e0m tr\u00ean 1 Sheet =&gt; L\u00e0m t\u0103ng s\u1ed1 l\u01b0\u1ee3ng Sheet, t\u0103ng dung l\u01b0\u1ee3ng File h\u01a1n so v\u1edbi\u00a0UserForm<\/li>\n<li>Vi\u1ec7c qu\u1ea3n l\u00fd\u00a0\u0110i\u1ec1u ki\u1ec7n s\u1ebd ph\u1ee9c t\u1ea1p khi c\u00f3 nhi\u1ec1u SheetForm =&gt; c\u1ea7n qu\u1ea3n l\u00fd\u00a0\u0111i\u1ec1u ki\u1ec7n m\u1ed9t c\u00e1ch khoa h\u1ecdc<\/li>\n<li>Vi\u1ec7c b\u1ea3o v\u1ec7 Sheet kh\u00f4ng t\u1ed1t b\u1eb1ng b\u1ea3o v\u1ec7 trong VBA, n\u00ean c\u1ea7n l\u01b0u\u00a0\u00fd trong qu\u00e1 tr\u00ecnh s\u1eed d\u1ee5ng tr\u00e1nh b\u1ecb s\u1eeda, x\u00f3a, thay\u00a0\u0111\u1ed5i form sheet.<\/li>\n<\/ul>\n<p>3.\u00a0\u1ee8ng d\u1ee5ng<\/p>\n<p>\u1ee8ng d\u1ee5ng trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p c\u1ea7n\u00a0\u0111\u1ebfn\u00a0l\u00e0m vi\u1ec7c tr\u00ean\u00a0Form nh\u01b0:<\/p>\n<ul>\n<li>L\u1eadp c\u00e1c ch\u1ee9ng t\u1eeb k\u1ebf to\u00e1n: Phi\u1ebfu thu, phi\u1ebfu chi, phi\u1ebfu nh\u1eadp kho, phi\u1ebfu xu\u1ea5t kho\u2026<\/li>\n<\/ul>\n<ul>\n<li>L\u1eadp c\u00e1c form khi th\u00eam m\u1edbi d\u1eef li\u1ec7u, v\u00ed d\u1ee5 nh\u01b0:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-12060 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/pic05-3.png\" width=\"774\" height=\"448\" title=\"pic05-3\"><\/p>\n<p>C\u1ea3m\u00a0\u01a1n c\u00e1c b\u1ea1n\u00a0\u0111\u00e3 theo d\u00f5i Seri b\u00e0i vi\u1ebft n\u00e0y.<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n\u00a0\u1ee9ng d\u1ee5ng SheetForm v\u00e0o c\u00f4ng vi\u1ec7c\u00a0\u0111\u01b0\u1ee3c hi\u1ec7u qu\u1ea3.<\/p>\n<blockquote>\n<p>\u0110\u1eebng b\u1ecf l\u1ee1:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-ke-toan.html\">kho\u0301a h\u1ecdc Excel k\u1ebf to\u00e1n<\/a>\u00a0v\u1edbi c\u00e1c chuy\u00ean gia<\/p>\n<\/blockquote>\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\/2025\/01\/ex101_92019-nho-227.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10829,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10828","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\/10828","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=10828"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10828\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10829"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10828"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10828"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10828"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}