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