{"id":4455,"date":"2023-07-10T23:43:20","date_gmt":"2023-07-10T23:43:20","guid":{"rendered":"https:\/\/statorials.org\/id\/kotak-pesan-vba-ya-tidak\/"},"modified":"2023-07-10T23:43:20","modified_gmt":"2023-07-10T23:43:20","slug":"kotak-pesan-vba-ya-tidak","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kotak-pesan-vba-ya-tidak\/","title":{"rendered":"Vba: cara membuat kotak pesan dengan jawaban ya\/tidak"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut di VBA untuk membuat kotak pesan bagi pengguna untuk memilih Ya atau Tidak:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #0000ff;\">Sub<\/span> MsgBoxYesNo()\n\n    <span style=\"color: #008000;\">'ask user if they want to multiply two cells<\/span>\n    UserResponse = MsgBox(\" <span style=\"color: #ff0000;\">Do you want to multiply cells A1 and B1?<\/span> \", vbYesNo)\n\n    <span style=\"color: #008000;\">'perform action based on user response<\/span>\n    <span style=\"color: #0000ff;\">If<\/span> UserResponse = vbYes <span style=\"color: #0000ff;\">Then<\/span>\n      Range(\" <span style=\"color: #ff0000;\">C1<\/span> \") = Range(\" <span style=\"color: #ff0000;\">A1<\/span> \") * Range(\" <span style=\"color: #ff0000;\">B1<\/span> \")\n    <span style=\"color: #0000ff;\">Else<\/span>\n      MsgBox \u201c <span style=\"color: #ff0000;\">No Multiplication was Performed<\/span> \u201d\n   <span style=\"color: #0000ff;\">End If<\/span>\n\n<span style=\"color: #0000ff;\">End Sub\n<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Makro khusus ini membuat kotak pesan yang menanyakan pengguna apakah mereka ingin mengalikan sel A1 dan B1.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika pengguna mengklik &#8220;Ya&#8221;, kedua sel dikalikan dan hasilnya ditampilkan di sel C1.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika pengguna mengklik &#8220;Tidak&#8221;, kotak pesan baru akan muncul memberitahukan bahwa tidak ada perkalian yang dilakukan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa pernyataan <strong>vbYesNo<\/strong> adalah yang menyisipkan tombol &#8220;Ya&#8221; dan &#8220;Tidak&#8221; untuk diklik pengguna.<\/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: Buat kotak pesan dengan jawaban Ya\/Tidak<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki dua nilai berikut di sel A1 dan B1 pada lembar Excel kita:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34885 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ouinon1.png\" alt=\"\" width=\"441\" height=\"408\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin membuat makro yang menampilkan kotak pesan kepada pengguna dan menanyakan apakah mereka ingin mengalikan nilai di sel A1 dan B1 atau tidak.<\/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> MsgBoxYesNo()\n\n    <span style=\"color: #008000;\">'ask user if they want to multiply two cells<\/span>\n    UserResponse = MsgBox(\" <span style=\"color: #ff0000;\">Do you want to multiply cells A1 and B1?<\/span> \", vbYesNo)\n\n    <span style=\"color: #008000;\">'perform action based on user response<\/span>\n    <span style=\"color: #0000ff;\">If<\/span> UserResponse = vbYes <span style=\"color: #0000ff;\">Then<\/span>\n      Range(\" <span style=\"color: #ff0000;\">C1<\/span> \") = Range(\" <span style=\"color: #ff0000;\">A1<\/span> \") * Range(\" <span style=\"color: #ff0000;\">B1<\/span> \")\n    <span style=\"color: #0000ff;\">Else<\/span>\n      MsgBox \u201c <span style=\"color: #ff0000;\">No Multiplication was Performed<\/span> \u201d\n   <span style=\"color: #0000ff;\">End If<\/span>\n\n<span style=\"color: #0000ff;\">End Sub<\/span><\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Saat kita menjalankan makro ini, kotak pesan berikut muncul:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-34886\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ouinon2.png\" alt=\"Kotak pesan VBA ya atau tidak\" width=\"518\" height=\"427\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jika kita klik <strong>Yes<\/strong> , maka makro akan mengalikan nilai di sel A1 dan B2 dan menampilkan hasilnya di sel C1:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34887 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ouinon3.png\" alt=\"\" width=\"433\" height=\"395\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Namun jika kita klik <strong>No<\/strong> , maka akan muncul kotak pesan baru:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-34888 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ouinon4.png\" alt=\"\" width=\"508\" height=\"452\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kotak pesan memberitahu kita bahwa tidak ada perkalian yang dilakukan sejak kita mengklik <strong>Tidak<\/strong> di kotak pesan sebelumnya.<\/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\/baris-baru-kotak-pesan-vba\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara menambahkan baris baru ke kotak pesan<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/vba-menambahkan-lembar\/\" target=\"_blank\" rel=\"noopener\">VBA: Bagaimana cara menambahkan sheet baru<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panel-beku-vba\/\" target=\"_blank\" rel=\"noopener\">VBA: Cara membekukan panel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut di VBA untuk membuat kotak pesan bagi pengguna untuk memilih Ya atau Tidak: Sub MsgBoxYesNo() &#8216;ask user if they want to multiply two cells UserResponse = MsgBox(&#8221; Do you want to multiply cells A1 and B1? &#8220;, vbYesNo) &#8216;perform action based on user response If UserResponse = vbYes Then Range(&#8221; [&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 membuat kotak pesan dengan jawaban ya\/tidak - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat kotak pesan di VBA termasuk opsi respon Ya\/Tidak, 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\/kotak-pesan-vba-ya-tidak\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA: Cara membuat kotak pesan dengan jawaban ya\/tidak - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat kotak pesan di VBA termasuk opsi respon Ya\/Tidak, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kotak-pesan-vba-ya-tidak\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-10T23:43:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ouinon1.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\/kotak-pesan-vba-ya-tidak\/\",\"url\":\"https:\/\/statorials.org\/id\/kotak-pesan-vba-ya-tidak\/\",\"name\":\"VBA: Cara membuat kotak pesan dengan jawaban ya\/tidak - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-10T23:43:20+00:00\",\"dateModified\":\"2023-07-10T23:43:20+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat kotak pesan di VBA termasuk opsi respon Ya\/Tidak, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kotak-pesan-vba-ya-tidak\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kotak-pesan-vba-ya-tidak\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kotak-pesan-vba-ya-tidak\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vba: cara membuat kotak pesan dengan jawaban ya\/tidak\"}]},{\"@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 membuat kotak pesan dengan jawaban ya\/tidak - Statologi","description":"Tutorial ini menjelaskan cara membuat kotak pesan di VBA termasuk opsi respon Ya\/Tidak, 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\/kotak-pesan-vba-ya-tidak\/","og_locale":"id_ID","og_type":"article","og_title":"VBA: Cara membuat kotak pesan dengan jawaban ya\/tidak - Statologi","og_description":"Tutorial ini menjelaskan cara membuat kotak pesan di VBA termasuk opsi respon Ya\/Tidak, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/kotak-pesan-vba-ya-tidak\/","og_site_name":"Statorials","article_published_time":"2023-07-10T23:43:20+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ouinon1.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\/kotak-pesan-vba-ya-tidak\/","url":"https:\/\/statorials.org\/id\/kotak-pesan-vba-ya-tidak\/","name":"VBA: Cara membuat kotak pesan dengan jawaban ya\/tidak - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-10T23:43:20+00:00","dateModified":"2023-07-10T23:43:20+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat kotak pesan di VBA termasuk opsi respon Ya\/Tidak, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kotak-pesan-vba-ya-tidak\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kotak-pesan-vba-ya-tidak\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kotak-pesan-vba-ya-tidak\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Vba: cara membuat kotak pesan dengan jawaban ya\/tidak"}]},{"@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\/4455"}],"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=4455"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4455\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4455"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4455"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4455"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}