{"id":2216,"date":"2023-09-01T06:37:58","date_gmt":"2023-09-01T06:37:58","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/objek-diperlukan-kesalahan-424\/"},"modified":"2023-12-06T06:14:55","modified_gmt":"2023-12-06T06:14:55","slug":"objek-diperlukan-kesalahan-424","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/objek-diperlukan-kesalahan-424\/","title":{"rendered":"Bagaimana cara memperbaiki kesalahan yang diperlukan objek vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2331706280\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Ketika VBA tidak dapat mengenali objek yang Anda rujuk properti atau metodenya, VBA akan menampilkan kesalahan Object Required. Sederhananya, jika Anda merujuk ke suatu objek, tetapi nama objek tersebut salah (objek tersebut tidak ada dalam hierarki objek VBA), maka akan muncul error 424, sebagai berikut. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57075\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-dobjet-vba-requise.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-objek-diperlukan-kesalahan\" width=\"593\" height=\"408\"><\/figure><\/div><p> Pada kode di atas, seperti yang Anda lihat, saya salah mengeja objek sel yang aktif, dan ketika VBA menjalankan baris kode ini, objek tersebut tidak dapat digunakan karena tidak ada objek dengan nama ini (seperti yang saya salah eja).<\/p><p class=\"qt-tip\"> <strong>Catatan<\/strong> : Jika Anda menggunakan pernyataan Option Explicit di modul, Anda akan mendapatkan error yang berbeda (lihat gambar di bawah). <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57076\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-variables-non-definies.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"481\" height=\"421\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Menggunakan kata kunci \u201cSet\u201d untuk variabel non-objek<\/h2><p> Saat Anda menggunakan variabel untuk menetapkan objek ke dalamnya, Anda harus menggunakan kata kunci \u201cSet\u201d. Dalam contoh berikut, Anda memiliki myWKS untuk lembar kerja dan iVal untuk nilai di sel A1. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57077\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-mot-cle-set-utilise-pour-une-variable-non-objet.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"554\" height=\"485\"><\/figure><\/div><p> Seperti yang Anda lihat, dalam kode di atas Anda memiliki variabel yang salah satunya dideklarasikan sebagai objek lembar kerja dan yang kedua sebagai string. Namun pada saat memberikan nilai, kami menggunakan kata kunci \u201cSet\u201d pada variabel \u201ciVal\u201d yang tidak dideklarasikan sebagai objek melainkan sebagai string.<\/p><h2 class=\"wp-block-heading\"> Cara Memperbaiki Objek yang Diperlukan (Error 424) di VBA<\/h2><ol type=\"1\"><li> Buka menu Debug editor Visual Basic Anda.<\/li><li> Gunakan langkah ini untuk menjalankan seluruh kode langkah demi langkah.<\/li><li> Saat Anda mencapai garis di mana Anda mengalami kesalahan, VBA akan menampilkan kesalahan tersebut.<\/li><li> Perbaiki baris kode ini. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57078\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-comment-reparer-object_required.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"589\" height=\"338\"><\/figure><\/div><p> Cara lainnya adalah dengan membaca kode baris demi baris untuk memastikan Anda mengacu pada objek yang tepat dan menggunakan nama variabel dan objek yang benar.<\/p><p> Anda juga dapat menggunakan pernyataan GOTO untuk melewati kesalahan atau menampilkan pesan kepada pengguna setelah kesalahan terjadi.<\/p><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/vba\/\">Apa itu VBA<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutorial terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/penanganan-kesalahan\/\">Penanganan kesalahan VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/kesalahan-otomatisasi-440\/\">Kesalahan otomatisasi VBA (Kesalahan 440)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/kesalahan-400\/\">Kesalahan VBA 400<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/panggilan-prosedur-tidak-valid-atau-kesalahan-argumen-5\/\">Panggilan prosedur VBA atau kesalahan argumen tidak valid (Kesalahan 5)<\/a><\/li><li><a href=\"https:\/\/exceladvisor.org\/id\/objek-tidak-mendukung-properti-atau-metode-ini-kesalahan-438\/\">Objek VBA tidak mendukung kesalahan properti atau metode ini (Kesalahan 438)<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-2216","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Bagaimana cara memperbaiki kesalahan yang diperlukan objek VBA? (Kesalahan 424)<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, Anda akan mempelajari mengapa objek yang diperlukan (kesalahan 424) terjadi dan cara menanganinya saat menulis kode VBA.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/objek-diperlukan-kesalahan-424\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara memperbaiki kesalahan yang diperlukan objek VBA? (Kesalahan 424)\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, Anda akan mempelajari mengapa objek yang diperlukan (kesalahan 424) terjadi dan cara menanganinya saat menulis kode VBA.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/objek-diperlukan-kesalahan-424\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:14:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-dobjet-vba-requise.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/objek-diperlukan-kesalahan-424\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/objek-diperlukan-kesalahan-424\/\",\"name\":\"Bagaimana cara memperbaiki kesalahan yang diperlukan objek VBA? (Kesalahan 424)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/objek-diperlukan-kesalahan-424\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/objek-diperlukan-kesalahan-424\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-dobjet-vba-requise.png\",\"datePublished\":\"2023-09-01T06:37:58+00:00\",\"dateModified\":\"2023-12-06T06:14:55+00:00\",\"description\":\"Dalam tutorial ini, Anda akan mempelajari mengapa objek yang diperlukan (kesalahan 424) terjadi dan cara menanganinya saat menulis kode VBA.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/objek-diperlukan-kesalahan-424\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/objek-diperlukan-kesalahan-424\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/objek-diperlukan-kesalahan-424\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-dobjet-vba-requise.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-dobjet-vba-requise.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/objek-diperlukan-kesalahan-424\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara memperbaiki kesalahan yang diperlukan objek vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bagaimana cara memperbaiki kesalahan yang diperlukan objek VBA? (Kesalahan 424)","description":"Dalam tutorial ini, Anda akan mempelajari mengapa objek yang diperlukan (kesalahan 424) terjadi dan cara menanganinya saat menulis kode VBA.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/id\/objek-diperlukan-kesalahan-424\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara memperbaiki kesalahan yang diperlukan objek VBA? (Kesalahan 424)","og_description":"Dalam tutorial ini, Anda akan mempelajari mengapa objek yang diperlukan (kesalahan 424) terjadi dan cara menanganinya saat menulis kode VBA.","og_url":"https:\/\/exceladvisor.org\/id\/objek-diperlukan-kesalahan-424\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:14:55+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-dobjet-vba-requise.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/objek-diperlukan-kesalahan-424\/","url":"https:\/\/exceladvisor.org\/id\/objek-diperlukan-kesalahan-424\/","name":"Bagaimana cara memperbaiki kesalahan yang diperlukan objek VBA? (Kesalahan 424)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/objek-diperlukan-kesalahan-424\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/objek-diperlukan-kesalahan-424\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-dobjet-vba-requise.png","datePublished":"2023-09-01T06:37:58+00:00","dateModified":"2023-12-06T06:14:55+00:00","description":"Dalam tutorial ini, Anda akan mempelajari mengapa objek yang diperlukan (kesalahan 424) terjadi dan cara menanganinya saat menulis kode VBA.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/objek-diperlukan-kesalahan-424\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/objek-diperlukan-kesalahan-424\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/objek-diperlukan-kesalahan-424\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-dobjet-vba-requise.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-erreur-dobjet-vba-requise.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/objek-diperlukan-kesalahan-424\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara memperbaiki kesalahan yang diperlukan objek vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2216","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=2216"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2216\/revisions"}],"predecessor-version":[{"id":2380,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2216\/revisions\/2380"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2216"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}