{"id":8021,"date":"2024-12-21T19:29:21","date_gmt":"2024-12-21T19:29:21","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/go-tieng-viet-trong-vba-su-dung-msgbox-co-ho-tro-unicode-trong-vba\/"},"modified":"2024-12-21T19:29:21","modified_gmt":"2024-12-21T19:29:21","slug":"go-tieng-viet-trong-vba-su-dung-msgbox-co-ho-tro-unicode-trong-vba","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/go-tieng-viet-trong-vba-su-dung-msgbox-co-ho-tro-unicode-trong-vba\/","title":{"rendered":"G\u00f5 ti\u1ebfng vi\u1ec7t trong VBA, s\u1eed d\u1ee5ng msgbox c\u00f3 h\u1ed7 tr\u1ee3 Unicode trong VBA"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>Nhi\u1ec1u b\u1ea1n \u0111\u00e3 c\u00f3 c\u00e2u h\u1ecfi l\u00e0 v\u00ec sao kh\u00f4ng th\u1ec3 g\u00f5 \u0111\u01b0\u1ee3c ti\u1ebfng Vi\u1ec7t trong tr\u00ecnh so\u1ea1n th\u1ea3o VBA. M\u1ee5c \u0111\u00edch c\u1ee7a vi\u1ec7c g\u00f5 ti\u1ebfng Vi\u1ec7t ho\u1eb7c k\u00fd t\u1ef1 Unicode trong tr\u00ecnh so\u1ea1n th\u1ea3o VBA c\u00f3 th\u1ec3 l\u00e0 output ra 1 th\u00f4ng b\u00e1o (Message Box) ho\u1eb7c l\u00e0 \u0111i\u1ec1n d\u1eef li\u1ec7u cho v\u00f9ng tr\u00ean b\u1ea3ng t\u00ednh, ho\u1eb7c l\u00e0 s\u1eed d\u1ee5ng trong giao di\u1ec7n ph\u1ea7n m\u1ec1m n\u1ec1n Excel c\u1ee7a c\u00e1c b\u1ea1n. V\u1eady tr\u00ecnh so\u1ea1n th\u1ea3o VBA c\u00f3 h\u1ed7 tr\u1ee3 ti\u1ebfng Vi\u1ec7t hay Unicode kh\u00f4ng? C\u00e2u tr\u1ea3 l\u1eddi l\u00e0 kh\u00f4ng, Microsoft kh\u00f4ng h\u1ed7 tr\u1ee3 \u0111i\u1ec1u n\u00e0y. Tuy v\u1eady, ch\u00fang ta v\u1eabn c\u00f3 th\u1ec3 ghi nh\u1eefng n\u1ed9i dung ti\u1ebfng Vi\u1ec7t ra c\u00e1c v\u00f9ng tr\u00ean b\u1ea3ng t\u00ednh, v\u1eabn c\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb ti\u1ebfng Vi\u1ec7t tr\u00ean message box \u0111\u01b0\u1ee3c, hi\u1ec7n nh\u01b0 th\u1ebf n\u00e0o th\u00ec m\u1eddi c\u00e1c b\u1ea1n theo d\u00f5i video h\u01b0\u1edbng d\u1eabn sau \u0111\u00e2y:<\/p>\n<p style=\"text-align: center\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/rUXIZSK5ETw\" width=\"560\" height=\"314\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<h2>C\u00e1ch kh\u00e1c \u0111\u1ec3 g\u00f5 ti\u1ebfng Vi\u1ec7t trong VBA Excel<\/h2>\n<p>Ch\u00fang ta c\u00f3 \u0111o\u1ea1n code sau \u0111\u00e2y:<\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/62ecc93384cd7284f43b059f242b5250\">Gist<\/a>.<\/div>\n<p><strong>C\u00e1ch s\u1eed d\u1ee5ng:\u00a0<\/strong><\/p>\n<p>V\u00ed d\u1ee5 b\u1ea1n mu\u1ed1n g\u00f5 v\u00e0 hi\u1ec3n th\u1ecb d\u00f2ng ch\u1eef \u201cT\u00f4i y\u00eau Vi\u1ec7t Nam\u201d l\u00ean tr\u00ean 1 c\u1eeda s\u1ed5 th\u00f4ng b\u00e1o c\u1ee7a Excel ho\u1eb7c l\u00ean tr\u00ean 1 d\u00f2ng c\u1ee7a ListView ch\u1eb3ng h\u1ea1n:<\/p>\n<p><strong>C\u00e1ch 1:<\/strong><\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/bbffc3e1628f5ab00fdb5a41f808ab6d\">Gist<\/a>.<\/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\/2024\/12\/vba101_92019-nho-332.gif\" title=\"vba101_92019-nho-332\"><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-722.gif\" title=\"ex101_92019-nho-722\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><strong>C\u00e1ch 2:<\/strong><\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/3200c7ee638e0b1bfe159dc5c10ca1ea\">Gist<\/a>.<\/div>\n<p><strong>C\u00e1ch 3:<\/strong><\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/86cb5e336c0750eb7690787decd5a0d1\">Gist<\/a>.<\/div>\n<p><strong>C\u00e1ch 4:<\/strong><\/p>\n<\/p>\n<div class=\"oembed-gist\">View the code on <a href=\"https:\/\/gist.github.com\/ndthanh\/010c50a0144b27d42fdb8ae7440a4056\">Gist<\/a>.<\/div>\n<p>VBA\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<\/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-332.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8022,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8021","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\/8021","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=8021"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8021\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8022"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8021"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8021"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8021"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}