{"id":2132,"date":"2023-09-30T04:10:38","date_gmt":"2023-09-30T04:10:38","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/pencetakan-debug-jendela-segera\/"},"modified":"2023-09-30T04:10:38","modified_gmt":"2023-09-30T04:10:38","slug":"pencetakan-debug-jendela-segera","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/pencetakan-debug-jendela-segera\/","title":{"rendered":"Vba jendela segera: panduan bergambar lengkap"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2023193557\"><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> <h2 class=\"wp-block-heading\">Apa itu jendela langsung?<\/h2><p> Jendela Instan adalah kotak Editor Visual Basic kecil yang dapat Anda gunakan untuk menjalankan satu baris kode dan mendapatkan hasil instan. Sederhananya, alih-alih menjalankan kode Anda secara langsung di Excel, Anda bisa menjalankan baris makro yang dikembalikannya. Ini sangat berguna ketika Anda sedang men-debug kode.<\/p><p> Saat Anda membuka Visual Basic Editor (Alt+F11), Anda dapat langsung melihat jendela di bagian bawah. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51309\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fenetre-immediate-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba jendela langsung\" width=\"631\" height=\"583\"><\/figure><\/div><p> Namun jika tidak ada, Anda perlu mengaktifkannya dari menu edit, atau bisa juga menggunakan <a href=\"https:\/\/exceladvisor.org\/id\/pintasan-keyboard\/\">tombol shortcut keyboard<\/a> Control + G. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51310\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-raccourci-clavier-pour-fenetre-immediate.png\" sizes=\"auto, \" srcset=\"\" alt=\"pintasan-tombol pintas-untuk-jendela-pop-up\" width=\"258\" height=\"428\"><\/figure><\/div><p> Dan jika Anda ingin membukanya, klik dan tahan bilah judul dan masukkan dan keluar dari <a href=\"https:\/\/exceladvisor.org\/id\/editor-visual-dasar\/\">editor VB<\/a> . <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51311\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-cliquez-et-maintenez-la-barre-de-titre.png\" sizes=\"auto, \" srcset=\"\" alt=\"klik-tahan-bilah judul\" width=\"845\" height=\"511\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Apa itu Debug.Print<\/h2><p> Debug.Print adalah perintah yang dapat Anda gunakan untuk menjalankan satu baris kode dan mendapatkan hasil dari baris tersebut di jendela Segera. Sederhananya, ketika Anda menggunakan perintah debug.print di awal baris kode dan kemudian menjalankannya, VBA langsung menampilkan hasil baris tersebut di jendela.<\/p><p> Bayangkan, Anda ingin tahu warna font apa yang diterapkan pada A1. Dalam hal ini Anda dapat menggunakan baris kode berikut, dimulai dengan Debug.Print dan kemudian kode untuk mendapatkan warna font.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Debug.Print Range(\"A1\").Font.Color<\/code><\/pre><p> Sekarang ketika Anda menjalankan kode ini, Anda akan mendapatkan hasilnya langsung di jendela seperti di bawah ini: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51312\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-impression-de-debogage.png\" sizes=\"auto, \" srcset=\"\" alt=\"pencetakan debug\" width=\"735\" height=\"503\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Mengeksekusi sebaris kode<\/h2><p> Selain menggunakan debug.print, Anda dapat langsung menjalankan sebaris kode dari jendela langsung. Katakanlah jika Anda ingin memasukkan nilai di sel A1, Anda bisa langsung mengetikkan kode berikut di jendela langsung, lalu tekan ENTER. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51313\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-executer-un-code-de-ligne.png\" sizes=\"auto, \" srcset=\"\" alt=\"mengeksekusi kode baris\" width=\"537\" height=\"212\"><\/figure><\/div><p> Jendela langsung mengeksekusi satu baris kode dalam satu waktu. Jadi, Anda harus menekan enter setiap baris kode yang ingin dijalankan.<\/p><h2 class=\"wp-block-heading\"> <a href=\"https:\/\/exceladvisor.org\/id\/jalankan-makro-2\/\">Jalankan makro<\/a> langsung dari jendela langsung<\/h2><p> Anda juga dapat menjalankan makro langsung dari jendela langsung menggunakan nama makro. Yang harus Anda lakukan adalah mengetikkan nama makro lalu tekan Enter. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51314\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-executer-une-macro-directement.png\" sizes=\"auto, \" srcset=\"\" alt=\"jalankan-a-makro-secara langsung\" width=\"591\" height=\"485\"><\/figure><\/div><p> Pastikan untuk mengatur argumen di jendela langsung jika Anda punya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51315\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-definir-largument-dans-la-fenetre-immediate.png\" sizes=\"auto, \" srcset=\"\" alt=\"set-argumen-di-jendela-segera\" width=\"601\" height=\"416\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Ajukan pertanyaan singkat<\/h2><p> Anda juga dapat mengajukan pertanyaan langsung di jendela langsung. Apa yang ingin saya katakan adalah Anda dapat langsung menulis sebaris kode di jendela langsung dan menggunakan tanda tanya untuk mendapatkan hasilnya.<\/p><p> Katakanlah jika Anda ingin mengetahui nilai yang Anda miliki di sel A1, dalam hal ini Anda dapat mengetikkan baris kode berikut di jendela langsung dan tekan Enter. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">?Range(\"A1\").Value<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51316\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-lignes-de-code-dans-la-fenetre-immediate.png\" sizes=\"auto, \" srcset=\"\" alt=\"baris kode-di-jendela-segera\" width=\"508\" height=\"136\"><\/figure><\/div><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 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":"closed","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-2132","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 Apa itu Jendela Segera VBA (Debug.Print)?<\/title>\n<meta name=\"description\" content=\"Tutorial ini membantu Anda memahami jendela langsung dan menggunakan perintah debug.print untuk mendapatkan hasil dari satu baris kode.\" \/>\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\/pencetakan-debug-jendela-segera\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Apa itu Jendela Segera VBA (Debug.Print)?\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini membantu Anda memahami jendela langsung dan menggunakan perintah debug.print untuk mendapatkan hasil dari satu baris kode.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/pencetakan-debug-jendela-segera\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fenetre-immediate-vba.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\/pencetakan-debug-jendela-segera\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/pencetakan-debug-jendela-segera\/\",\"name\":\"\u25b7 Apa itu Jendela Segera VBA (Debug.Print)?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/pencetakan-debug-jendela-segera\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/pencetakan-debug-jendela-segera\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fenetre-immediate-vba.png\",\"datePublished\":\"2023-09-30T04:10:38+00:00\",\"description\":\"Tutorial ini membantu Anda memahami jendela langsung dan menggunakan perintah debug.print untuk mendapatkan hasil dari satu baris kode.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/pencetakan-debug-jendela-segera\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/pencetakan-debug-jendela-segera\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/pencetakan-debug-jendela-segera\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fenetre-immediate-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fenetre-immediate-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/pencetakan-debug-jendela-segera\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba jendela segera: panduan bergambar lengkap\"}]},{\"@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 Apa itu Jendela Segera VBA (Debug.Print)?","description":"Tutorial ini membantu Anda memahami jendela langsung dan menggunakan perintah debug.print untuk mendapatkan hasil dari satu baris kode.","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\/pencetakan-debug-jendela-segera\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Apa itu Jendela Segera VBA (Debug.Print)?","og_description":"Tutorial ini membantu Anda memahami jendela langsung dan menggunakan perintah debug.print untuk mendapatkan hasil dari satu baris kode.","og_url":"https:\/\/exceladvisor.org\/id\/pencetakan-debug-jendela-segera\/","og_site_name":"Excel Advisor","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fenetre-immediate-vba.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\/pencetakan-debug-jendela-segera\/","url":"https:\/\/exceladvisor.org\/id\/pencetakan-debug-jendela-segera\/","name":"\u25b7 Apa itu Jendela Segera VBA (Debug.Print)?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/pencetakan-debug-jendela-segera\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/pencetakan-debug-jendela-segera\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fenetre-immediate-vba.png","datePublished":"2023-09-30T04:10:38+00:00","description":"Tutorial ini membantu Anda memahami jendela langsung dan menggunakan perintah debug.print untuk mendapatkan hasil dari satu baris kode.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/pencetakan-debug-jendela-segera\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/pencetakan-debug-jendela-segera\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/pencetakan-debug-jendela-segera\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fenetre-immediate-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-fenetre-immediate-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/pencetakan-debug-jendela-segera\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba jendela segera: panduan bergambar lengkap"}]},{"@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\/2132","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=2132"}],"version-history":[{"count":0,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2132\/revisions"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2132"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}