Assalamu'alaikum Mr Kid...
Boleh ya saya bertanya lagi melanjutkan kasus yang sama,
Kasusnyaberkembang, untuk Item COQ dan Tes Blending telah berhasil,namun selain 
itu hasilnya mengikuti Tes Blending. Bagaimanakah caranya agarcheckBox sesuai 
dengan masing2 Data? Terima Kasih
File Terlampir
SalamHaris 


     On Thursday, October 16, 2014 5:09 PM, "'Mr. Kid' [email protected] 
[belajar-excel]" <[email protected]> wrote:
   

     Wa'alaikumussalam Wr. Wb.

Mungkin sebelum baris script berbunyi :
      baris = C.Row
diberi blok script berikut :
c.parent.activate
CariProduk = "=countif(" & c.resize(1,7).address & ",""s%"")<>0"   'asumsi 
tabel data ada 7 kolom
'misal checkbox bernama chk1 sampai chk6 yang caption-nya sama dengan isi cells
chk1.value=evaluate( replace( cariproduk,"s%",chk1.caption ) )
chk2.value=evaluate( replace( cariproduk,"s%",chk2.caption ) )
chk3.value=evaluate( replace( cariproduk,"s%",chk3.caption ) )
chk4.value=evaluate( replace( cariproduk,"s%",chk4.caption ) )
chk5.value=evaluate( replace( cariproduk,"s%",chk5.caption ) )
chk6.value=evaluate( replace( cariproduk,"s%",chk6.caption ) )

Wassalamu'alaikum wr. wb.
Kid.



2014-10-16 17:33 GMT+11:00 ris ha [email protected] [belajar-excel] 
<[email protected]>:

     Assalamu'alaikum.
Salam sukses untuk para master semua.
Kali ini, saya mau bertanya terkait mencari data, kemudian data tersebut muncul 
pada CheckBox yang kita buat. Saya telah membuat pendarian data, yang 
ditampilkan pada TextBox dengan macro spt dibawah
Dim CariProduk As String
CariProduk = Me.NoKP.Value
If Trim(CariProduk) <> "" Then
       With Sheets("ItemCOQ").Range("A2:A1048576")
        Set C = .Find(CariProduk, LookIn:=xlValues)
                          
        If Not C Is Nothing Then
        Application.Goto C, True
        If C = "" Then
        Sheets("ItemCOQ").Range("A1").Select
        End If
        baris = C.Row
        Me.ProdukKP.Value = Worksheets("ItemCOQ").Cells(baris, 2).ValueElse
        Me.ProdukKP.Value = "Produk Tidak Ada"

Kemudian saya ingin memunculkan data pengetesan yang ditampilkan pada CheckBox 
sebagaimana gambar terlampir. Misal No urut 002 Item TestCheckBox Appearance 
tercentangCheckBox Colour ASTM tercentangCheckBox Density tercentangCheckBox 
Total Base Number tidak tercentangCheckBox Viscosity Kinematic 40 tidak 
tercentangCheckBox Viscosity Kinematic 100 tercentang
Mohon pencerahan pada para master excel semua. Terima kasih
Salam Haris





   

  #yiv1478522311 #yiv1478522311 -- #yiv1478522311ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1478522311 
#yiv1478522311ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1478522311 
#yiv1478522311ygrp-mkp #yiv1478522311hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv1478522311 #yiv1478522311ygrp-mkp #yiv1478522311ads 
{margin-bottom:10px;}#yiv1478522311 #yiv1478522311ygrp-mkp .yiv1478522311ad 
{padding:0 0;}#yiv1478522311 #yiv1478522311ygrp-mkp .yiv1478522311ad p 
{margin:0;}#yiv1478522311 #yiv1478522311ygrp-mkp .yiv1478522311ad a 
{color:#0000ff;text-decoration:none;}#yiv1478522311 #yiv1478522311ygrp-sponsor 
#yiv1478522311ygrp-lc {font-family:Arial;}#yiv1478522311 
#yiv1478522311ygrp-sponsor #yiv1478522311ygrp-lc #yiv1478522311hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1478522311 
#yiv1478522311ygrp-sponsor #yiv1478522311ygrp-lc .yiv1478522311ad 
{margin-bottom:10px;padding:0 0;}#yiv1478522311 #yiv1478522311actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1478522311 
#yiv1478522311activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1478522311
 #yiv1478522311activity span {font-weight:700;}#yiv1478522311 
#yiv1478522311activity span:first-child 
{text-transform:uppercase;}#yiv1478522311 #yiv1478522311activity span a 
{color:#5085b6;text-decoration:none;}#yiv1478522311 #yiv1478522311activity span 
span {color:#ff7900;}#yiv1478522311 #yiv1478522311activity span 
.yiv1478522311underline {text-decoration:underline;}#yiv1478522311 
.yiv1478522311attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv1478522311 .yiv1478522311attach div a 
{text-decoration:none;}#yiv1478522311 .yiv1478522311attach img 
{border:none;padding-right:5px;}#yiv1478522311 .yiv1478522311attach label 
{display:block;margin-bottom:5px;}#yiv1478522311 .yiv1478522311attach label a 
{text-decoration:none;}#yiv1478522311 blockquote {margin:0 0 0 
4px;}#yiv1478522311 .yiv1478522311bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1478522311 
.yiv1478522311bold a {text-decoration:none;}#yiv1478522311 dd.yiv1478522311last 
p a {font-family:Verdana;font-weight:700;}#yiv1478522311 dd.yiv1478522311last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1478522311 
dd.yiv1478522311last p span.yiv1478522311yshortcuts 
{margin-right:0;}#yiv1478522311 div.yiv1478522311attach-table div div a 
{text-decoration:none;}#yiv1478522311 div.yiv1478522311attach-table 
{width:400px;}#yiv1478522311 div.yiv1478522311file-title a, #yiv1478522311 
div.yiv1478522311file-title a:active, #yiv1478522311 
div.yiv1478522311file-title a:hover, #yiv1478522311 div.yiv1478522311file-title 
a:visited {text-decoration:none;}#yiv1478522311 div.yiv1478522311photo-title a, 
#yiv1478522311 div.yiv1478522311photo-title a:active, #yiv1478522311 
div.yiv1478522311photo-title a:hover, #yiv1478522311 
div.yiv1478522311photo-title a:visited {text-decoration:none;}#yiv1478522311 
div#yiv1478522311ygrp-mlmsg #yiv1478522311ygrp-msg p a 
span.yiv1478522311yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1478522311 
.yiv1478522311green {color:#628c2a;}#yiv1478522311 .yiv1478522311MsoNormal 
{margin:0 0 0 0;}#yiv1478522311 o {font-size:0;}#yiv1478522311 
#yiv1478522311photos div {float:left;width:72px;}#yiv1478522311 
#yiv1478522311photos div div {border:1px solid 
#666666;height:62px;overflow:hidden;width:62px;}#yiv1478522311 
#yiv1478522311photos div label 
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1478522311
 #yiv1478522311reco-category {font-size:77%;}#yiv1478522311 
#yiv1478522311reco-desc {font-size:77%;}#yiv1478522311 .yiv1478522311replbq 
{margin:4px;}#yiv1478522311 #yiv1478522311ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv1478522311 #yiv1478522311ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1478522311 
#yiv1478522311ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1478522311 
#yiv1478522311ygrp-mlmsg select, #yiv1478522311 input, #yiv1478522311 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1478522311 
#yiv1478522311ygrp-mlmsg pre, #yiv1478522311 code {font:115% 
monospace;}#yiv1478522311 #yiv1478522311ygrp-mlmsg * 
{line-height:1.22em;}#yiv1478522311 #yiv1478522311ygrp-mlmsg #yiv1478522311logo 
{padding-bottom:10px;}#yiv1478522311 #yiv1478522311ygrp-msg p a 
{font-family:Verdana;}#yiv1478522311 #yiv1478522311ygrp-msg 
p#yiv1478522311attach-count span {color:#1E66AE;font-weight:700;}#yiv1478522311 
#yiv1478522311ygrp-reco #yiv1478522311reco-head 
{color:#ff7900;font-weight:700;}#yiv1478522311 #yiv1478522311ygrp-reco 
{margin-bottom:20px;padding:0px;}#yiv1478522311 #yiv1478522311ygrp-sponsor 
#yiv1478522311ov li a {font-size:130%;text-decoration:none;}#yiv1478522311 
#yiv1478522311ygrp-sponsor #yiv1478522311ov li 
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv1478522311 
#yiv1478522311ygrp-sponsor #yiv1478522311ov ul {margin:0;padding:0 0 0 
8px;}#yiv1478522311 #yiv1478522311ygrp-text 
{font-family:Georgia;}#yiv1478522311 #yiv1478522311ygrp-text p {margin:0 0 1em 
0;}#yiv1478522311 #yiv1478522311ygrp-text tt {font-size:120%;}#yiv1478522311 
#yiv1478522311ygrp-vital ul li:last-child {border-right:none 
!important;}#yiv1478522311 

  

Kirim email ke