{"id":5054,"date":"2024-12-09T01:51:39","date_gmt":"2024-12-09T01:51:39","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/dinh-dang-o-truoc-khi-nhap-lieu-bang-vba\/"},"modified":"2024-12-09T01:51:39","modified_gmt":"2024-12-09T01:51:39","slug":"dinh-dang-o-truoc-khi-nhap-lieu-bang-vba","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/09\/dinh-dang-o-truoc-khi-nhap-lieu-bang-vba\/","title":{"rendered":"\u0110\u1ecbnh d\u1ea1ng \u00f4 tr\u01b0\u1edbc khi nh\u1eadp li\u1ec7u b\u1eb1ng VBA"},"content":{"rendered":"
\n

\u0110\u1ecbnh d\u1ea1ng \u00f4 tr\u01b0\u1edbc khi nh\u1eadp li\u1ec7u b\u1eb1ng VBA<\/h1>\n

Ch\u00e0o c\u00e1c b\u1ea1n, v\u1eeba qua tr\u00ean Group VBA 101<\/a> c\u00f3 b\u1ea1n Ph\u1ea1m Trung\u00a0<\/strong>c\u00f3 h\u1ecfi m\u1ed9t c\u00e2u h\u1ecfi nh\u01b0 sau :<\/p>\n

\n

Ad v\u00e0 mn cho em h\u1ecfi ch\u00fat: L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c vi\u1ec7c \u0111\u1ecbnh d\u1ea1ng \u00f4 tr\u01b0\u1edbc khi nh\u1eadp d\u1eef li\u1ec7u v\u1eady \u1ea1. VD: n\u1ebfu ta nh\u1eadp v\u00e0o \u00f4 A1 th\u00ec \u00f4 B1 t\u00f4 \u0111\u1eadm, \u0111\u1ec3 tr\u1ed1ng th\u00ec \u00f4 B1 b\u00ecnh th\u01b0\u1eddng. N\u1ebfu vi\u1ebft sub th\u00ec v\u1edbi tr\u00ecnh c\u1ee7a em m\u1ed9t l\u00e0 sau khi nh\u1eadp li\u1ec7u xong h\u1ebft m\u1edbi vi\u1ebft sub ho\u1eb7c m\u1ed7i l\u1ea7n nh\u1eadp xong l\u1ea1i ph\u1ea3i ch\u1ea1y code m\u1ed9t l\u1ea7n<\/p>\n<\/blockquote>\n

<\/p>\n

M\u00ecnh xin tr\u1ea3 l\u1eddi b\u1ea1n \u1ea5y nh\u01b0 sau :<\/p>\n

B\u1ea1n s\u1eed d\u1ee5ng s\u1ef1 ki\u1ec7n Worksheet_change c\u00f3 th\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y h\u1ebft s\u1ee9c \u0111\u01a1n gi\u1ea3n. C\u1ee5 th\u1ec3 nh\u01b0 sau :<\/p>\n<\/p>\n

View the code on Gist<\/a>.<\/div>\n

Ho\u00e0n to\u00e0n \u0111\u01a1n gi\u1ea3n \u0111\u00fang kh\u00f4ng n\u00e0o?<\/p>\n

B\u1ea1n download file t\u1ea1i \u0111\u00e2y<\/p>\n

Tr\u1edf th\u00e0nh si\u00eau nh\u00e2n VBA t\u00ecm hi\u1ec3u ngay.<\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n
\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n<\/div>\n
\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":5055,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-5054","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\/5054","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=5054"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/5054\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/5055"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=5054"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=5054"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=5054"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}