{"id":4387,"date":"2023-07-11T12:12:41","date_gmt":"2023-07-11T12:12:41","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-mengonversi-string-menjadi-integer\/"},"modified":"2023-07-11T12:12:41","modified_gmt":"2023-07-11T12:12:41","slug":"vba-mengonversi-string-menjadi-integer","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-mengonversi-string-menjadi-integer\/","title":{"rendered":"Cara mengonversi string ke integer di vba (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\"><span style=\"color: #000000;\">Anda dapat menggunakan fungsi <strong>CInt<\/strong> di VBA untuk mengonversi string teks menjadi bilangan bulat.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Berikut dua cara umum untuk menggunakan fitur ini dalam praktiknya:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Ubah String menjadi Integer di VBA<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #0000ff;\">Sub<\/span> ConvertStringToInteger()\n\n    <span style=\"color: #0000ff;\">Dim<\/span> i <span style=\"color: #0000ff;\">As<\/span> Integer\n\n    <span style=\"color: #0000ff;\">For<\/span> i = 2 <span style=\"color: #0000ff;\">To<\/span> 11\n        Range(\" <span style=\"color: #ff0000;\">B<\/span> \" &amp; i) = CInt(Range(\" <span style=\"color: #ff0000;\">A<\/span> \" &amp; i))\n    <span style=\"color: #0000ff;\">Next<\/span> i\n\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Makro khusus ini akan mengonversi setiap string dalam rentang <strong>A2:A11<\/strong> menjadi bilangan bulat dan menampilkan bilangan bulat dalam rentang <strong>B2:B11<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Ubah String menjadi Integer di VBA (Hanya jika String adalah Angka)<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> ConvertStringToInteger()\n\n    <span style=\"color: #0000ff;\">Dim<\/span> i <span style=\"color: #0000ff;\">As<\/span> Integer\n\n    <span style=\"color: #0000ff;\">For<\/span> i = 2 <span style=\"color: #0000ff;\">To<\/span> 11\n        <span style=\"color: #0000ff;\">If<\/span> IsNumeric(Range(\" <span style=\"color: #ff0000;\">A<\/span> \" &amp; i)) <span style=\"color: #0000ff;\">Then<\/span>\n            Range(\" <span style=\"color: #ff0000;\">B<\/span> \" &amp; i) = CInt(Range(\" <span style=\"color: #ff0000;\">A<\/span> \" &amp; i))\n        <span style=\"color: #0000ff;\">Else<\/span>\n            Range(\" <span style=\"color: #ff0000;\">B<\/span> \" &amp; i) = 0\n        <span style=\"color: #0000ff;\">End If<\/span>\n    <span style=\"color: #0000ff;\">Next<\/span> i\n\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Makro khusus ini akan mengonversi setiap string dalam rentang <strong>A2:A11<\/strong> menjadi bilangan bulat hanya jika string tersebut berupa angka. Jika tidak, string akan dikonversi ke nilai null.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan masing-masing metode dalam praktik.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Konversi String ke Integer di VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kolom nilai berikut di Excel, yang saat ini diformat sebagai string teks:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34422 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vcon1.jpg\" alt=\"\" width=\"466\" height=\"404\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin mengonversi setiap string menjadi bilangan bulat dan menampilkan bilangan bulat di kolom B.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #0000ff;\">Sub<\/span> ConvertStringToInteger()\n\n    <span style=\"color: #0000ff;\">Dim<\/span> i <span style=\"color: #0000ff;\">As<\/span> Integer\n\n    <span style=\"color: #0000ff;\">For<\/span> i = 2 <span style=\"color: #0000ff;\">To<\/span> 11\n        Range(\" <span style=\"color: #ff0000;\">B<\/span> \" &amp; i) = CInt(Range(\" <span style=\"color: #ff0000;\">A<\/span> \" &amp; i))\n    <span style=\"color: #0000ff;\">Next<\/span> i\n\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34423 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vcon2.jpg\" alt=\"\" width=\"519\" height=\"416\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa setiap string teks di kolom A telah dikonversi menjadi bilangan bulat dan ditampilkan di kolom B.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Ubah String menjadi Integer di VBA (Hanya jika String adalah Angka)<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki kolom nilai berikut di Excel, yang saat ini diformat sebagai string teks:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34424 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vcon3.jpg\" alt=\"\" width=\"480\" height=\"430\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin mengonversi setiap string menjadi bilangan bulat <em>hanya jika string tersebut berupa angka<\/em> dan menampilkan bilangan bulat di kolom B.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> ConvertStringToInteger()\n\n    <span style=\"color: #0000ff;\">Dim<\/span> i <span style=\"color: #0000ff;\">As<\/span> Integer\n\n    <span style=\"color: #0000ff;\">For<\/span> i = 2 <span style=\"color: #0000ff;\">To<\/span> 11\n        <span style=\"color: #0000ff;\">If<\/span> IsNumeric(Range(\" <span style=\"color: #ff0000;\">A<\/span> \" &amp; i)) <span style=\"color: #0000ff;\">Then<\/span>\n            Range(\" <span style=\"color: #ff0000;\">B<\/span> \" &amp; i) = CInt(Range(\" <span style=\"color: #ff0000;\">A<\/span> \" &amp; i))\n        <span style=\"color: #0000ff;\">Else<\/span>\n            Range(\" <span style=\"color: #ff0000;\">B<\/span> \" &amp; i) = 0\n        <span style=\"color: #0000ff;\">End If<\/span>\n    <span style=\"color: #0000ff;\">Next<\/span> i\n\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-34425 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vcon4.jpg\" alt=\"\" width=\"471\" height=\"421\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa hanya string teks di kolom A yang berupa angka yang dikonversi menjadi bilangan bulat di kolom B.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika tidak, string teks hanya akan dikonversi ke nilai nol.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk fungsi VBA <b>Cint<\/b> <a href=\"https:\/\/learn.microsoft.com\/en-us\/office\/vba\/language\/concepts\/getting-started\/type-conversion-functions\" 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-menghapus-spasi-dari-string\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghilangkan spasi pada string<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-menghitung-kemunculan-karakter-dalam-string\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menghitung kemunculan karakter dalam sebuah string<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-berisi-string\/\" target=\"_blank\" rel=\"noopener\">VBA: cara memeriksa apakah suatu string berisi string lain<\/a><br \/><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan fungsi CInt di VBA untuk mengonversi string teks menjadi bilangan bulat. Berikut dua cara umum untuk menggunakan fitur ini dalam praktiknya: Metode 1: Ubah String menjadi Integer di VBA Sub ConvertStringToInteger() Dim i As Integer For i = 2 To 11 Range(&#8221; B &#8221; &amp; i) = CInt(Range(&#8221; A &#8221; &amp; i)) [&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 Mengonversi String ke Integer di VBA (dengan Contoh) - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengubah string menjadi integer 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\/vba-mengonversi-string-menjadi-integer\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mengonversi String ke Integer di VBA (dengan Contoh) - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengubah string menjadi integer menggunakan VBA, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-mengonversi-string-menjadi-integer\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T12:12:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vcon1.jpg\" \/>\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-mengonversi-string-menjadi-integer\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-mengonversi-string-menjadi-integer\/\",\"name\":\"Cara Mengonversi String ke Integer di VBA (dengan Contoh) - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T12:12:41+00:00\",\"dateModified\":\"2023-07-11T12:12:41+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengubah string menjadi integer menggunakan VBA, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-mengonversi-string-menjadi-integer\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-mengonversi-string-menjadi-integer\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-mengonversi-string-menjadi-integer\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengonversi string ke integer di 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 Mengonversi String ke Integer di VBA (dengan Contoh) - Statorial","description":"Tutorial ini menjelaskan cara mengubah string menjadi integer 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\/vba-mengonversi-string-menjadi-integer\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mengonversi String ke Integer di VBA (dengan Contoh) - Statorial","og_description":"Tutorial ini menjelaskan cara mengubah string menjadi integer menggunakan VBA, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/vba-mengonversi-string-menjadi-integer\/","og_site_name":"Statorials","article_published_time":"2023-07-11T12:12:41+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vcon1.jpg"}],"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-mengonversi-string-menjadi-integer\/","url":"https:\/\/statorials.org\/id\/vba-mengonversi-string-menjadi-integer\/","name":"Cara Mengonversi String ke Integer di VBA (dengan Contoh) - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T12:12:41+00:00","dateModified":"2023-07-11T12:12:41+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengubah string menjadi integer menggunakan VBA, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-mengonversi-string-menjadi-integer\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-mengonversi-string-menjadi-integer\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-mengonversi-string-menjadi-integer\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengonversi string ke integer di 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\/4387"}],"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=4387"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4387\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4387"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4387"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4387"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}