{"id":4908,"date":"2023-07-06T13:31:23","date_gmt":"2023-07-06T13:31:23","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-membaca-nilai-sel-menjadi-variabel\/"},"modified":"2023-07-06T13:31:23","modified_gmt":"2023-07-06T13:31:23","slug":"vba-membaca-nilai-sel-menjadi-variabel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-membaca-nilai-sel-menjadi-variabel\/","title":{"rendered":"Vba: cara membaca nilai sel dalam suatu variabel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut di VBA untuk membaca nilai sel ke dalam variabel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> ReadCellValueIntoVar()\n\n<span style=\"color: #0000ff;\">Dim<\/span> CellVal <span style=\"color: #0000ff;\">As<\/span> String\nCellVal = Range(\" <span style=\"color: #ff0000;\">A1<\/span> \")\n\nMsgBox CellVal\n\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Makro khusus ini membuat variabel string yang disebut <strong>CellVal<\/strong> dan kemudian membaca nilai sel <strong>A1<\/strong> dari lembar yang sedang aktif ke dalam variabel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, kami menggunakan <strong>MsgBox<\/strong> untuk menampilkan nilai variabel ini di kotak pesan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Cara membaca nilai sel pada suatu variabel di VBA<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki lembar Excel dengan nilai 500 di sel <strong>A1<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38324 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rcekk1.png\" alt=\"\" width=\"438\" height=\"393\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita bisa membuat makro berikut untuk membaca nilai sel ini menjadi variabel dan kemudian menampilkan nilainya di kotak pesan:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> ReadCellValueIntoVar()\n\n<span style=\"color: #0000ff;\">Dim<\/span> CellVal <span style=\"color: #0000ff;\">As<\/span> String\nCellVal = Range(\" <span style=\"color: #ff0000;\">A1<\/span> \")\n\nMsgBox CellVal\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-38325 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rcekk2.png\" alt=\"\" width=\"463\" height=\"407\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Makro menampilkan nilai variabel, yang berisi nilai 500 dari sel <strong>A1<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kita juga dapat melakukan penghitungan yang lebih kompleks menggunakan variabel jika kita mau.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita bisa membuat makro berikut untuk membaca nilai sel <strong>A1<\/strong> menjadi variabel, lalu membuat kotak pesan yang menampilkan nilai tersebut dikalikan 5:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> ReadCellValueIntoVar()\n\n<span style=\"color: #0000ff;\">Dim<\/span> CellVal <span style=\"color: #0000ff;\">As<\/span> String\nCellVal = Range(\" <span style=\"color: #ff0000;\">A1<\/span> \")\n\nMsgBox CellVal * 5\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-38326 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rcekk3.png\" alt=\"\" width=\"428\" height=\"370\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Makro menampilkan nilai variabel dikalikan 5, yang hasilnya adalah 500 * 5 = <strong>2500<\/strong> .<\/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 operasi umum lainnya di VBA:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/vba-mengatur-nilai-sel-di-lembar-lain\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara mengatur nilai sel di lembar lain<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-mendapatkan-nilai-sel-dari-lembar-lain\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara mendapatkan nilai sel dari sheet lain<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-pilih-rentang-dari-sel-aktif\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara memilih rentang di sel aktif<\/a><br \/><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut di VBA untuk membaca nilai sel ke dalam variabel: Sub ReadCellValueIntoVar() Dim CellVal As String CellVal = Range(&#8221; A1 &#8220;) MsgBox CellVal End Sub Makro khusus ini membuat variabel string yang disebut CellVal dan kemudian membaca nilai sel A1 dari lembar yang sedang aktif ke dalam variabel. Terakhir, kami menggunakan [&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>VBA: Cara membaca nilai sel dalam variabel - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membaca nilai sel menjadi variabel di VBA, dengan sebuah 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-membaca-nilai-sel-menjadi-variabel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara membaca nilai sel dalam variabel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membaca nilai sel menjadi variabel di VBA, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-membaca-nilai-sel-menjadi-variabel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-06T13:31:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rcekk1.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\/vba-membaca-nilai-sel-menjadi-variabel\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-membaca-nilai-sel-menjadi-variabel\/\",\"name\":\"VBA: Cara membaca nilai sel dalam variabel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-06T13:31:23+00:00\",\"dateModified\":\"2023-07-06T13:31:23+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membaca nilai sel menjadi variabel di VBA, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-membaca-nilai-sel-menjadi-variabel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-membaca-nilai-sel-menjadi-variabel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-membaca-nilai-sel-menjadi-variabel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara membaca nilai sel dalam suatu variabel\"}]},{\"@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":"VBA: Cara membaca nilai sel dalam variabel - Statorials","description":"Tutorial ini menjelaskan cara membaca nilai sel menjadi variabel di VBA, dengan sebuah 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-membaca-nilai-sel-menjadi-variabel\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara membaca nilai sel dalam variabel - Statorials","og_description":"Tutorial ini menjelaskan cara membaca nilai sel menjadi variabel di VBA, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/vba-membaca-nilai-sel-menjadi-variabel\/","og_site_name":"Statorials","article_published_time":"2023-07-06T13:31:23+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rcekk1.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\/vba-membaca-nilai-sel-menjadi-variabel\/","url":"https:\/\/statorials.org\/id\/vba-membaca-nilai-sel-menjadi-variabel\/","name":"VBA: Cara membaca nilai sel dalam variabel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-06T13:31:23+00:00","dateModified":"2023-07-06T13:31:23+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membaca nilai sel menjadi variabel di VBA, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-membaca-nilai-sel-menjadi-variabel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-membaca-nilai-sel-menjadi-variabel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-membaca-nilai-sel-menjadi-variabel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara membaca nilai sel dalam suatu variabel"}]},{"@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\/4908"}],"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=4908"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4908\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4908"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4908"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4908"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}