{"id":2136,"date":"2023-09-29T03:25:56","date_gmt":"2023-09-29T03:25:56","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/objek\/"},"modified":"2023-12-06T06:20:26","modified_gmt":"2023-12-06T06:20:26","slug":"objek","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/objek\/","title":{"rendered":"Objek vba: penjelasan bergambar mudah"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-316547101\"><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>Visual Basic for Applications adalah bahasa berorientasi objek dan untuk memanfaatkannya secara maksimal, Anda perlu memahami objek Excel. Buku kerja yang Anda gunakan di Excel terdiri dari objek yang berbeda.<\/p><p> Dan ada beberapa properti yang melekat pada suatu objek yang dapat Anda akses dan beberapa metode yang dapat Anda gunakan pada\/dengan suatu objek. Mari kita pahami ini dengan sebuah contoh.<\/p><p> Bayangkan sebuah toko kelontong besar, yang memiliki bagian berbeda untuk produk, dan bagian tersebut juga memiliki rak, dan di dalam rak tersebut terdapat produk. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57765\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comprendre-les-objets-Excel.jpg\" sizes=\"auto, \" srcset=\"\" alt=\"memahami-objek-excel\" width=\"458\" height=\"305\"><\/figure><\/div><p> Jadi jika anda ingin membeli baju anda harus pergi ke bagian pakaian dan di bagian pakaian mungkin ada subbagian untuk pria dan wanita.<\/p><p> Dan ketika Anda memilih suatu kain, kain tersebut akan memiliki warna, ukuran, dan bahan tertentu (yang merupakan sifat dari kain tersebut).<\/p><p> Demikian pula di VBA, ada objek yang terstruktur dalam hierarki.<\/p><h2 class=\"wp-block-heading\"> Model Objek VBA (Hierarki)<\/h2><p> Dalam aplikasi Excel, saat Anda membuka buku kerja, di buku kerja tersebut Anda memiliki lembar kerja (atau beberapa lembar kerja) dan di lembar kerja tersebut Anda memiliki sel dan rentang sel.<\/p><p> Hirarki Excel dimulai dengan Aplikasi Excel itu sendiri dan di bawah ini adalah struktur yang mendefinisikan hierarki ini: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57766\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-modele-dobjet-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"534\" height=\"545\"><\/figure><\/div><p> Katakanlah jika Anda ingin mereferensikan buku kerja, kode yang Anda tulis akan terlihat seperti ini: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57767\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-code-faisant-reference-au-classeur.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"508\" height=\"255\"><\/figure><\/div><p> Pada kode di atas, Anda mengacu pada buku kerja &#8220;Buku1&#8221;.<\/p><p> Apa yang Anda tulis adalah Anda mengacu pada aplikasi Excel terlebih dahulu dan Anda menggunakan &#8220;Buku Kerja&#8221; yang merupakan bagian selanjutnya dari objek Aplikasi.<\/p><p> Sekarang katakanlah Anda ingin melangkah lebih jauh dan ingin merujuk ke lembar kerja di buku kerja &#8220;Buku1&#8221; dan kode yang sesuai adalah: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57768\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-code-faisant-reference-a-la-feuille-de-travail.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"674\" height=\"234\"><\/figure><\/div><p> Anda tahu apa artinya itu, bukan? Tapi izinkan saya memberitahu Anda. Pada kode di atas, setelah merujuk ke buku kerja &#8220;Buku1&#8221;, Anda telah merujuk ke lembar kerja &#8220;Sheet1&#8221; yang merupakan bagian lain dari buku kerja tersebut.<\/p><p> Mari kita melangkah lebih jauh. Mari kita merujuk ke sel tertentu di lembar kerja &#8220;Sheet1&#8221; dan kode yang sesuai adalah: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57769\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-code-fait-reference-a-une-cellule-specifique.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"792\" height=\"230\"><\/figure><\/div><p> Sebelum Anda bertanya, izinkan saya memberi tahu Anda hal ini. Pada kode di atas, Anda merujuk ke sel A1 yang terletak di lembar kerja \u201cSheet1\u201d dari buku kerja \u201cBook1\u201d.<\/p><p> Ketika Anda merujuk ke objek Range dengan cara ini, itu disebut referensi yang sepenuhnya memenuhi syarat.<\/p><p class=\"qt-tip\"> <strong>Catatan:<\/strong> Menggunakan objek Aplikasi bersifat opsional. Alasan? Saat Anda melakukan sesuatu di VBA, Anda sudah berada di aplikasi Excel.<\/p><h2 class=\"wp-block-heading\"> Sederhanakan referensi ke suatu objek<\/h2><p> Dalam kode di atas Anda menggunakan referensi yang sepenuhnya memenuhi syarat. Ini berarti Anda memberi tahu VBA buku kerja, lembar kerja, dan sel mana yang akan dirujuk. Namun bagaimana jika Anda sudah berada di buku kerja Buku 1?<\/p><p> Dalam hal ini, Anda cukup merujuk ke lembar kerja yang selnya ingin Anda referensikan, seperti kode di bawah ini: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57770\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-simplifier-la-reference-a-un-objet.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"463\" height=\"259\"><\/figure><\/div><p> Selain itu, jika lembar kerja &#8220;Sheet1&#8221; diaktifkan, Anda cukup merujuk ke sel atau rentang sel, seperti kode di bawah ini: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-57771\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-font-reference-a-la-cellule-ou-a-la-plage.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"316\" height=\"260\"><\/figure><\/div><p> <strong>Pelajari lebih lanjut tentang objek VBA:<\/strong> <a href=\"https:\/\/exceladvisor.org\/id\/bahan-pengikat\/\">Objek Buku Kerja VBA<\/a> | <a href=\"https:\/\/exceladvisor.org\/id\/lembar-kerja-1\/\">Objek Lembar Bentang VBA<\/a> | <a href=\"https:\/\/exceladvisor.org\/id\/rentang-1\/\">Objek Rentang VBA<\/a><\/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\/pertanyaan-wawancara\/\">Pertanyaan Wawancara VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/komentar\/\">Tambahkan komentar dalam kode VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jeda-baris\/\">Tambahkan jeda baris dalam kode VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/garis-baru\/\">Tambahkan baris baru (carriage return) dalam string di VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jalankan-makro-2\/\">Jalankan Makro di Excel (Jalankan Kode VBA)<\/a><\/li><\/ul><\/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-2136","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>\u25b7 Objek VBA: Panduan bergambar 2023 - Penasihat Excel<\/title>\n<meta name=\"description\" content=\"Visual Basic for Applications adalah bahasa berorientasi objek dan untuk memanfaatkannya secara maksimal, Anda perlu memahami objek Excel.\" \/>\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\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Objek VBA: Panduan bergambar 2023 - Penasihat Excel\" \/>\n<meta property=\"og:description\" content=\"Visual Basic for Applications adalah bahasa berorientasi objek dan untuk memanfaatkannya secara maksimal, Anda perlu memahami objek Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/objek\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:20:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comprendre-les-objets-Excel.jpg\" \/>\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=\"3 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/objek\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/objek\/\",\"name\":\"\u25b7 Objek VBA: Panduan bergambar 2023 - Penasihat Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/objek\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/objek\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comprendre-les-objets-Excel.jpg\",\"datePublished\":\"2023-09-29T03:25:56+00:00\",\"dateModified\":\"2023-12-06T06:20:26+00:00\",\"description\":\"Visual Basic for Applications adalah bahasa berorientasi objek dan untuk memanfaatkannya secara maksimal, Anda perlu memahami objek Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/objek\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/objek\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/objek\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comprendre-les-objets-Excel.jpg\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comprendre-les-objets-Excel.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/objek\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Objek vba: penjelasan bergambar mudah\"}]},{\"@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":"\u25b7 Objek VBA: Panduan bergambar 2023 - Penasihat Excel","description":"Visual Basic for Applications adalah bahasa berorientasi objek dan untuk memanfaatkannya secara maksimal, Anda perlu memahami objek Excel.","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\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Objek VBA: Panduan bergambar 2023 - Penasihat Excel","og_description":"Visual Basic for Applications adalah bahasa berorientasi objek dan untuk memanfaatkannya secara maksimal, Anda perlu memahami objek Excel.","og_url":"https:\/\/exceladvisor.org\/id\/objek\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:20:26+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comprendre-les-objets-Excel.jpg","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"3 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/objek\/","url":"https:\/\/exceladvisor.org\/id\/objek\/","name":"\u25b7 Objek VBA: Panduan bergambar 2023 - Penasihat Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/objek\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/objek\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comprendre-les-objets-Excel.jpg","datePublished":"2023-09-29T03:25:56+00:00","dateModified":"2023-12-06T06:20:26+00:00","description":"Visual Basic for Applications adalah bahasa berorientasi objek dan untuk memanfaatkannya secara maksimal, Anda perlu memahami objek Excel.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/objek\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/objek\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/objek\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comprendre-les-objets-Excel.jpg","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comprendre-les-objets-Excel.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/objek\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Objek vba: penjelasan bergambar mudah"}]},{"@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\/2136","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=2136"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2136\/revisions"}],"predecessor-version":[{"id":2918,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2136\/revisions\/2918"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2136"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}