Dear All,
Terima kasih atas segala masukannya. Saya mendapat masukan bahwa untuk data
validation lebih baik di lakukan dengan menggunakan rumus daripada menggunakan
VBA karena lebih praktis. Menurut para master apakah memang data validation ini
lebih baik menggunakan rumus atau dengan VBA?
Terima Kasih
Edo
On Wednesday, May 11, 2016 9:51 AM, "nangagus [email protected]
[belajar-excel]" <[email protected]> wrote:
Dear Edo;
agar macro dapat ikut disimpan maka file excel harus disimpan dalam .xlsm atau
.xlsb
file yang anda sertakan dalam xlsx sehingga macronya mati.
coba tambahkan beberapa cekrip:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim b As String
Dim aa As Range
b = Range("C2").Value
If Not Intersect(Target, Range("c3:c6")) Is Nothing Then
For Each aa In Range("C3:C6")
If aa.Value <> b Then
MsgBox "salah"
End If
Next aa
Else
End If
End Sub
sebaiknya begini:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim b As String
b = Range("C2").Value
If Target.Address = "$c$3" Then
If Range("C3").Value <> b Then
MsgBox "Pengisian C3 salah"
End If
Else
End If
If Target.Address = "$c$4" Then
If Range("C4").Value <> b Then
MsgBox "Pengisian C4 salah"
End If
Else
End IF
End Sub
sebenarnya juga bisa disingkat kok silahkan dicoba dahulu
On 11/05/2016 0:13, [email protected] [belajar-excel] wrote:
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
#yiv1011036859 #yiv1011036859 -- #yiv1011036859ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1011036859
#yiv1011036859ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1011036859
#yiv1011036859ygrp-mkp #yiv1011036859hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv1011036859 #yiv1011036859ygrp-mkp #yiv1011036859ads
{margin-bottom:10px;}#yiv1011036859 #yiv1011036859ygrp-mkp .yiv1011036859ad
{padding:0 0;}#yiv1011036859 #yiv1011036859ygrp-mkp .yiv1011036859ad p
{margin:0;}#yiv1011036859 #yiv1011036859ygrp-mkp .yiv1011036859ad a
{color:#0000ff;text-decoration:none;}#yiv1011036859 #yiv1011036859ygrp-sponsor
#yiv1011036859ygrp-lc {font-family:Arial;}#yiv1011036859
#yiv1011036859ygrp-sponsor #yiv1011036859ygrp-lc #yiv1011036859hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1011036859
#yiv1011036859ygrp-sponsor #yiv1011036859ygrp-lc .yiv1011036859ad
{margin-bottom:10px;padding:0 0;}#yiv1011036859 #yiv1011036859actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1011036859
#yiv1011036859activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1011036859
#yiv1011036859activity span {font-weight:700;}#yiv1011036859
#yiv1011036859activity span:first-child
{text-transform:uppercase;}#yiv1011036859 #yiv1011036859activity span a
{color:#5085b6;text-decoration:none;}#yiv1011036859 #yiv1011036859activity span
span {color:#ff7900;}#yiv1011036859 #yiv1011036859activity span
.yiv1011036859underline {text-decoration:underline;}#yiv1011036859
.yiv1011036859attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv1011036859 .yiv1011036859attach div a
{text-decoration:none;}#yiv1011036859 .yiv1011036859attach img
{border:none;padding-right:5px;}#yiv1011036859 .yiv1011036859attach label
{display:block;margin-bottom:5px;}#yiv1011036859 .yiv1011036859attach label a
{text-decoration:none;}#yiv1011036859 blockquote {margin:0 0 0
4px;}#yiv1011036859 .yiv1011036859bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1011036859
.yiv1011036859bold a {text-decoration:none;}#yiv1011036859 dd.yiv1011036859last
p a {font-family:Verdana;font-weight:700;}#yiv1011036859 dd.yiv1011036859last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1011036859
dd.yiv1011036859last p span.yiv1011036859yshortcuts
{margin-right:0;}#yiv1011036859 div.yiv1011036859attach-table div div a
{text-decoration:none;}#yiv1011036859 div.yiv1011036859attach-table
{width:400px;}#yiv1011036859 div.yiv1011036859file-title a, #yiv1011036859
div.yiv1011036859file-title a:active, #yiv1011036859
div.yiv1011036859file-title a:hover, #yiv1011036859 div.yiv1011036859file-title
a:visited {text-decoration:none;}#yiv1011036859 div.yiv1011036859photo-title a,
#yiv1011036859 div.yiv1011036859photo-title a:active, #yiv1011036859
div.yiv1011036859photo-title a:hover, #yiv1011036859
div.yiv1011036859photo-title a:visited {text-decoration:none;}#yiv1011036859
div#yiv1011036859ygrp-mlmsg #yiv1011036859ygrp-msg p a
span.yiv1011036859yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1011036859
.yiv1011036859green {color:#628c2a;}#yiv1011036859 .yiv1011036859MsoNormal
{margin:0 0 0 0;}#yiv1011036859 o {font-size:0;}#yiv1011036859
#yiv1011036859photos div {float:left;width:72px;}#yiv1011036859
#yiv1011036859photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv1011036859
#yiv1011036859photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1011036859
#yiv1011036859reco-category {font-size:77%;}#yiv1011036859
#yiv1011036859reco-desc {font-size:77%;}#yiv1011036859 .yiv1011036859replbq
{margin:4px;}#yiv1011036859 #yiv1011036859ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv1011036859 #yiv1011036859ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1011036859
#yiv1011036859ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1011036859
#yiv1011036859ygrp-mlmsg select, #yiv1011036859 input, #yiv1011036859 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1011036859
#yiv1011036859ygrp-mlmsg pre, #yiv1011036859 code {font:115%
monospace;}#yiv1011036859 #yiv1011036859ygrp-mlmsg *
{line-height:1.22em;}#yiv1011036859 #yiv1011036859ygrp-mlmsg #yiv1011036859logo
{padding-bottom:10px;}#yiv1011036859 #yiv1011036859ygrp-msg p a
{font-family:Verdana;}#yiv1011036859 #yiv1011036859ygrp-msg
p#yiv1011036859attach-count span {color:#1E66AE;font-weight:700;}#yiv1011036859
#yiv1011036859ygrp-reco #yiv1011036859reco-head
{color:#ff7900;font-weight:700;}#yiv1011036859 #yiv1011036859ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv1011036859 #yiv1011036859ygrp-sponsor
#yiv1011036859ov li a {font-size:130%;text-decoration:none;}#yiv1011036859
#yiv1011036859ygrp-sponsor #yiv1011036859ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv1011036859
#yiv1011036859ygrp-sponsor #yiv1011036859ov ul {margin:0;padding:0 0 0
8px;}#yiv1011036859 #yiv1011036859ygrp-text
{font-family:Georgia;}#yiv1011036859 #yiv1011036859ygrp-text p {margin:0 0 1em
0;}#yiv1011036859 #yiv1011036859ygrp-text tt {font-size:120%;}#yiv1011036859
#yiv1011036859ygrp-vital ul li:last-child {border-right:none
!important;}#yiv1011036859
