{"id":4868,"date":"2023-07-07T01:32:09","date_gmt":"2023-07-07T01:32:09","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-membungkus-teks\/"},"modified":"2023-07-07T01:32:09","modified_gmt":"2023-07-07T01:32:09","slug":"vba-membungkus-teks","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-membungkus-teks\/","title":{"rendered":"Cara membungkus teks menggunakan vba (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda bisa menggunakan properti <strong>WrapText<\/strong> di VBA untuk membungkus teks dalam sel tertentu di lembar kerja Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Berikut tiga cara umum untuk menggunakan properti ini dalam praktik:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong><span style=\"color: #000000;\">Metode 1: Bungkus teks sel tertentu<\/span><\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> UseWrapText()\nRange(\" <span style=\"color: #ff0000;\">B2<\/span> \").WrapText = <span style=\"color: #0000ff;\">True<\/span>\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Bungkus Teks Sel dalam Rentang Tertentu<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\"><span style=\"color: #000000;\">SubUseWrapText<\/span><\/span> <span style=\"color: #000000;\">()<\/span>\nRange(\" <span style=\"color: #ff0000;\">B2:B11<\/span> \").WrapText = <span style=\"color: #0000ff;\">True<\/span>\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 3: Bungkus teks semua sel di lembar kerja<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> <span style=\"color: #000000;\">UseWrapText()<\/span>\nCells.WrapText = <span style=\"color: #0000ff;\">True<\/span>\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut memperlihatkan cara menggunakan setiap metode dalam praktik dengan kumpulan data berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38020 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/envelopper0.png\" alt=\"\" width=\"678\" height=\"424\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ayo pergi!<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Bungkus Teks Sel Tertentu Menggunakan VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa membuat makro berikut untuk membungkus teks di sel <strong>B2<\/strong> saja:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> UseWrapText()\nRange(\" <span style=\"color: #ff0000;\">B2<\/span> \").WrapText = <span style=\"color: #0000ff;\">True<\/span>\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kita menjalankan makro ini, kita bisa mengklik sel <strong>B2<\/strong> dan melihat bahwa <strong>Bungkus Teks<\/strong> diaktifkan di grup <strong>Perataan<\/strong> pada tab <strong>Beranda<\/strong> di sepanjang pita atas:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38021 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/enveloppe00.png\" alt=\"\" width=\"678\" height=\"304\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Namun, kita perlu memperpendek panjang kolom B dan menambah tinggi baris 2 agar benar-benar melihat teks yang dibungkus:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38022 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/envelopper3.png\" alt=\"\" width=\"569\" height=\"414\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita sekarang dapat dengan mudah melihat bahwa teks di sel <strong>B2<\/strong> terbungkus sementara teks di semua sel lain di kolom B tidak terbungkus.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Bungkus Teks Sel dalam Rentang Tertentu Menggunakan VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk membungkus teks di setiap sel dalam rentang <strong>B2:B11<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> UseWrapText()\nRange(\" <span style=\"color: #ff0000;\">B2:B11<\/span> \").WrapText = <span style=\"color: #0000ff;\">True<\/span>\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-38023 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/envelopper4.png\" alt=\"\" width=\"561\" height=\"500\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa setiap sel dalam rentang <strong>B2:B11<\/strong> sekarang berisi teks yang dibungkus.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 3: Bungkus teks semua sel di lembar kerja menggunakan VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita bisa membuat makro berikut untuk membungkus teks di setiap sel lembar kerja:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> UseWrapText()\n<span style=\"color: #0000ff;\"><span style=\"color: #000000;\">Cells.WrapText = True<\/span>\nEnd 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-38023 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/envelopper4.png\" alt=\"\" width=\"561\" height=\"500\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa setiap sel di lembar kerja sekarang berisi teks yang dibungkus.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk properti VBA <strong>WrapText<\/strong> <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/api\/excel.range.wraptext\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/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\/font-warna-vba\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara mengubah warna font<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-mengganti-karakter-dalam-string\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara mengganti karakter dalam sebuah string<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-menyisipkan-baris-dengan-pemformatan\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menyisipkan baris dengan format<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda bisa menggunakan properti WrapText di VBA untuk membungkus teks dalam sel tertentu di lembar kerja Excel. Berikut tiga cara umum untuk menggunakan properti ini dalam praktik: Metode 1: Bungkus teks sel tertentu Sub UseWrapText() Range(&#8221; B2 &#8220;).WrapText = True End Sub Metode 2: Bungkus Teks Sel dalam Rentang Tertentu SubUseWrapText () Range(&#8221; B2:B11 &#8220;).WrapText [&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>Cara Membungkus Teks Menggunakan VBA (dengan Contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membungkus teks dalam sel di lembar Excel menggunakan VBA, dengan sebuah 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\/vba-membungkus-teks\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Membungkus Teks Menggunakan VBA (dengan Contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membungkus teks dalam sel di lembar Excel menggunakan VBA, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-membungkus-teks\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T01:32:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/envelopper0.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\/vba-membungkus-teks\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-membungkus-teks\/\",\"name\":\"Cara Membungkus Teks Menggunakan VBA (dengan Contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T01:32:09+00:00\",\"dateModified\":\"2023-07-07T01:32:09+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membungkus teks dalam sel di lembar Excel menggunakan VBA, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-membungkus-teks\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-membungkus-teks\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-membungkus-teks\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membungkus teks menggunakan vba (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":"Cara Membungkus Teks Menggunakan VBA (dengan Contoh) - Statorials","description":"Tutorial ini menjelaskan cara membungkus teks dalam sel di lembar Excel menggunakan VBA, dengan sebuah 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\/vba-membungkus-teks\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Membungkus Teks Menggunakan VBA (dengan Contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara membungkus teks dalam sel di lembar Excel menggunakan VBA, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/vba-membungkus-teks\/","og_site_name":"Statorials","article_published_time":"2023-07-07T01:32:09+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/envelopper0.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\/vba-membungkus-teks\/","url":"https:\/\/statorials.org\/id\/vba-membungkus-teks\/","name":"Cara Membungkus Teks Menggunakan VBA (dengan Contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T01:32:09+00:00","dateModified":"2023-07-07T01:32:09+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membungkus teks dalam sel di lembar Excel menggunakan VBA, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-membungkus-teks\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-membungkus-teks\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-membungkus-teks\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membungkus teks menggunakan vba (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\/4868"}],"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=4868"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4868\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4868"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4868"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4868"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}