{"id":2405,"date":"2024-12-02T07:39:13","date_gmt":"2024-12-02T07:39:13","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/thiet-lap-lai-cac-cua-so-lam-viec-vba\/"},"modified":"2024-12-02T07:39:13","modified_gmt":"2024-12-02T07:39:13","slug":"thiet-lap-lai-cac-cua-so-lam-viec-vba","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/thiet-lap-lai-cac-cua-so-lam-viec-vba\/","title":{"rendered":"Thi\u1ebft l\u1eadp l\u1ea1i c\u00e1c c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c VBA"},"content":{"rendered":"
\n

C\u00e1c c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c trong VBA Excel<\/strong><\/a> v\u00f4 t\u00ecnh b\u1ecb k\u00e9o chu\u1ed9t (drag) v\u00e0 n\u00f3 tr\u1edf n\u00ean l\u1ed9n x\u1ed9n, v\u00e0 b\u1ea1n mu\u1ed1n n\u00f3 v\u1ec1 l\u1ea1i nh\u01b0 thu\u1edf ban \u0111\u1ea7u. \u0110\u00e3 c\u00f3 H\u1ecdc Excel Online<\/strong><\/a> gi\u00fap b\u1ea1n x\u1eed l\u00fd chuy\u1ec7n n\u00e0y<\/em><\/p>\n

<\/a><\/p>\n

Th\u00f4ng th\u01b0\u1eddng th\u00ec b\u1ea1n ph\u1ea3i k\u00e9o chu\u1ed9t s\u1eafp x\u1ebfp t\u1eebng c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c v\u00e0o \u0111\u00fang v\u1ecb tr\u00ed c\u1ee7a n\u00f3, c\u0103n ch\u1ec9nh, s\u1eafp x\u1ebfp m\u1ea5t kha kh\u00e1 th\u1eddi gian c\u1ee7a b\u1ea1n, nhi\u1ec1u khi vi\u1ec7c n\u00e0y c\u00f2n l\u00e0m b\u1ea1n b\u1ef1c m\u00ecnh th\u00eam. V\u1eady c\u00f3 c\u00e1ch n\u00e0o \u0111\u1ec3 \u201cReset\u201d n\u00f3 v\u1ec1 nh\u01b0 h\u1ed3i c\u00f2n con g\u00e1i kh\u00f4ng?<\/p>\n

Xem th\u00eam: H\u01b0\u1edbng d\u1eabn c\u00e1ch m\u1edf VBA trong Excel<\/a> \u0111\u01a1n gi\u1ea3n<\/strong><\/p>\n

R\u1ea5t \u0111\u01a1n gi\u1ea3n, v\u1edbi c\u00f4ng c\u1ee5 REGEDIT c\u1ee7a Windows. Tuy nhi\u00ean khi l\u00e0m thao t\u00e1c n\u00e0y, b\u1ea1n n\u00ean Export Registry ra \u0111\u1ec3 sao l\u01b0u tr\u01b0\u1edbc khi c\u00f3 thao t\u00e1c thay \u0111\u1ed5i.<\/p>\n

    \n
  1. \u0110\u1ea7u ti\u00ean, b\u1ea1n t\u1eaft h\u1ebft t\u1ea5t c\u1ea3 c\u00e1c file Excel \u0111ang m\u1edf<\/strong>.<\/li>\n
  2. Sau \u0111\u00f3, \u0111\u1ec3 v\u00e0o \u0111\u01b0\u1ee3c Regedit<\/strong>, b\u1ea1n ch\u1ecdn Start => Run<\/strong> (Ho\u1eb7c nh\u1ea5n Windows + R<\/strong>).<\/li>\n
  3. Sau \u0111\u00f3, g\u00f5 v\u00e0o: REGEDIT<\/strong> r\u1ed3i nh\u1ea5n Enter.<\/li>\n
  4. B\u1ea1n t\u00ecm \u0111\u1ebfn \u0111\u01b0\u1eddng d\u1eabn sau:
    \n[alert-success]ComputerHKEY_CURRENT_USERSoftwareMicrosoftVBA7.1Common.
    \n<\/strong>V\u1edbi 7.1 l\u00e0 s\u1ed1 phi\u00ean b\u1ea3n c\u1ee7a VBA m\u00e0 Office m\u00ecnh \u0111ang s\u1eed d\u1ee5ng.<\/em>[\/alert-success]<\/strong><\/li>\n
  5. Sau \u0111\u00f3 click ph\u1ea3i v\u00e0o th\u01b0 m\u1ee5c Common<\/strong>, v\u00e0 ch\u1ecdn Export<\/strong>, r\u1ed3i ch\u1ecdn ch\u1ed7 \u0111\u1ec3 sao l\u01b0u l\u1ea1i<\/strong>. Khi c\u00f3 s\u1ef1 c\u1ed1, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ea1y l\u1ea1i file n\u00e0y.
    \n
    \n<\/a><\/li>\n
  6. V\u00e0, vi\u1ec7c ti\u1ebfp theo b\u1ea1n c\u1ea7n l\u00e0m, l\u00e0 t\u00ecm kh\u00f3a DWORD c\u00f3 t\u00ean l\u00e0 DOCK<\/strong>, v\u00e0 click ph\u1ea3i v\u00e0o n\u00f3 \u0111\u1ed5i t\u00ean, ho\u1eb7c c\u00f3 th\u1ec3 x\u00f3a h\u1eb3n n\u00f3 \u0111i. B\u1ea1n y\u00ean t\u00e2m, khi b\u1ea1n ch\u1ea1y l\u1ea1i Excel, kh\u00f4ng th\u1ea5y t\u1eeb kh\u00f3a n\u00e0y, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng kh\u1edfi t\u1ea1o l\u1ea1i.
    \n    <\/a><\/li>\n
  7. Cu\u1ed1i c\u00f9ng, vi\u1ec7c c\u00f2n l\u1ea1i, l\u00e0 b\u1ea1n m\u1edf l\u1ea1i Excel v\u00e0 ch\u1ecdn show ra l\u1ea1i c\u00e1c c\u1eeda s\u1ed5 l\u00e0m vi\u1ec7c kh\u00e1c t\u1eeb menu View, ho\u1eb7c ph\u00edm t\u1eaft t\u01b0\u01a1ng \u1ee9ng:
    \n    <\/a><\/li>\n<\/ol>\n

    M\u1ecdi th\u1ee9 tr\u1edf n\u00ean \u0111\u01a1n gi\u1ea3n h\u01a1n l\u00e0 ng\u1ed3i \u0111\u00e1nh v\u1eadt v\u1edbi con chu\u1ed9t ph\u1ea3i kh\u00f4ng?<\/p>\n

    L\u00e0m ti t\u1ec9 th\u1ee9, th\u00ec \u0111\u00e2u th\u1ec3 n\u00f3i l\u00e0 m\u1ea5t 10\u00a0gi\u00e2y l\u00e0 xong, \u0111\u00fang kh\u00f4ng b\u00e0 con?! Th\u1ef1c ra, th\u00ec b\u1ea1n ch\u1ec9 m\u1ea5t ch\u01b0a t\u1edbi 5\u00a0gi\u00e2y\u00a0\u0111\u1ec3 thi\u1ebft l\u1eadp l\u1ea1i. L\u00e0m nh\u01b0 th\u1ebf n\u00e0o? H\u00e3y Export l\u1ea1i th\u01b0 m\u1ee5c Common (\u1edf b\u01b0\u1edbc 5) sau khi \u0111\u00e3 ch\u1ec9nh s\u1eeda l\u1ea1i xong xu\u00f4i. V\u00e0 khi c\u1ea7n ch\u1ec9nh l\u1ea1i, h\u00e3y ch\u1ea1y l\u1ea1i file .reg<\/strong> \u0111\u00e3 sao l\u01b0u \u0111\u00f3.<\/p>\n

    \u0110\u1ec3 t\u00ecm hi\u1ec3u th\u00eam nhi\u1ec1u ki\u1ebfn th\u1ee9c v\u1ec1 VBA, m\u1eddi b\u1ea1n tham d\u1ef1 kh\u00f3a h\u1ecdc\u00a0VBA101 \u2013 T\u1ef1\u00a0\u0111\u1ed9ng h\u00f3a\u00a0Excel v\u1edbi l\u1eadp tr\u00ecnh VBA<\/strong><\/a>.\u00a0\u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc r\u1ea5t h\u1eefu\u00a0\u00edch d\u00e0nh cho b\u1ea1n, gi\u00fap b\u1ea1n hi\u1ec3u m\u1ed9t c\u00e1ch b\u00e0i b\u1ea3n v\u1ec1 VBA v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng VBA, \u1ee9ng d\u1ee5ng VBA v\u00e0o c\u00f4ng vi\u1ec7c \u0111\u1ec3 t\u0103ng hi\u1ec7u qu\u1ea3. H\u00e3y c\u00f9ng kh\u00e1m ph\u00e1 n\u00e0o:<\/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":2406,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-2405","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\/2405","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=2405"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/2405\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/2406"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=2405"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=2405"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=2405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}