{"id":6368,"date":"2024-12-21T15:11:20","date_gmt":"2024-12-21T15:11:20","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-chen-dong-ho-dem-nguoc-trong-excel\/"},"modified":"2024-12-21T15:11:20","modified_gmt":"2024-12-21T15:11:20","slug":"cach-chen-dong-ho-dem-nguoc-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-chen-dong-ho-dem-nguoc-trong-excel\/","title":{"rendered":"C\u00e1ch ch\u00e8n \u0111\u1ed3ng h\u1ed3 \u0111\u1ebfm ng\u01b0\u1ee3c trong Excel"},"content":{"rendered":"
\n

Trong Excel kh\u00f4ng c\u00f3 \u0111\u1ed3ng h\u1ed3 \u0111\u1ebfm ng\u01b0\u1ee3c th\u1eddi gian, nh\u01b0ng b\u1ea1n c\u00f3 th\u1ec3 sao ch\u00e9p \u0111o\u1ea1n m\u00e3 VBA<\/strong><\/a> sau \u0111\u1ec3 \u0111\u1ebfm ng\u01b0\u1ee3c th\u1eddi gian.<\/p>\n

1. Ch\u1ecdn m\u1ed9t \u00f4 v\u00e0 \u0111\u1ecbnh d\u1ea1ng n\u00f3 l\u00e0 th\u1eddi gian b\u1eb1ng c\u00e1ch nh\u1ea5p ph\u1ea3i t\u1ea1i \u00f4 v\u00e0 ch\u1ecdn Format Cells<\/strong>, trong h\u1ed9p tho\u1ea1i, ch\u1ecdn Time<\/strong> v\u00e0 ch\u1ecdn 13:30:55<\/strong> trong Type<\/strong>, sau c\u00f9ng ch\u1ecdn OK<\/strong> \u0111\u1ec3 \u0111\u00f3ng h\u1ed9p tho\u1ea1i. Xem h\u00ecnh sau:<\/p>\n

<\/p>\n

\"doc-countdown-timer-2\"<\/p>\n

2. Nh\u1eadp th\u1eddi gian b\u1ea1n mu\u1ed1n \u0111\u1ebfm ng\u01b0\u1ee3c v\u00e0o \u00f4 \u0111\u00f3, nh\u01b0 h\u00ecnh:<\/p>\n

\"doc-countdown-timer-5\"<\/p>\n

3. Nh\u1ea5n ALT+F11\u00a0<\/strong>\u0111\u1ec3 m\u1edf c\u1eeda s\u1ed5\u00a0Microsoft Visual Basic for Applications<\/strong><\/p>\n

4. Nh\u1ea5p\u00a0Insert<\/strong> > Module\u00a0<\/strong>v\u00e0 sao ch\u00e9p \u0111o\u1ea1n m\u00e3 VBA sau v\u00e0o c\u1eeda s\u1ed5 m\u1edbi<\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n
\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n
View the code on Gist<\/a>.<\/div>\n
<\/div>\n
M\u1eb9o: <\/strong>E1 trong \u0111o\u1ea1n m\u00e3 tr\u00ean ch\u1ec9 \u0111\u1ecba ch\u1ec9 \u00f4 b\u1ea1n nh\u1eadp s\u1ed1 \u0111\u1ebfm ng\u01b0\u1ee3c trong b\u01b0\u1edbc 2.<\/div>\n
5. Nh\u1ea5p Run\u00a0<\/strong>ho\u1eb7c F5\u00a0<\/strong>\u0111\u1ec3 \u0111\u1ebfm ng\u01b0\u1ee3c.<\/div>\n
\"doc-countdown-timer-3\"<\/div>\n
6. Khi \u0111\u1ebfm ng\u01b0\u1ee3c xong, m\u1ed9t h\u1ed9p tho\u1ea1i s\u1ebd xu\u1ea5t hi\u1ec7n \u0111\u1ec3 nh\u1eafc nh\u1ecf b\u1ea1n:<\/div>\n
\"doc-countdown-timer-4\"<\/div>\n
M\u1eb9o:\u00a0<\/strong>B\u1ea1n kh\u00f4ng th\u1ec3 ng\u1eebng \u0111\u1ebfm ng\u01b0\u1ee3c tr\u1eeb khi \u0111\u00f3ng b\u1ea3ng t\u00ednh.<\/div>\n
\n

\u0110\u1ebfn \u0111\u00e2y b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 b\u1eaft \u0111\u1ea7u t\u00ecm hi\u1ec3u\u00a0nh\u1eefng\u00a0\u0111i\u1ec1u th\u00fa v\u1ecb c\u1ee7a VBA \u0111\u01b0\u1ee3c r\u1ed3i. 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

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