Hai Edo,Coba cek apakah di VBE Sheet nya Macronya ditempatkan pada Sheet yang
mau divalidasi ?Jika ditempatkan di Thisworkbook atau Module tentu tidak akan
jalan.
Salam,HK
From: "[email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
Sent: Wednesday, 11 May 2016, 0:13
Subject: [belajar-excel] vba untuk validasi
Dear Master,
Saya ingin membuat validasi dengan memakai vba untuk memvalidasi setiap isian
di range C3:C6 dimana jika setiap value dari sel tersebut tidak sama dengan
valu di sel C2, maka akan muncul MsgBox.
Saya mencoba untuk membuat kodenya tetapi masih belum berhasil. Mohon bantuan
untuk bisa mengkoreksi kode yg saya buat.
Private Sub Worksheet_Change(ByVal Target As Range)
b = Range("C2").Value
For Each aa In Range("C3:C6")
If aa.Value <> b Then
MsgBox "salah"
End If
Next aa
End Sub
Terima kasih
Edo
#yiv4197943209 #yiv4197943209 -- #yiv4197943209ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4197943209
#yiv4197943209ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4197943209
#yiv4197943209ygrp-mkp #yiv4197943209hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4197943209 #yiv4197943209ygrp-mkp #yiv4197943209ads
{margin-bottom:10px;}#yiv4197943209 #yiv4197943209ygrp-mkp .yiv4197943209ad
{padding:0 0;}#yiv4197943209 #yiv4197943209ygrp-mkp .yiv4197943209ad p
{margin:0;}#yiv4197943209 #yiv4197943209ygrp-mkp .yiv4197943209ad a
{color:#0000ff;text-decoration:none;}#yiv4197943209 #yiv4197943209ygrp-sponsor
#yiv4197943209ygrp-lc {font-family:Arial;}#yiv4197943209
#yiv4197943209ygrp-sponsor #yiv4197943209ygrp-lc #yiv4197943209hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4197943209
#yiv4197943209ygrp-sponsor #yiv4197943209ygrp-lc .yiv4197943209ad
{margin-bottom:10px;padding:0 0;}#yiv4197943209 #yiv4197943209actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4197943209
#yiv4197943209activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4197943209
#yiv4197943209activity span {font-weight:700;}#yiv4197943209
#yiv4197943209activity span:first-child
{text-transform:uppercase;}#yiv4197943209 #yiv4197943209activity span a
{color:#5085b6;text-decoration:none;}#yiv4197943209 #yiv4197943209activity span
span {color:#ff7900;}#yiv4197943209 #yiv4197943209activity span
.yiv4197943209underline {text-decoration:underline;}#yiv4197943209
.yiv4197943209attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4197943209 .yiv4197943209attach div a
{text-decoration:none;}#yiv4197943209 .yiv4197943209attach img
{border:none;padding-right:5px;}#yiv4197943209 .yiv4197943209attach label
{display:block;margin-bottom:5px;}#yiv4197943209 .yiv4197943209attach label a
{text-decoration:none;}#yiv4197943209 blockquote {margin:0 0 0
4px;}#yiv4197943209 .yiv4197943209bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4197943209
.yiv4197943209bold a {text-decoration:none;}#yiv4197943209 dd.yiv4197943209last
p a {font-family:Verdana;font-weight:700;}#yiv4197943209 dd.yiv4197943209last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4197943209
dd.yiv4197943209last p span.yiv4197943209yshortcuts
{margin-right:0;}#yiv4197943209 div.yiv4197943209attach-table div div a
{text-decoration:none;}#yiv4197943209 div.yiv4197943209attach-table
{width:400px;}#yiv4197943209 div.yiv4197943209file-title a, #yiv4197943209
div.yiv4197943209file-title a:active, #yiv4197943209
div.yiv4197943209file-title a:hover, #yiv4197943209 div.yiv4197943209file-title
a:visited {text-decoration:none;}#yiv4197943209 div.yiv4197943209photo-title a,
#yiv4197943209 div.yiv4197943209photo-title a:active, #yiv4197943209
div.yiv4197943209photo-title a:hover, #yiv4197943209
div.yiv4197943209photo-title a:visited {text-decoration:none;}#yiv4197943209
div#yiv4197943209ygrp-mlmsg #yiv4197943209ygrp-msg p a
span.yiv4197943209yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4197943209
.yiv4197943209green {color:#628c2a;}#yiv4197943209 .yiv4197943209MsoNormal
{margin:0 0 0 0;}#yiv4197943209 o {font-size:0;}#yiv4197943209
#yiv4197943209photos div {float:left;width:72px;}#yiv4197943209
#yiv4197943209photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv4197943209
#yiv4197943209photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4197943209
#yiv4197943209reco-category {font-size:77%;}#yiv4197943209
#yiv4197943209reco-desc {font-size:77%;}#yiv4197943209 .yiv4197943209replbq
{margin:4px;}#yiv4197943209 #yiv4197943209ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4197943209 #yiv4197943209ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4197943209
#yiv4197943209ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4197943209
#yiv4197943209ygrp-mlmsg select, #yiv4197943209 input, #yiv4197943209 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4197943209
#yiv4197943209ygrp-mlmsg pre, #yiv4197943209 code {font:115%
monospace;}#yiv4197943209 #yiv4197943209ygrp-mlmsg *
{line-height:1.22em;}#yiv4197943209 #yiv4197943209ygrp-mlmsg #yiv4197943209logo
{padding-bottom:10px;}#yiv4197943209 #yiv4197943209ygrp-msg p a
{font-family:Verdana;}#yiv4197943209 #yiv4197943209ygrp-msg
p#yiv4197943209attach-count span {color:#1E66AE;font-weight:700;}#yiv4197943209
#yiv4197943209ygrp-reco #yiv4197943209reco-head
{color:#ff7900;font-weight:700;}#yiv4197943209 #yiv4197943209ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4197943209 #yiv4197943209ygrp-sponsor
#yiv4197943209ov li a {font-size:130%;text-decoration:none;}#yiv4197943209
#yiv4197943209ygrp-sponsor #yiv4197943209ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4197943209
#yiv4197943209ygrp-sponsor #yiv4197943209ov ul {margin:0;padding:0 0 0
8px;}#yiv4197943209 #yiv4197943209ygrp-text
{font-family:Georgia;}#yiv4197943209 #yiv4197943209ygrp-text p {margin:0 0 1em
0;}#yiv4197943209 #yiv4197943209ygrp-text tt {font-size:120%;}#yiv4197943209
#yiv4197943209ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4197943209
