{"id":4833,"date":"2024-12-08T10:39:52","date_gmt":"2024-12-08T10:39:52","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/gia-lap-su-kien-doubleclick-tren-cell-ma-khong-can-dung-den-worksheet-events-trong-vba\/"},"modified":"2024-12-08T10:39:52","modified_gmt":"2024-12-08T10:39:52","slug":"gia-lap-su-kien-doubleclick-tren-cell-ma-khong-can-dung-den-worksheet-events-trong-vba","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/gia-lap-su-kien-doubleclick-tren-cell-ma-khong-can-dung-den-worksheet-events-trong-vba\/","title":{"rendered":"Gi\u1ea3 l\u1eadp s\u1ef1 ki\u1ec7n DoubleClick tr\u00ean cell m\u00e0 kh\u00f4ng c\u1ea7n d\u00f9ng \u0111\u1ebfn Worksheet Events trong VBA"},"content":{"rendered":"
\n

V\u00ed d\u1ee5 t\u00f4i mu\u1ed1n th\u1ef1c hi\u1ec7n m\u1ed9t s\u1ef1 ki\u1ec7n khi t\u00f4i\u00a0DoubleClick (Nh\u00e1y \u0111\u00fap chu\u1ed9t) th\u00ec th\u1ef1c hi\u1ec7n m\u1ed9t s\u1ef1 ki\u1ec7n n\u00e0o \u0111\u00f3. T\u00f4i l\u1ea5y v\u00ed d\u1ee5 hi\u1ec7n ra th\u00f4ng b\u00e1o Msgbox<\/p>\n

<\/p>\n

T\u00f4i c\u00f3 th\u1ec3\u00a0d\u1ec5 d\u00e0ng th\u1ef1c hi\u1ec7n \u0111i\u1ec1u \u0111\u00f3 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng s\u1ef1 ki\u1ec7n BeforeDoubleClick c\u1ee7a worksheet nh\u01b0 sau :<\/p>\n<\/p>\n

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

B\u00e2y gi\u1edd c\u00f3 m\u1ed9t c\u00e2u h\u1ecfi \u0111\u1eb7t ra. N\u1ebfu kh\u00f4ng s\u1eed d\u1ee5ng\u00a0s\u1ef1 ki\u1ec7n\u00a0BeforeDoubleClick c\u1ee7a worksheet th\u00ec c\u00f3 l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u t\u01b0\u01a1ng t\u1ef1 hay kh\u00f4ng?<\/p>\n

C\u00e2u tr\u1ea3 l\u1eddi l\u00e0 ho\u00e0n to\u00e0n kh\u1ea3 thi.<\/p>\n

B\u1ea1n t\u1ea1o m\u1ed9t module m\u1edbi v\u00e0 ch\u00e8n code sau :<\/p>\n<\/p>\n

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

B\u1ea1n l\u01b0u v\u00e0 \u0111\u00f3ng file excel l\u1ea1i, sau \u0111\u00f3 b\u1eadt file excel r\u1ed3i click \u0111\u00fap v\u00e0o \u00f4 A1 \u1edf Sheet1 s\u1ebd th\u1ea5y s\u1ef1 ki\u1ec7n x\u1ea3y ra<\/p>\n

R\u1ea5t \u0111\u01a1n gi\u1ea3n \u0111\u00fang kh\u00f4ng? N\u1ebfu b\u1ea1n c\u1ea3m th\u1ea5y th\u00fa v\u00ec v\u00e0 mu\u1ed1n t\u00ecm hi\u1ec3u v\u1ec1 \u00e1p d\u1ee5ng VBA trong c\u00f4ng vi\u1ec7c th\u00ec click v\u00e0o banner \u1edf cu\u1ed1i b\u00e0i vi\u1ebft nh\u00e9.<\/p>\n

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