Re: [belajar-excel] Tolong bantuannya... CheckBox yang berkaitan dengan ComboBox. [1 Attachment]

Mon, 18 Jan 2016 21:08:49 -0800 

Hai Danny,

Kenapa Menyerah....?
Biasanya kalo menyerah pasti ada kemungkinanannya:
1. Ekspetasi yang terlalu tinggi tanpa disertai kerja keras dan usaha
2. Malas untuk berlogika ria
3. Kurangnya pengetahuan pendukung dari apa yg anda buat


Ok, ini saya berikan file VBA sesuai dengan yang anda inginkan, jangan di lihat 
formulanya, tapi di pelajari sedikit demi sedikit, kalo cuma di lihat aja 
dijamin bakal pusing.....

TerimaKasih.




--------------------------------------------
Pada Sen, 18/1/16, Danny Prasetyo [email protected] [belajar-excel] 
<[email protected]> menulis:

 Judul: Re: [belajar-excel] Tolong bantuannya... CheckBox yang berkaitan dengan 
ComboBox. [1 Attachment]
 Kepada: [email protected]
 Tanggal: Senin, 18 Januari, 2016, 3:49 PM
 
 
  
 
 
 
   
 
 
     
       
       
       Ini saya
 tampilkan contoh datanya.Sudah
 nyerah saya -__-Tolong
 bantuannya yaa master master...
 Regards,
 Danny
 Prasetyo
 
 
     
      
 
     
     
 
 
 
 #yiv6955626489 #yiv6955626489 --
   #yiv6955626489ygrp-mkp {
 border:1px solid #d8d8d8;font-family:Arial;margin:10px
 0;padding:0 10px;}
 
 #yiv6955626489 #yiv6955626489ygrp-mkp hr {
 border:1px solid #d8d8d8;}
 
 #yiv6955626489 #yiv6955626489ygrp-mkp #yiv6955626489hd {
 color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
 0;}
 
 #yiv6955626489 #yiv6955626489ygrp-mkp #yiv6955626489ads {
 margin-bottom:10px;}
 
 #yiv6955626489 #yiv6955626489ygrp-mkp .yiv6955626489ad {
 padding:0 0;}
 
 #yiv6955626489 #yiv6955626489ygrp-mkp .yiv6955626489ad p {
 margin:0;}
 
 #yiv6955626489 #yiv6955626489ygrp-mkp .yiv6955626489ad a {
 color:#0000ff;text-decoration:none;}
 #yiv6955626489 #yiv6955626489ygrp-sponsor
 #yiv6955626489ygrp-lc {
 font-family:Arial;}
 
 #yiv6955626489 #yiv6955626489ygrp-sponsor
 #yiv6955626489ygrp-lc #yiv6955626489hd {
 margin:10px
 0px;font-weight:700;font-size:78%;line-height:122%;}
 
 #yiv6955626489 #yiv6955626489ygrp-sponsor
 #yiv6955626489ygrp-lc .yiv6955626489ad {
 margin-bottom:10px;padding:0 0;}
 
 #yiv6955626489 #yiv6955626489actions {
 font-family:Verdana;font-size:11px;padding:10px 0;}
 
 #yiv6955626489 #yiv6955626489activity {
 
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
 
 #yiv6955626489 #yiv6955626489activity span {
 font-weight:700;}
 
 #yiv6955626489 #yiv6955626489activity span:first-child {
 text-transform:uppercase;}
 
 #yiv6955626489 #yiv6955626489activity span a {
 color:#5085b6;text-decoration:none;}
 
 #yiv6955626489 #yiv6955626489activity span span {
 color:#ff7900;}
 
 #yiv6955626489 #yiv6955626489activity span
 .yiv6955626489underline {
 text-decoration:underline;}
 
 #yiv6955626489 .yiv6955626489attach {
 clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
 0;width:400px;}
 
 #yiv6955626489 .yiv6955626489attach div a {
 text-decoration:none;}
 
 #yiv6955626489 .yiv6955626489attach img {
 border:none;padding-right:5px;}
 
 #yiv6955626489 .yiv6955626489attach label {
 display:block;margin-bottom:5px;}
 
 #yiv6955626489 .yiv6955626489attach label a {
 text-decoration:none;}
 
 #yiv6955626489 blockquote {
 margin:0 0 0 4px;}
 
 #yiv6955626489 .yiv6955626489bold {
 font-family:Arial;font-size:13px;font-weight:700;}
 
 #yiv6955626489 .yiv6955626489bold a {
 text-decoration:none;}
 
 #yiv6955626489 dd.yiv6955626489last p a {
 font-family:Verdana;font-weight:700;}
 
 #yiv6955626489 dd.yiv6955626489last p span {
 margin-right:10px;font-family:Verdana;font-weight:700;}
 
 #yiv6955626489 dd.yiv6955626489last p
 span.yiv6955626489yshortcuts {
 margin-right:0;}
 
 #yiv6955626489 div.yiv6955626489attach-table div div a {
 text-decoration:none;}
 
 #yiv6955626489 div.yiv6955626489attach-table {
 width:400px;}
 
 #yiv6955626489 div.yiv6955626489file-title a, #yiv6955626489
 div.yiv6955626489file-title a:active, #yiv6955626489
 div.yiv6955626489file-title a:hover, #yiv6955626489
 div.yiv6955626489file-title a:visited {
 text-decoration:none;}
 
 #yiv6955626489 div.yiv6955626489photo-title a,
 #yiv6955626489 div.yiv6955626489photo-title a:active,
 #yiv6955626489 div.yiv6955626489photo-title a:hover,
 #yiv6955626489 div.yiv6955626489photo-title a:visited {
 text-decoration:none;}
 
 #yiv6955626489 div#yiv6955626489ygrp-mlmsg
 #yiv6955626489ygrp-msg p a span.yiv6955626489yshortcuts {
 font-family:Verdana;font-size:10px;font-weight:normal;}
 
 #yiv6955626489 .yiv6955626489green {
 color:#628c2a;}
 
 #yiv6955626489 .yiv6955626489MsoNormal {
 margin:0 0 0 0;}
 
 #yiv6955626489 o {
 font-size:0;}
 
 #yiv6955626489 #yiv6955626489photos div {
 float:left;width:72px;}
 
 #yiv6955626489 #yiv6955626489photos div div {
 border:1px solid
 #666666;height:62px;overflow:hidden;width:62px;}
 
 #yiv6955626489 #yiv6955626489photos div label {
 
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
 
 #yiv6955626489 #yiv6955626489reco-category {
 font-size:77%;}
 
 #yiv6955626489 #yiv6955626489reco-desc {
 font-size:77%;}
 
 #yiv6955626489 .yiv6955626489replbq {
 margin:4px;}
 
 #yiv6955626489 #yiv6955626489ygrp-actbar div a:first-child {
 margin-right:2px;padding-right:5px;}
 
 #yiv6955626489 #yiv6955626489ygrp-mlmsg {
 font-size:13px;font-family:Arial, helvetica, clean,
 sans-serif;}
 
 #yiv6955626489 #yiv6955626489ygrp-mlmsg table {
 font-size:inherit;font:100%;}
 
 #yiv6955626489 #yiv6955626489ygrp-mlmsg select,
 #yiv6955626489 input, #yiv6955626489 textarea {
 font:99% Arial, Helvetica, clean, sans-serif;}
 
 #yiv6955626489 #yiv6955626489ygrp-mlmsg pre, #yiv6955626489
 code {
 font:115% monospace;}
 
 #yiv6955626489 #yiv6955626489ygrp-mlmsg * {
 line-height:1.22em;}
 
 #yiv6955626489 #yiv6955626489ygrp-mlmsg #yiv6955626489logo {
 padding-bottom:10px;}
 
 
 #yiv6955626489 #yiv6955626489ygrp-msg p a {
 font-family:Verdana;}
 
 #yiv6955626489 #yiv6955626489ygrp-msg
 p#yiv6955626489attach-count span {
 color:#1E66AE;font-weight:700;}
 
 #yiv6955626489 #yiv6955626489ygrp-reco
 #yiv6955626489reco-head {
 color:#ff7900;font-weight:700;}
 
 #yiv6955626489 #yiv6955626489ygrp-reco {
 margin-bottom:20px;padding:0px;}
 
 #yiv6955626489 #yiv6955626489ygrp-sponsor #yiv6955626489ov
 li a {
 font-size:130%;text-decoration:none;}
 
 #yiv6955626489 #yiv6955626489ygrp-sponsor #yiv6955626489ov
 li {
 font-size:77%;list-style-type:square;padding:6px 0;}
 
 #yiv6955626489 #yiv6955626489ygrp-sponsor #yiv6955626489ov
 ul {
 margin:0;padding:0 0 0 8px;}
 
 #yiv6955626489 #yiv6955626489ygrp-text {
 font-family:Georgia;}
 
 #yiv6955626489 #yiv6955626489ygrp-text p {
 margin:0 0 1em 0;}
 
 #yiv6955626489 #yiv6955626489ygrp-text tt {
 font-size:120%;}
 
 #yiv6955626489 #yiv6955626489ygrp-vital ul li:last-child {
 border-right:none !important;
 }
 #yiv6955626489

Attachment: Testing ver.003_toby.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Kirim email ke