{"id":4454,"date":"2023-07-10T23:51:56","date_gmt":"2023-07-10T23:51:56","guid":{"rendered":"https:\/\/statorials.org\/id\/baris-baru-kotak-pesan-vba\/"},"modified":"2023-07-10T23:51:56","modified_gmt":"2023-07-10T23:51:56","slug":"baris-baru-kotak-pesan-vba","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/baris-baru-kotak-pesan-vba\/","title":{"rendered":"Vba: cara menambahkan baris baru ke kotak pesan (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan pernyataan <strong>vbNewLine<\/strong> di VBA untuk menambahkan baris baru ke kotak pesan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Berikut dua cara umum untuk menggunakan pernyataan ini:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Tambahkan baris baru ke kotak pesan<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> MsgBoxAddLine()\nMsgBox \"This is the first line \" &amp; vbNewLine &amp; \"This is the second\"\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Tambahkan beberapa baris baru ke kotak pesan<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> MsgBoxAddLine()\nMsgBox \"This is the first line \" &amp; vbNewLine &amp; vbNewLine &amp; \"This is the second\"\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan pernyataan <strong>vbNewLine<\/strong> dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Buat kotak pesan tanpa baris baru<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk membuat kotak pesan yang berisi kalimat panjang tanpa baris baru:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> MsgBoxAddLine()\nMsgBox \"This is the first line and I wish I could add a second line because this sentence is getting really long\"\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34879 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/msg1.png\" alt=\"\" width=\"499\" height=\"399\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kalimat di kotak pesan dimulai pada baris baru setelah mencapai panjang tertentu.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Buat kotak pesan dengan baris baru<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk membuat kotak pesan yang membuat baris baru setelah string &#8220;Ini adalah baris pertama&#8221;:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> MsgBoxAddLine()\nMsgBox \"This is the first line \" &amp; vbNewLine &amp; \"This is the second\"\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-34880\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/msg2.png\" alt=\"Kotak pesan VBA dengan baris baru\" width=\"460\" height=\"388\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dengan menggunakan instruksi <strong>vbNewLine<\/strong> , kami dapat memulai baris baru di kotak pesan.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 3: Buat kotak pesan dengan beberapa baris baru<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk membuat kotak pesan yang membuat dua baris baru setelah string &#8220;Ini adalah baris pertama&#8221;:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> MsgBoxAddLine()\nMsgBox \"This is the first line \" &amp; vbNewLine &amp; vbNewLine &amp; \"This is the second\"\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34881 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/msg3.png\" alt=\"\" width=\"481\" height=\"364\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dengan menggunakan pernyataan <strong>vbNewLine<\/strong> dua kali, kami dapat menyisipkan dua baris baru ke dalam kotak pesan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini secara efektif membuat baris kosong antara dua string di kotak pesan.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di VBA:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/vba-menemukan-baris-terakhir\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menemukan baris yang terakhir digunakan<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-temukan-kolom-terakhir\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menemukan kolom yang terakhir digunakan<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-menyisipkan-banyak-baris\/\" target=\"_blank\" rel=\"noopener\">VBA: cara menyisipkan banyak baris<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan pernyataan vbNewLine di VBA untuk menambahkan baris baru ke kotak pesan. Berikut dua cara umum untuk menggunakan pernyataan ini: Metode 1: Tambahkan baris baru ke kotak pesan Sub MsgBoxAddLine() MsgBox &#8220;This is the first line &#8221; &amp; vbNewLine &amp; &#8220;This is the second&#8221; End Sub Metode 2: Tambahkan beberapa baris baru ke [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>VBA: Cara menambahkan baris baru ke kotak pesan (dengan contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menambahkan baris baru ke kotak pesan di VBA, dengan beberapa contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/baris-baru-kotak-pesan-vba\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara menambahkan baris baru ke kotak pesan (dengan contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menambahkan baris baru ke kotak pesan di VBA, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/baris-baru-kotak-pesan-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-10T23:51:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/msg1.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/baris-baru-kotak-pesan-vba\/\",\"url\":\"https:\/\/statorials.org\/id\/baris-baru-kotak-pesan-vba\/\",\"name\":\"VBA: Cara menambahkan baris baru ke kotak pesan (dengan contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-10T23:51:56+00:00\",\"dateModified\":\"2023-07-10T23:51:56+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menambahkan baris baru ke kotak pesan di VBA, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/baris-baru-kotak-pesan-vba\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/baris-baru-kotak-pesan-vba\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/baris-baru-kotak-pesan-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara menambahkan baris baru ke kotak pesan (dengan contoh)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"VBA: Cara menambahkan baris baru ke kotak pesan (dengan contoh) - Statologi","description":"Tutorial ini menjelaskan cara menambahkan baris baru ke kotak pesan di VBA, dengan beberapa contoh.","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:\/\/statorials.org\/id\/baris-baru-kotak-pesan-vba\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara menambahkan baris baru ke kotak pesan (dengan contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menambahkan baris baru ke kotak pesan di VBA, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/baris-baru-kotak-pesan-vba\/","og_site_name":"Statorials","article_published_time":"2023-07-10T23:51:56+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/msg1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/baris-baru-kotak-pesan-vba\/","url":"https:\/\/statorials.org\/id\/baris-baru-kotak-pesan-vba\/","name":"VBA: Cara menambahkan baris baru ke kotak pesan (dengan contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-10T23:51:56+00:00","dateModified":"2023-07-10T23:51:56+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menambahkan baris baru ke kotak pesan di VBA, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/baris-baru-kotak-pesan-vba\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/baris-baru-kotak-pesan-vba\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/baris-baru-kotak-pesan-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara menambahkan baris baru ke kotak pesan (dengan contoh)"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4454"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=4454"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4454\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4454"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4454"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4454"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}