{"id":4913,"date":"2023-07-06T12:08:03","date_gmt":"2023-07-06T12:08:03","guid":{"rendered":"https:\/\/statorials.org\/id\/format-sel-vba\/"},"modified":"2023-07-06T12:08:03","modified_gmt":"2023-07-06T12:08:03","slug":"format-sel-vba","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/format-sel-vba\/","title":{"rendered":"Cara memformat sel di excel menggunakan vba (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Ada berbagai macam cara memformat sel di Excel menggunakan <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/api\/excel.cellformat\" target=\"_blank\" rel=\"noopener\">berbagai properti<\/a> di VBA, antara lain:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Tambahkan indentasi<\/span><\/li>\n<li> <span style=\"color: #000000;\">Aplikasi<\/span><\/li>\n<li> <span style=\"color: #000000;\">Perbatasan<\/span><\/li>\n<li> <span style=\"color: #000000;\">Pencipta<\/span><\/li>\n<li> <span style=\"color: #000000;\">Fonta karakter<\/span><\/li>\n<li> <span style=\"color: #000000;\">Rumus Tersembunyi<\/span><\/li>\n<li> <span style=\"color: #000000;\">Penjajaran horizontal<\/span><\/li>\n<li> <span style=\"color: #000000;\">Tingkat penarikan<\/span><\/li>\n<li> <span style=\"color: #000000;\">Pedalaman<\/span><\/li>\n<li> <span style=\"color: #000000;\">Terkunci<\/span><\/li>\n<li> <span style=\"color: #000000;\">Gabungkan Sel<\/span><\/li>\n<li> <span style=\"color: #000000;\">Format angka<\/span><\/li>\n<li> <span style=\"color: #000000;\">NomorLokalFormat<\/span><\/li>\n<li> <span style=\"color: #000000;\">Orientasi<\/span><\/li>\n<li> <span style=\"color: #000000;\">Induk<\/span><\/li>\n<li> <span style=\"color: #000000;\">KurangiUntuk Menyesuaikan<\/span><\/li>\n<li> <span style=\"color: #000000;\">Penjajaran vertikal<\/span><\/li>\n<li> <span style=\"color: #000000;\">Bungkus teks<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dengan membuat makro di VBA, Anda bisa menggunakan satu atau beberapa properti ini untuk memformat sel dalam rentang tertentu di lembar Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan bagaimana melakukan hal ini dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Cara Memformat Sel di Excel Menggunakan VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki daftar nama tim bola basket berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38355 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/formatercell1.png\" alt=\"\" width=\"447\" height=\"402\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk memformat setiap sel dalam rentang <strong>A2:A11<\/strong> dengan properti tertentu:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubFormatCells<\/span> ()\n\n    <span style=\"color: #0000ff;\">With<\/span> Worksheets(\"Sheet1\").Range(\"A2:A11\")\n     .Font.FontStyle = \"Bold\"\n     .Font.Name = \"Calibri\"\n     .Font.Size = 13\n     .Font.Color = vbRed\n     .HorizontalAlignment = xlCenter\n    <span style=\"color: #0000ff;\">End With<\/span>\n\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Setelah makro ini berjalan, masing-masing sel dalam rentang <strong>A2:A11<\/strong> akan diformat seperti yang kita tentukan:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38356 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/formatercell2.png\" alt=\"\" width=\"446\" height=\"407\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dengan menggunakan makro khusus ini, kami membuat perubahan berikut pada setiap sel dalam rentang <strong>A2:A11<\/strong> :<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Kami mengubah gaya font menjadi tebal.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kami mengubah jenis font menjadi Calibri.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kami mengubah ukuran font menjadi 13.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kami mengubah warna font menjadi merah.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Kami memusatkan teks secara horizontal.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa contoh ini hanya memperlihatkan satu cara untuk memformat sel dalam rentang tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dengan menggunakan berbagai properti yang tersedia di VBA, Anda dapat memformat sel sesuai tampilan yang Anda inginkan.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap dari semua kemungkinan properti pemformatan sel di VBA <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/api\/excel.cellformat\" 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\/vba-huruf-tebal\/\" target=\"_blank\" rel=\"noopener\">Cara membuat font tebal menggunakan VBA<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/teks-pusat-vba\/\" target=\"_blank\" rel=\"noopener\">Cara Memusatkan Teks Menggunakan VBA<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/ukuran-font-vba\/\" target=\"_blank\" rel=\"noopener\">Cara mengatur ukuran font menggunakan VBA<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ada berbagai macam cara memformat sel di Excel menggunakan berbagai properti di VBA, antara lain: Tambahkan indentasi Aplikasi Perbatasan Pencipta Fonta karakter Rumus Tersembunyi Penjajaran horizontal Tingkat penarikan Pedalaman Terkunci Gabungkan Sel Format angka NomorLokalFormat Orientasi Induk KurangiUntuk Menyesuaikan Penjajaran vertikal Bungkus teks Dengan membuat makro di VBA, Anda bisa menggunakan satu atau beberapa properti [&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 Memformat Sel di Excel Menggunakan VBA (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memformat sel di Excel menggunakan 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\/format-sel-vba\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Memformat Sel di Excel Menggunakan VBA (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memformat sel di Excel menggunakan VBA, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/format-sel-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-06T12:08:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/formatercell1.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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/format-sel-vba\/\",\"url\":\"https:\/\/statorials.org\/id\/format-sel-vba\/\",\"name\":\"Cara Memformat Sel di Excel Menggunakan VBA (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-06T12:08:03+00:00\",\"dateModified\":\"2023-07-06T12:08:03+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memformat sel di Excel menggunakan VBA, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/format-sel-vba\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/format-sel-vba\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/format-sel-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara memformat sel di excel 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 Memformat Sel di Excel Menggunakan VBA (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara memformat sel di Excel menggunakan 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\/format-sel-vba\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Memformat Sel di Excel Menggunakan VBA (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara memformat sel di Excel menggunakan VBA, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/format-sel-vba\/","og_site_name":"Statorials","article_published_time":"2023-07-06T12:08:03+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/formatercell1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/format-sel-vba\/","url":"https:\/\/statorials.org\/id\/format-sel-vba\/","name":"Cara Memformat Sel di Excel Menggunakan VBA (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-06T12:08:03+00:00","dateModified":"2023-07-06T12:08:03+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memformat sel di Excel menggunakan VBA, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/format-sel-vba\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/format-sel-vba\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/format-sel-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara memformat sel di excel 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\/4913"}],"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=4913"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4913\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4913"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4913"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4913"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}