{"id":4389,"date":"2023-07-11T11:52:06","date_gmt":"2023-07-11T11:52:06","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-mengonversi-string-menjadi-ganda\/"},"modified":"2023-07-11T11:52:06","modified_gmt":"2023-07-11T11:52:06","slug":"vba-mengonversi-string-menjadi-ganda","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-mengonversi-string-menjadi-ganda\/","title":{"rendered":"Cara mengonversi string menjadi double di vba (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan fungsi CDbl<\/strong> di VBA untuk mengonversi string teks menjadi tipe data ganda.<\/span><\/p>\n

Berikut cara umum untuk menggunakan fungsi ini dalam praktik:<\/span><\/p>\n

 Sub<\/span> ConvertStringToDouble()\n\n    Dim<\/span> i As<\/span> Integer\n\n    For<\/span> i = 2 To<\/span> 11\n        If<\/span> IsNumeric(Range(\" A<\/span> \" & i)) Then<\/span>\n            Range(\" B<\/span> \" & i) = CDbl(Range(\" A<\/span> \" & i))\n        Else<\/span>\n            Range(\" B<\/span> \" & i) = 0\n        End If<\/span>\n    Next<\/span> i\n\nEnd Sub\n<\/span><\/strong><\/span><\/pre>\n
 Makro khusus ini akan mengonversi setiap string dalam rentang A2:A11<\/strong> menjadi tipe data ganda hanya jika string tersebut berupa angka.<\/span><\/p>\n
 Jika tidak, string akan dikonversi ke nilai null.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Ubah String menjadi Double di VBA<\/strong><\/span><\/h2>\n
 Katakanlah kita memiliki kolom nilai berikut di Excel, yang saat ini diformat sebagai string teks:<\/span> <\/p>\n
\"\"<\/p>\n
 Misalkan kita ingin mengonversi setiap string menjadi tipe data ganda hanya jika string tersebut berupa angka<\/em> dan menampilkannya di kolom B.<\/span><\/p>\n
 Kita dapat membuat makro berikut untuk melakukan ini:<\/span><\/p>\n
 Sub<\/span> ConvertStringToDouble()\n\n    Dim<\/span> i As<\/span> Integer\n\n    For<\/span> i = 2 To<\/span> 11\n        If<\/span> IsNumeric(Range(\" A<\/span> \" & i)) Then<\/span>\n            Range(\" B<\/span> \" & i) = CDbl(Range(\" A<\/span> \" & i))\n        Else<\/span>\n            Range(\" B<\/span> \" & i) = 0\n        End If<\/span>\n    Next<\/span> i\n\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Saat kami menjalankan makro ini, kami menerima keluaran berikut:<\/span> <\/p>\n
\"\"<\/p>\n
 Perhatikan bahwa hanya string teks di kolom A yang berupa angka yang dikonversi menjadi tipe data ganda di kolom B.<\/span><\/p>\n
 Jika tidak, string teks hanya akan dikonversi ke nilai nol.<\/span><\/p>\n
 Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap untuk fungsi VBA CDbl<\/b> di sini<\/a> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di VBA:<\/span><\/p>\n
 Bagaimana mengkonversi string ke int di VBA<\/a>
 Cara mengubah string menjadi panjang di VBA<\/a>
<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan fungsi CDbl di VBA untuk mengonversi string teks menjadi tipe data ganda. Berikut cara umum untuk menggunakan fungsi ini dalam praktik: Sub ConvertStringToDouble() Dim i As Integer For i = 2 To 11 If IsNumeric(Range(” A ” & i)) Then Range(” B ” & i) = CDbl(Range(” A ” & i)) Else […]<\/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":"\nCara Mengonversi String menjadi Double di VBA (dengan Contoh) - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengubah string menjadi double di 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-ganda\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mengonversi String menjadi Double di VBA (dengan Contoh) - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengubah string menjadi double di VBA, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-mengonversi-string-menjadi-ganda\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-11T11:52:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vcon3.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=\"1 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-ganda\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-mengonversi-string-menjadi-ganda\/\",\"name\":\"Cara Mengonversi String menjadi Double di VBA (dengan Contoh) - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-11T11:52:06+00:00\",\"dateModified\":\"2023-07-11T11:52:06+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengubah string menjadi double di VBA, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-mengonversi-string-menjadi-ganda\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-mengonversi-string-menjadi-ganda\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-mengonversi-string-menjadi-ganda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengonversi string menjadi double 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 menjadi Double di VBA (dengan Contoh) - Statorial","description":"Tutorial ini menjelaskan cara mengubah string menjadi double di 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-ganda\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mengonversi String menjadi Double di VBA (dengan Contoh) - Statorial","og_description":"Tutorial ini menjelaskan cara mengubah string menjadi double di VBA, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/vba-mengonversi-string-menjadi-ganda\/","og_site_name":"Statorials","article_published_time":"2023-07-11T11:52:06+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vcon3.jpg"}],"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\/vba-mengonversi-string-menjadi-ganda\/","url":"https:\/\/statorials.org\/id\/vba-mengonversi-string-menjadi-ganda\/","name":"Cara Mengonversi String menjadi Double di VBA (dengan Contoh) - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-11T11:52:06+00:00","dateModified":"2023-07-11T11:52:06+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengubah string menjadi double di VBA, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-mengonversi-string-menjadi-ganda\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-mengonversi-string-menjadi-ganda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-mengonversi-string-menjadi-ganda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengonversi string menjadi double 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\/4389"}],"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=4389"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4389\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4389"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4389"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4389"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}