{"id":5206,"date":"2024-12-09T17:31:30","date_gmt":"2024-12-09T17:31:30","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/huong-dan-cach-ung-dung-ham-tu-tao-bang-vba-de-viet-tat-ho-ten-tren-excel\/"},"modified":"2024-12-09T17:31:30","modified_gmt":"2024-12-09T17:31:30","slug":"huong-dan-cach-ung-dung-ham-tu-tao-bang-vba-de-viet-tat-ho-ten-tren-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/huong-dan-cach-ung-dung-ham-tu-tao-bang-vba-de-viet-tat-ho-ten-tren-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch \u1ee9ng d\u1ee5ng h\u00e0m t\u1ef1 t\u1ea1o b\u1eb1ng VBA \u0111\u1ec3 vi\u1ebft t\u1eaft h\u1ecd t\u00ean tr\u00ean Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p style=\"text-align: justify\">Trong c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y t\u1ea1i v\u0103n ph\u00f2ng, b\u1ea1n kh\u00f4ng th\u1ec3 tr\u00e1nh \u0111\u01b0\u1ee3c nh\u1eefng c\u00f4ng vi\u1ec7c ph\u1ea3i x\u1eed l\u00fd danh s\u00e1ch nh\u00e2n vi\u00ean, kh\u00e1ch h\u00e0ng nh\u01b0: l\u1ecdc t\u00ean, l\u1ecdc h\u1ecd, vi\u1ebft t\u1eaft t\u00ean \u0111\u1ec3 ti\u1ec7n cho b\u00e1o c\u00e1o v\u00e0 qu\u1ea3n l\u00fd. Trong b\u00e0i vi\u1ebft n\u00e0y m\u00ecnh s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch \u1ee9ng d\u1ee5ng h\u00e0m t\u1ef1 t\u1ea1o b\u1eb1ng VBA \u0111\u1ec3 vi\u1ebft t\u1eaft h\u1ecd t\u00ean tr\u00ean Excel sao cho nhanh ch\u00f3ng.<\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 m\u1ed9t danh s\u00e1ch nh\u00e2n vi\u00ean. B\u1ea1n mu\u1ed1n vi\u1ebft\u00a0 t\u1eaft h\u1ecd t\u00ean c\u1ee7a t\u1eebng ng\u01b0\u1eddi :<\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5<\/p>\n<ul style=\"text-align: justify\">\n<li>\u201cNguy\u1ec5n V\u0103n H\u00f9ng\u201d\u00a0 th\u00e0nh \u201cNV H\u00f9ng\u201d<\/li>\n<li>\u201c\u201dL\u00ea Th\u1ecb Lan Anh\u201d\u201d th\u00e0nh \u201cLTL Anh\u201d<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Vi\u1ec7c n\u00e0y ho\u00e0n to\u00e0n \u0111\u01a1n gi\u1ea3n n\u1ebfu b\u1ea1n v\u1eadn d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/vba101-landing.html\" target=\"_blank\" rel=\"noopener noreferrer\">VBA<\/a> nh\u01b0 sau :<\/p>\n<p style=\"text-align: justify\">B\u1ea1n insert m\u1ed9t module m\u1edbi :<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-14833\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-300x149-1.jpg\" width=\"300\" height=\"149\" title=\"1-300x149-1\"><\/p>\n<blockquote>\n<p>Function ghepten(HoTen As Range) As String<br \/>\nIf HoTen.Count &gt; 1 Then Exit Function<br \/>\nOn Error GoTo Thoat<br \/>\nDim TMP As Variant, I As Byte<br \/>\nTMP = Split(HoTen.Text)<br \/>\nFor I = LBound(TMP, 1) To UBound(TMP, 1) \u2013 1<br \/>\nghepten = ghepten &amp; Left(CStr(TMP(I)), 1)<br \/>\nNext<br \/>\nghepten = ghepten &amp; Space(1) &amp; TMP(UBound(TMP, 1))<br \/>\nThoat: Exit Function<br \/>\nEnd Function<\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">C\u00e1ch s\u1eed d\u1ee5ng r\u1ea5t \u0111\u01a1n gi\u1ea3n theo c\u1ea5u tr\u00fac : =ghepten(d\u1eef li\u1ec7u ngu\u1ed3n)<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-14834\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-253x300-1.jpg\" width=\"253\" height=\"300\" title=\"2-253x300-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-174.gif\" title=\"vba101_92019-nho-174\"><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-443.gif\" title=\"ex101_92019-nho-443\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">V\u1edbi b\u00e0i vi\u1ebft tr\u00ean, m\u00ecnh hy v\u1ecdng gi\u00fap c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ef1 t\u1ea1o ra h\u00e0m \u0111\u1ec3 vi\u1ebft t\u1eaft h\u1ecd t\u00ean tr\u00ean Excel, trong b\u00e0i vi\u1ebft t\u1edbi m\u00ecnh s\u1ebd chia s\u1ebb m\u1ed9t s\u1ed1 b\u00e0i vi\u1ebft v\u1ec1 c\u00e1c h\u00e0m t\u1ef1 t\u1ea1o d\u1ea1ng nh\u01b0 tr\u00ean.<\/p>\n<p>\u00a0VBA\u00a0gi\u00fap \u00edch\u00a0r\u1ea5t nhi\u1ec1u trong c\u00f4ng vi\u1ec7c: gi\u00fap b\u1ea1n t\u0103ng t\u1ed1c trong qu\u00e1 tr\u00ecnh x\u1eed l\u00fd tr\u00ean Excel, gi\u00fap l\u1eadp c\u00e1c b\u00e1o c\u00e1o t\u1ef1 \u0111\u1ed9ng, \u0111i\u1ec1u khi\u1ec3n c\u00e1c ch\u01b0\u01a1ng tr\u00ecnh kh\u00e1c nh\u01b0 Word, Power Point, Outlook\u2026 gi\u00fap bi\u1ebfn file Excel c\u1ee7a b\u1ea1n tr\u1edf th\u00e0nh 1 ph\u1ea7n m\u1ec1m chuy\u00ean nghi\u1ec7p\u2026<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 h\u1ecdc VBA m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, c\u00f3 h\u1ec7 th\u1ed1ng, b\u1ea1n h\u00e3y tham gia kho\u00e1 h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2OAUBOg\">VBA101 \u2013 VBA c\u01a1 b\u1ea3n d\u00e0nh cho ng\u01b0\u1eddi m\u1edbi b\u1eaft \u0111\u1ea7u<\/a>\u00a0c\u1ee7a h\u1ec7 th\u1ed1ng H\u1ecdc Excel Online. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i khi b\u1ea1n \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y. Chi ti\u1ebft xem t\u1ea1i:<\/p>\n<p style=\"text-align: justify\">\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-174.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5207,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5206","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\/5206","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=5206"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5206\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5207"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5206"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5206"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5206"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}