{"id":4871,"date":"2023-07-07T00:38:43","date_gmt":"2023-07-07T00:38:43","guid":{"rendered":"https:\/\/statorials.org\/id\/ukuran-font-vba\/"},"modified":"2023-07-07T00:38:43","modified_gmt":"2023-07-07T00:38:43","slug":"ukuran-font-vba","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/ukuran-font-vba\/","title":{"rendered":"Cara mengatur ukuran font menggunakan vba (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan properti <strong>Font.Size<\/strong> di VBA untuk mendapatkan dan mengatur ukuran font sel tertentu di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, Anda bisa menggunakan makro berikut untuk membuat kotak pesan yang menampilkan ukuran font sel <strong>A1<\/strong> saat ini :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubGetFontSize<\/span> ()\nMsgBox Range(\" <span style=\"color: #ff0000;\">A1<\/span> \").Font.Size\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Atau Anda bisa membuat makro berikut untuk mengatur ukuran font sel <strong>A1<\/strong> menjadi <strong>20<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> SetFontSize()\nRange(\u201c <span style=\"color: #ff0000;\">A1<\/span> \u201d). <span style=\"color: #000000;\">Font.Size = 20<\/span>\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Atau Anda bisa membuat makro berikut untuk membuat ukuran font di setiap sel dalam rentang <strong>A1:C1<\/strong> sama dengan <strong>20<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> SetFontSize()\nRange(\" <span style=\"color: #ff0000;\">A1:C1<\/span> \").Font.Size = 20\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara mendapatkan dan mengatur ukuran font menggunakan VBA dengan kumpulan data berikut di Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38040 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fs1.png\" alt=\"\" width=\"447\" height=\"395\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Dapatkan Ukuran Font Menggunakan VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk<\/span> <span style=\"color: #000000;\">membuat kotak pesan yang menampilkan ukuran font sel <strong>A1<\/strong> saat ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">SubGetFontSize<\/span> ()\nMsgBox Range(\" <span style=\"color: #ff0000;\">A1<\/span> \").Font.Size\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-38041 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fs2.png\" alt=\"\" width=\"512\" height=\"436\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kotak pesan memberitahu kita bahwa sel <strong>A1<\/strong> saat ini memiliki ukuran font <strong>11<\/strong> .<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Ini adalah ukuran font default di Excel.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Mengatur Ukuran Font Sel Tertentu Menggunakan VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk mengatur ukuran font sel <strong>A1<\/strong> menjadi <strong>20<\/strong> :<\/span><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> SetFontSize()\nRange(\" <span style=\"color: #ff0000;\">A1<\/span> \").Font.Size = 20\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-38042 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fs3.png\" alt=\"\" width=\"491\" height=\"494\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa ukuran font sel <strong>A1<\/strong> telah diubah menjadi <strong>20<\/strong> sedangkan ukuran font sel lainnya tetap tidak berubah.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 3: Mengatur Ukuran Font pada Rentang Sel Menggunakan VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk mengatur ukuran font setiap sel dalam rentang <strong>A1:C1<\/strong> hingga <strong>20<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> SetFontSize()\nRange(\" <span style=\"color: #ff0000;\">A1:C1<\/span> \").Font.Size = 20\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-38043 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fs4.png\" alt=\"\" width=\"462\" height=\"393\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa ukuran font setiap sel dalam rentang <strong>A1:C1<\/strong> telah diubah menjadi <strong>20<\/strong> sedangkan ukuran font semua sel lainnya tetap tidak berubah.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk properti VBA <strong>Font.Size<\/strong> <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/api\/excel.font.size\" 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-huruf-tebal\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara membuat font menjadi tebal<\/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 \/><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan properti Font.Size di VBA untuk mendapatkan dan mengatur ukuran font sel tertentu di Excel. Misalnya, Anda bisa menggunakan makro berikut untuk membuat kotak pesan yang menampilkan ukuran font sel A1 saat ini : SubGetFontSize () MsgBox Range(&#8221; A1 &#8220;).Font.Size End Sub Atau Anda bisa membuat makro berikut untuk mengatur ukuran font sel [&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 Mengatur Ukuran Font Menggunakan VBA (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengatur ukuran font sel di Excel menggunakan VBA, beserta contohnya.\" \/>\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\/ukuran-font-vba\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mengatur Ukuran Font Menggunakan VBA (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengatur ukuran font sel di Excel menggunakan VBA, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/ukuran-font-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-07T00:38:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fs1.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\/ukuran-font-vba\/\",\"url\":\"https:\/\/statorials.org\/id\/ukuran-font-vba\/\",\"name\":\"Cara Mengatur Ukuran Font Menggunakan VBA (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-07T00:38:43+00:00\",\"dateModified\":\"2023-07-07T00:38:43+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengatur ukuran font sel di Excel menggunakan VBA, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/ukuran-font-vba\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/ukuran-font-vba\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/ukuran-font-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengatur ukuran font 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 Mengatur Ukuran Font Menggunakan VBA (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara mengatur ukuran font sel di Excel menggunakan VBA, beserta contohnya.","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\/ukuran-font-vba\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mengatur Ukuran Font Menggunakan VBA (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara mengatur ukuran font sel di Excel menggunakan VBA, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/ukuran-font-vba\/","og_site_name":"Statorials","article_published_time":"2023-07-07T00:38:43+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/fs1.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\/ukuran-font-vba\/","url":"https:\/\/statorials.org\/id\/ukuran-font-vba\/","name":"Cara Mengatur Ukuran Font Menggunakan VBA (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-07T00:38:43+00:00","dateModified":"2023-07-07T00:38:43+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengatur ukuran font sel di Excel menggunakan VBA, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/ukuran-font-vba\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/ukuran-font-vba\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/ukuran-font-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengatur ukuran font 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\/4871"}],"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=4871"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4871\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4871"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4871"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4871"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}