{"id":2062,"date":"2023-10-21T13:57:49","date_gmt":"2023-10-21T13:57:49","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/huruf-karakter\/"},"modified":"2023-12-06T06:18:08","modified_gmt":"2023-12-06T06:18:08","slug":"huruf-karakter","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/huruf-karakter\/","title":{"rendered":"Bagaimana cara mengubah font menggunakan vba?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3496487641\"><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\">Catatan penting<\/h2><ul><li> Untuk melakukan perubahan pada font, Anda harus menggunakan objek VBA Font.<\/li><li> Ada total 18 properti dengan objek font yang dapat Anda akses dan ubah.<\/li><\/ul><h2 class=\"wp-block-heading\"> Objek font VBA<\/h2><p> Di VBA terdapat objek font yang dapat Anda gunakan untuk mengubah properti font dari suatu sel, seperti warna font, ukuran font, jenis font, dan Anda juga dapat menerapkan huruf tebal dan miring pada font.<\/p><h3 class=\"wp-block-heading\"> Sintaksis<\/h3><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">expression.font<\/code><\/pre><p> Untuk menggunakannya, Anda harus mengatur alamat sel terlebih dahulu, yang dapat Anda tentukan dengan cara berikut.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Selection.Font Range(\"A1\").Font Cells(1, 1).Font Range(\"A1:A5\").Font<\/code><\/pre><h2 class=\"wp-block-heading\"> Warna font VBA<\/h2><p> Untuk mengubah warna font, Anda memiliki dua cara berbeda:<\/p><h3 class=\"wp-block-heading\"> 1. Menggunakan konstanta warna<\/h3><p> Excel memiliki beberapa konstanta warna yang bisa Anda gunakan untuk menerapkan warna pada font. Misalnya, jika Anda ingin menerapkan warna merah pada font di sel A1, kodenya akan seperti di bawah ini: <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1\").Font.Color = vbRed<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-50948\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-en-utilisant-des-constantes-de-couleur.png\" sizes=\"auto, \" srcset=\"\" alt=\"menggunakan konstanta warna\" width=\"317\" height=\"157\"><\/figure><\/div><p> Dalam kode di atas, setelah objek font, warna adalah propertinya dan Anda telah menggunakan konstanta vbRed yang memberitahu VBA untuk menerapkan warna merah ke sel A1. Ada total delapan konstanta yang dapat Anda gunakan:<\/p><ol type=\"1\"><li> vbHitam: Hitam<\/li><li> vbMerah: Merah<\/li><li> vbHijau: Hijau<\/li><li> vbKuning: Kuning<\/li><li> vbBiru: Biru<\/li><li> vbMagenta: Magenta<\/li><li> vbCyan: cyan<\/li><li> vbPutih: Putih<\/li><\/ol><h3 class=\"wp-block-heading\"> 2. Menggunakan RGB<\/h3><p> Anda juga dapat menggunakan kode warna RGB untuk menerapkan warna pada font. RGB adalah kombinasi warna merah, hijau, dan biru, di mana Anda dapat membuat warna khusus menggunakan kode. Katakanlah jika Anda ingin menerapkan kombinasi warna hijau dan biru ke sel A1, kodenya adalah: <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1\").Font.Color = RGB(0, 255, 255)<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-50949\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-en-utilisant-RVB.png\" sizes=\"auto, \" srcset=\"\" alt=\"menggunakan-rgb\" width=\"462\" height=\"174\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Ukuran font VBA<\/h2><p> Objek Font juga memberi Anda akses ke properti ukuran font. Misalkan Anda ingin menerapkan ukuran font 16 pada font di sel A1, kodenya adalah: <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1\").Font.Size = 16<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-50950\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-taille-de-police-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"ukuran font vba\" width=\"363\" height=\"161\"><\/figure><\/div><p> Jika Anda ingin menerapkan ukuran font ke semua sel di lembar kerja, Anda bisa menggunakan kode berikut:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Cells.Font.Size = 16<\/code><\/pre><p> Dan jika Anda hanya ingin menerapkan ukuran font ke sel tempat Anda memiliki data, kodenya adalah:<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">ActiveSheet.UsedRange.Font.Size = 16<\/code><\/pre><p> Atau ke sel yang dipilih.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Selection.Font.Size = 16<\/code><\/pre><h2 class=\"wp-block-heading\"> Nama font VBA<\/h2><p> Demikian pula, Anda juga dapat mengubah nama font menggunakan properti nama objek font. Katakanlah <a href=\"https:\/\/exceladvisor.org\/id\/font-terbaik\/\">Anda ingin menerapkan font &#8220;Consolas&#8221;<\/a> ke sel A1. Kodenya adalah: <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1\").Font.Name = \"Consolas\"<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-50951\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-nom-de-police-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-font-nama\" width=\"344\" height=\"144\"><\/figure><\/div><p> Saat menggunakan properti ini, Anda harus mengetikkan nama font yang ingin Anda terapkan dengan benar, dan jika namanya salah, Anda tidak akan menampilkan kesalahan.<\/p><h2 class=\"wp-block-heading\"> Font VBA tebal, miring, dan bergaris bawah<\/h2><p> Ada juga properti yang bisa Anda gunakan untuk membuat font menjadi tebal, miring, dan bergaris bawah. Di bawah ini adalah kode yang perlu Anda tulis untuk ini. <\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1\").Font.Bold = True Range(\"A1\").Font.Italic = True Range(\"A1\").Font.Underline = True<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-50952\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-police-vba-gras-italique-souligne.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-bold-font-italic-garis bawah\" width=\"327\" height=\"163\"><\/figure><\/div><p> Dengan properti ini, Anda harus menyetel TRUE atau FALSE. Jadi jika fontnya sudah tebal atau miring dan ingin dihilangkan, maka perlu menggunakan FALSE untuk menghilangkannya.<\/p><h2 class=\"wp-block-heading\"> Properti Font Berguna Lainnya<\/h2><p> Tambahkan beberapa properti tambahan di sini yang mungkin berguna bagi Anda ( <a href=\"https:\/\/exceladvisor.org\/id\/tongkat\/\">Dicoret<\/a> , <a href=\"https:\/\/exceladvisor.org\/id\/indeks-2\/\">Subskrip<\/a> , dan <a href=\"https:\/\/exceladvisor.org\/id\/eksponen\/\">Superskrip<\/a> ).<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\"A1\").Font.Strikethrough = True Range(\"A1\").Font.Subscript = True Range(\"A1\").Font.Superscript = True<\/code><\/pre><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\/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><li> <a href=\"https:\/\/exceladvisor.org\/id\/temukan-sel-kolom-baris-terakhir\/\">Temukan Baris, Kolom, dan Sel Terakhir Menggunakan VBA di Excel<\/a><\/li><\/ul><\/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-2062","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 mengubah font menggunakan VBA?<\/title>\n<meta name=\"description\" content=\"Untuk melakukan perubahan font pada sel, Anda harus menggunakan objek font VBA.\" \/>\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\/huruf-karakter\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara mengubah font menggunakan VBA?\" \/>\n<meta property=\"og:description\" content=\"Untuk melakukan perubahan font pada sel, Anda harus menggunakan objek font VBA.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/huruf-karakter\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-en-utilisant-des-constantes-de-couleur.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=\"3 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/huruf-karakter\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/huruf-karakter\/\",\"name\":\"Bagaimana cara mengubah font menggunakan VBA?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/huruf-karakter\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/huruf-karakter\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-en-utilisant-des-constantes-de-couleur.png\",\"datePublished\":\"2023-10-21T13:57:49+00:00\",\"dateModified\":\"2023-12-06T06:18:08+00:00\",\"description\":\"Untuk melakukan perubahan font pada sel, Anda harus menggunakan objek font VBA.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/huruf-karakter\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/huruf-karakter\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/huruf-karakter\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-en-utilisant-des-constantes-de-couleur.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-en-utilisant-des-constantes-de-couleur.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/huruf-karakter\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara mengubah font menggunakan 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 mengubah font menggunakan VBA?","description":"Untuk melakukan perubahan font pada sel, Anda harus menggunakan objek font VBA.","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\/huruf-karakter\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara mengubah font menggunakan VBA?","og_description":"Untuk melakukan perubahan font pada sel, Anda harus menggunakan objek font VBA.","og_url":"https:\/\/exceladvisor.org\/id\/huruf-karakter\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:08+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-en-utilisant-des-constantes-de-couleur.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"3 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/huruf-karakter\/","url":"https:\/\/exceladvisor.org\/id\/huruf-karakter\/","name":"Bagaimana cara mengubah font menggunakan VBA?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/huruf-karakter\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/huruf-karakter\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-en-utilisant-des-constantes-de-couleur.png","datePublished":"2023-10-21T13:57:49+00:00","dateModified":"2023-12-06T06:18:08+00:00","description":"Untuk melakukan perubahan font pada sel, Anda harus menggunakan objek font VBA.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/huruf-karakter\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/huruf-karakter\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/huruf-karakter\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-en-utilisant-des-constantes-de-couleur.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-en-utilisant-des-constantes-de-couleur.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/huruf-karakter\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara mengubah font menggunakan 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\/2062","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=2062"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2062\/revisions"}],"predecessor-version":[{"id":2686,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2062\/revisions\/2686"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2062"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}