{"id":4514,"date":"2023-07-10T11:56:39","date_gmt":"2023-07-10T11:56:39","guid":{"rendered":"https:\/\/statorials.org\/id\/vba-menjalankan-makro-ketika-nilai-sel-berubah\/"},"modified":"2023-07-10T11:56:39","modified_gmt":"2023-07-10T11:56:39","slug":"vba-menjalankan-makro-ketika-nilai-sel-berubah","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/vba-menjalankan-makro-ketika-nilai-sel-berubah\/","title":{"rendered":"Vba: cara menjalankan makro ketika nilai sel berubah"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks berikut di VBA untuk menjalankan makro ketika nilai sel tertentu berubah:<\/span><\/p>\n

 Sub<\/span> Worksheet_Change(ByVal Target As Range)\n    If<\/span> Target.Address = \" $A$1<\/span> \" Then<\/span>\n        Call<\/span> MultiplyMacro\n    End If<\/span>\nEnd Sub\n<\/span><\/strong><\/span><\/pre>\n
 Contoh khusus ini akan menyebabkan makro bernama MultiplyMacro<\/strong> dijalankan ketika nilai sel A1<\/strong> berubah.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Jalankan makro ketika nilai sel berubah menggunakan VBA<\/strong><\/span><\/h2>\n
 Misalkan kita membuat makro berikut bernama MultiplyMacro<\/strong> yang mengalikan nilai di sel A1<\/strong> dan B1<\/strong> dan menampilkan hasilnya di sel C1<\/strong> :<\/span><\/p>\n
 SubMultiplyMacro<\/span> ()\n    Range(\" C1<\/span> \") = Range(\" A1<\/span> \") * Range(\" B1<\/span> \")\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Misalnya, kita memiliki nilai 12<\/strong> di sel A1<\/strong> dan nilai 3<\/strong> di sel B1<\/strong> .<\/span><\/p>\n
 Jika kita menjalankan makro ini, kita akan menerima hasil sebagai berikut:<\/span> <\/p>\n
\"\"<\/p>\n
 Sekarang misalkan kita ingin menjalankan makro ini secara otomatis setiap kali nilai sel A1<\/strong> berubah.<\/span><\/p>\n
 Untuk melakukan ini, kita dapat mengklik kanan pada nama sheet dan kemudian klik Show Code<\/strong> :<\/span> <\/p>\n
\"\"<\/p>\n
 Di jendela pengeditan kode yang muncul, Anda dapat menempelkan kode berikut:<\/span><\/p>\n
 Sub<\/span> Worksheet_Change(ByVal Target As Range)\n    If<\/span> Target.Address = \" $A$1<\/span> \" Then<\/span>\n        Call<\/span> MultiplyMacro\n    End If<\/span>\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Tangkapan layar berikut menunjukkan cara melakukan hal ini dalam praktik:<\/span> <\/p>\n
\"\"<\/p>\n
 Kami kemudian dapat menutup editor VB.<\/span><\/p>\n
 Sekarang, setiap kali kita mengubah nilai di sel A1<\/strong> , makro bernama MultiplyMacro<\/strong> akan otomatis berjalan dan melakukan perkalian menggunakan nilai baru di sel A1<\/strong> .<\/span><\/p>\n
 Misalnya, kita mengubah nilai sel A1<\/strong> menjadi 10<\/strong> . Segera setelah kita mengubah nilainya dan menekan Enter<\/strong> , makro akan berjalan:<\/span> <\/p>\n
\"\"<\/p>\n
 Makro mengalikan 10 dengan 3 dan menampilkan hasilnya di sel C2<\/strong> .<\/span><\/p>\n
 Catatan<\/strong> : Jika Anda ingin menjalankan makro ketika sel dalam rentang tertentu berubah, Anda bisa menggunakan sintaks berikut:<\/span><\/p>\n
 Sub<\/span> Worksheet_Change(ByVal Target As Range)\n    If Not<\/span> Intersect(Target, Range(\" A1:B1<\/span> \")) Is Nothing Then<\/span>\n        Call<\/span> MultiplyMacro\n    End If<\/span>\nEnd Sub<\/span><\/strong><\/span><\/pre>\n
 Ini akan menyebabkan makro yang disebut MultiplyMacro<\/strong> berjalan jika ada sel dalam rentang A1:B1<\/strong> yang berubah.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di VBA:<\/span><\/p>\n
 VBA: Cara menghitung jumlah lembar dalam buku kerja<\/a>
 VBA: Cara mengekstrak data dari buku kerja lain
 VBA: Bagaimana cara menambahkan sheet baru<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks berikut di VBA untuk menjalankan makro ketika nilai sel tertentu berubah: Sub Worksheet_Change(ByVal Target As Range) If Target.Address = ” $A$1 ” Then Call MultiplyMacro End If End Sub Contoh khusus ini akan menyebabkan makro bernama MultiplyMacro dijalankan ketika nilai sel A1 berubah. Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam […]<\/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":"\nVBA: Cara menjalankan makro ketika nilai sel berubah \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menjalankan makro di VBA ketika nilai sel berubah, 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-menjalankan-makro-ketika-nilai-sel-berubah\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara menjalankan makro ketika nilai sel berubah \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menjalankan makro di VBA ketika nilai sel berubah, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/vba-menjalankan-makro-ketika-nilai-sel-berubah\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-10T11:56:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/appel1.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\/vba-menjalankan-makro-ketika-nilai-sel-berubah\/\",\"url\":\"https:\/\/statorials.org\/id\/vba-menjalankan-makro-ketika-nilai-sel-berubah\/\",\"name\":\"VBA: Cara menjalankan makro ketika nilai sel berubah \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-10T11:56:39+00:00\",\"dateModified\":\"2023-07-10T11:56:39+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menjalankan makro di VBA ketika nilai sel berubah, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/vba-menjalankan-makro-ketika-nilai-sel-berubah\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/vba-menjalankan-makro-ketika-nilai-sel-berubah\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/vba-menjalankan-makro-ketika-nilai-sel-berubah\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara menjalankan makro ketika nilai sel berubah\"}]},{\"@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 menjalankan makro ketika nilai sel berubah \u2013 Statorial","description":"Tutorial ini menjelaskan cara menjalankan makro di VBA ketika nilai sel berubah, 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-menjalankan-makro-ketika-nilai-sel-berubah\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara menjalankan makro ketika nilai sel berubah \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara menjalankan makro di VBA ketika nilai sel berubah, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/vba-menjalankan-makro-ketika-nilai-sel-berubah\/","og_site_name":"Statorials","article_published_time":"2023-07-10T11:56:39+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/appel1.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\/vba-menjalankan-makro-ketika-nilai-sel-berubah\/","url":"https:\/\/statorials.org\/id\/vba-menjalankan-makro-ketika-nilai-sel-berubah\/","name":"VBA: Cara menjalankan makro ketika nilai sel berubah \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-10T11:56:39+00:00","dateModified":"2023-07-10T11:56:39+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menjalankan makro di VBA ketika nilai sel berubah, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/vba-menjalankan-makro-ketika-nilai-sel-berubah\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/vba-menjalankan-makro-ketika-nilai-sel-berubah\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/vba-menjalankan-makro-ketika-nilai-sel-berubah\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara menjalankan makro ketika nilai sel berubah"}]},{"@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\/4514"}],"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=4514"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4514\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4514"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4514"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4514"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}