{"id":2156,"date":"2023-09-28T18:12:05","date_gmt":"2023-09-28T18:12:05","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/membungkus-teks-1\/"},"modified":"2023-12-06T06:16:29","modified_gmt":"2023-12-06T06:16:29","slug":"membungkus-teks-1","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/membungkus-teks-1\/","title":{"rendered":"Bagaimana cara menggunakan bungkus teks di mana saja melalui vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-4178505290\"><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>Di VBA, ada properti bernama &#8220;WrapText&#8221; yang dapat Anda akses untuk menerapkan teks pembungkus ke sel atau rentang sel. Anda harus menulis kode untuk mengaktifkan atau menonaktifkannya. Ini adalah properti baca dan tulis, jadi Anda bisa menerapkannya, atau Anda juga bisa mendapatkannya jika diterapkan pada sel.<\/p><p> Dalam tutorial ini, kita akan melihat berbagai cara untuk menerapkan teks pembungkus menggunakan kode VBA.<\/p><h2 class=\"wp-block-heading\"> Bungkus teks dalam sel menggunakan VBA<\/h2><p> Gunakan langkah-langkah berikut untuk menerapkan Bungkus Teks menggunakan kode VBA.<\/p><ol><li> Tentukan sel tempat Anda ingin menerapkan teks pembungkus menggunakan <a href=\"https:\/\/exceladvisor.org\/id\/rentang-1\/\">properti rentang<\/a> .<\/li><li> Ketikkan titik untuk melihat daftar <a href=\"https:\/\/exceladvisor.org\/id\/objek\/\">properti dan metode<\/a> sel tersebut.<\/li><li> Pilih properti \u201cWrapText\u201d dari daftar.<\/li><li> Masukkan tanda sama dengan \u201c=\u201d dan ketik TRUE untuk mengaktifkan pembungkusan kata.<\/li><\/ol><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub vba_wrap_text() Range(\"A1\").WrapText = True End Sub<\/code><\/pre><p> Anda juga dapat menentukan sel dengan cara berikut.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Cells(1, 1).WrapText = True<\/code><\/pre><h2 class=\"wp-block-heading\"> Bungkus teks dalam deretan sel<\/h2><p> Dan jika Anda ingin menerapkan teks pembungkus ke seluruh rentang, Anda perlu menentukan rentang, bukan satu sel.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1:A5\").WrapText = True<\/code><\/pre><p> Anda juga dapat menerapkannya ke rentang yang digunakan (pemilihan lembar kerja tempat Anda memasukkan data) menggunakan properti \u201cUsedRange\u201d. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Worksheets(\"Sheet1\").UsedRange.WrapText = True ActiveSheet.UsedRange.WrapText = True<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51968\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-appliquer-le-texte-dhabillage-a-la-plage-utilisee.png\" sizes=\"auto, \" srcset=\"\" alt=\"terapkan-bungkus-teks-ke-rentang yang digunakan\" width=\"539\" height=\"243\"><\/figure><\/div><p> Pada baris pertama kode di atas, Anda <a href=\"https:\/\/exceladvisor.org\/id\/lembar-kerja-1\/\">menentukan Lembar Kerja<\/a> dan kemudian &#8220;Properti Bekas&#8221; untuk membungkus teks. Di baris kedua Anda memiliki rentang <a href=\"https:\/\/exceladvisor.org\/id\/aktifkan-lembar\/\">lembar aktif<\/a> yang digunakan. Namun kedua jalur tersebut bekerja dengan cara yang sama.<\/p><p> Berikut beberapa contoh lagi yang harus Anda ketahui:<\/p><ul><li> Sel yang tidak kontinu<\/li><li> Seluruh baris<\/li><li> Seluruh kolom<\/li><li> Rentang bernama <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51969\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-quelques-exemples-de-texte-dhabillage.png\" sizes=\"auto, \" srcset=\"\" alt=\"beberapa contoh-teks-bungkus\" width=\"565\" height=\"289\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1:A10,C1:C10\").WrapText = True Range(\"A:A\").WrapText = True Range(\"1:1\").WrapText = True Range(\"myRange\").WrapText = True<\/code><\/pre><h2 class=\"wp-block-heading\"> Bungkus teks di seluruh lembar kerja<\/h2><p> Untuk merujuk ke seluruh lembar kerja, Anda perlu menggunakan properti Sel seperti yang Anda miliki pada kode berikut. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Cells.WrapText = True Worksheets(\"Sheet1\").Cells.WrapText = True<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51970\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-envelopper-le-texte-dans-toute-la-feuille-de-calcul.png\" sizes=\"auto, \" srcset=\"\" alt=\"bungkus-teks-ke-seluruh-lembar kerja\" width=\"531\" height=\"219\"><\/figure><\/div><p> Baris kode pertama mengacu pada lembar aktif dan baris kedua mengacu pada lembar kerja &#8220;Sheet1&#8221;. Anda juga bisa menggunakan perulangan menggunakan <a href=\"https:\/\/exceladvisor.org\/id\/untuk-lingkaran\/\">FOR EACH (Untuk Berikutnya)<\/a> untuk <a href=\"https:\/\/exceladvisor.org\/id\/daun-lingkaran\/\">mengulang semua lembar kerja<\/a> di buku kerja dan menerapkan teks pembungkus ke semua sel. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-51971\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-boucle-a-utiliser-pour-appliquer-le-texte-dhabillage.png\" sizes=\"auto, \" srcset=\"\" alt=\"loop-menggunakan-untuk-menerapkan-bungkus-teks\" width=\"495\" height=\"301\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets Cells.WrapText = True Next ws<\/code><\/pre><p> Dalam kode di atas, Anda memiliki &#8220;ws&#8221; sebagai <a href=\"https:\/\/exceladvisor.org\/id\/variabel\/\">variabel<\/a> , lalu For Each Loop mengulang semua lembar kerja di buku kerja dan berlaku untuk membungkus teks seluruh lembar kerja menggunakan Sel.<\/p><h2 class=\"wp-block-heading\"> Nonaktifkan WrapText<\/h2><p> Seperti yang Anda lihat, Anda perlu mengaktifkan properti WrapText dan Anda juga dapat menonaktifkannya menggunakan add yang mendeklarasikan FALSE.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1\").WrapText = False<\/code><\/pre><p class=\"qt-tip\"> <strong>Catatan:<\/strong> Ada satu hal yang perlu Anda pahami jika Anda memiliki nilai dalam sel dan lebar sel cukup untuk menyimpan nilai itu, bahkan jika Anda menerapkan teks ke baris, Excel <a href=\"https:\/\/exceladvisor.org\/id\/garis-baru\/\">tidak akan memindahkan konten ke baris berikutnya<\/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\/jumlah-baris\/\">Hitung baris menggunakan VBA di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/huruf-karakter\/\">Font Excel VBA (warna, ukuran, jenis dan tebal)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sembunyikan-tampilkan-baris-kolom\/\">Excel VBA Sembunyikan dan tampilkan kolom atau baris<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/rentang-1\/\">Rentang VBA Excel \u2013 Bekerja dengan Rentang dan Sel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/perbatasan\/\">Terapkan batas ke sel menggunakan VBA di Excel<\/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-2156","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 menggunakan Bungkus Teks di mana saja melalui VBA? - Penasihat Excel<\/title>\n<meta name=\"description\" content=\"Tutorial ini memperlihatkan cara menulis kode VBA untuk membungkus teks dalam sel, rentang, dan seluruh lembar kerja.\" \/>\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\/membungkus-teks-1\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menggunakan Bungkus Teks di mana saja melalui VBA? - Penasihat Excel\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini memperlihatkan cara menulis kode VBA untuk membungkus teks dalam sel, rentang, dan seluruh lembar kerja.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/membungkus-teks-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:16:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-appliquer-le-texte-dhabillage-a-la-plage-utilisee.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\/membungkus-teks-1\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/membungkus-teks-1\/\",\"name\":\"Bagaimana cara menggunakan Bungkus Teks di mana saja melalui VBA? - Penasihat Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/membungkus-teks-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/membungkus-teks-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-appliquer-le-texte-dhabillage-a-la-plage-utilisee.png\",\"datePublished\":\"2023-09-28T18:12:05+00:00\",\"dateModified\":\"2023-12-06T06:16:29+00:00\",\"description\":\"Tutorial ini memperlihatkan cara menulis kode VBA untuk membungkus teks dalam sel, rentang, dan seluruh lembar kerja.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/membungkus-teks-1\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/membungkus-teks-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/membungkus-teks-1\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-appliquer-le-texte-dhabillage-a-la-plage-utilisee.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-appliquer-le-texte-dhabillage-a-la-plage-utilisee.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/membungkus-teks-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan bungkus teks di mana saja melalui 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 menggunakan Bungkus Teks di mana saja melalui VBA? - Penasihat Excel","description":"Tutorial ini memperlihatkan cara menulis kode VBA untuk membungkus teks dalam sel, rentang, dan seluruh lembar kerja.","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\/membungkus-teks-1\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menggunakan Bungkus Teks di mana saja melalui VBA? - Penasihat Excel","og_description":"Tutorial ini memperlihatkan cara menulis kode VBA untuk membungkus teks dalam sel, rentang, dan seluruh lembar kerja.","og_url":"https:\/\/exceladvisor.org\/id\/membungkus-teks-1\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:16:29+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-appliquer-le-texte-dhabillage-a-la-plage-utilisee.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\/membungkus-teks-1\/","url":"https:\/\/exceladvisor.org\/id\/membungkus-teks-1\/","name":"Bagaimana cara menggunakan Bungkus Teks di mana saja melalui VBA? - Penasihat Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/membungkus-teks-1\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/membungkus-teks-1\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-appliquer-le-texte-dhabillage-a-la-plage-utilisee.png","datePublished":"2023-09-28T18:12:05+00:00","dateModified":"2023-12-06T06:16:29+00:00","description":"Tutorial ini memperlihatkan cara menulis kode VBA untuk membungkus teks dalam sel, rentang, dan seluruh lembar kerja.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/membungkus-teks-1\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/membungkus-teks-1\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/membungkus-teks-1\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-appliquer-le-texte-dhabillage-a-la-plage-utilisee.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-appliquer-le-texte-dhabillage-a-la-plage-utilisee.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/membungkus-teks-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan bungkus teks di mana saja melalui 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\/2156","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=2156"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2156\/revisions"}],"predecessor-version":[{"id":2538,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2156\/revisions\/2538"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2156"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}