Dear Pa Hendrik, Terima kasih sebelumnya yaa atas responnya, Alhamdulillah berhasil, tapi yang saya ingin tanyakan, step by step buat user form sederhananya, soalnya saya masih awam dalam menggunakan tmenu conrol pada toolboxnya. Terima kasih
Pada Rabu, 27 Juli 2016 12:59, "hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis: Hai Kamirin,Saya coba jawab pake macro. Salam,HK From: "Kamirin Faqoth kamiri...@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> To: belajar-excel@yahoogroups.com Sent: Monday, 25 July 2016, 9:21 Subject: [belajar-excel] Trs: Step by step buat Form Message Box [1 Attachment] Maaf, koq email sy yang ini belum masuk2 yaa dari hari jumat, maaf saya reply kembali, semoga ada yang berkenan, menjelaskan ke sy step by stepnya. Thanks Pada Jumat, 22 Juli 2016 9:13, Kamirin Faqoth <kamiri...@yahoo.co.id> menulis: Dear Rekan-rekan B-Exceler Mohon penjelasannya, step by step buat Form Message Box dan didalam Form tersebut terdapat fungsi vlookup atau list validasi Misal: Saya punya 4 Sheet: 1. Sheet Database Cust 2. Sheet Input 3. Sheet Laporan Penjualan 4. Sheet Rekap saya ingin membuat aplikasi sederhana yang isi Formnya terdapat pada Sheet Input, apabila saya masukkan no ID menggunakan dropdownlist berdasarkan data di Sheet Cust, maka kolom Nama, Alamat dan telpon terisi otomatis, jadi saya hanya isi kolom Tgl, Permintaan, Pembelian dan harga barang, dan dari Form Tersebut seluruh data masuknya ke Sheet Laporan Penjualan. File Terlampir Terima kasih sebelumnya atas pencerahannya. #yiv2175804304 #yiv2175804304 -- #yiv2175804304ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2175804304 #yiv2175804304ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2175804304 #yiv2175804304ygrp-mkp #yiv2175804304hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2175804304 #yiv2175804304ygrp-mkp #yiv2175804304ads {margin-bottom:10px;}#yiv2175804304 #yiv2175804304ygrp-mkp .yiv2175804304ad {padding:0 0;}#yiv2175804304 #yiv2175804304ygrp-mkp .yiv2175804304ad p {margin:0;}#yiv2175804304 #yiv2175804304ygrp-mkp .yiv2175804304ad a {color:#0000ff;text-decoration:none;}#yiv2175804304 #yiv2175804304ygrp-sponsor #yiv2175804304ygrp-lc {font-family:Arial;}#yiv2175804304 #yiv2175804304ygrp-sponsor #yiv2175804304ygrp-lc #yiv2175804304hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2175804304 #yiv2175804304ygrp-sponsor #yiv2175804304ygrp-lc .yiv2175804304ad {margin-bottom:10px;padding:0 0;}#yiv2175804304 #yiv2175804304actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2175804304 #yiv2175804304activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2175804304 #yiv2175804304activity span {font-weight:700;}#yiv2175804304 #yiv2175804304activity span:first-child {text-transform:uppercase;}#yiv2175804304 #yiv2175804304activity span a {color:#5085b6;text-decoration:none;}#yiv2175804304 #yiv2175804304activity span span {color:#ff7900;}#yiv2175804304 #yiv2175804304activity span .yiv2175804304underline {text-decoration:underline;}#yiv2175804304 .yiv2175804304attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2175804304 .yiv2175804304attach div a {text-decoration:none;}#yiv2175804304 .yiv2175804304attach img {border:none;padding-right:5px;}#yiv2175804304 .yiv2175804304attach label {display:block;margin-bottom:5px;}#yiv2175804304 .yiv2175804304attach label a {text-decoration:none;}#yiv2175804304 blockquote {margin:0 0 0 4px;}#yiv2175804304 .yiv2175804304bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2175804304 .yiv2175804304bold a {text-decoration:none;}#yiv2175804304 dd.yiv2175804304last p a {font-family:Verdana;font-weight:700;}#yiv2175804304 dd.yiv2175804304last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2175804304 dd.yiv2175804304last p span.yiv2175804304yshortcuts {margin-right:0;}#yiv2175804304 div.yiv2175804304attach-table div div a {text-decoration:none;}#yiv2175804304 div.yiv2175804304attach-table {width:400px;}#yiv2175804304 div.yiv2175804304file-title a, #yiv2175804304 div.yiv2175804304file-title a:active, #yiv2175804304 div.yiv2175804304file-title a:hover, #yiv2175804304 div.yiv2175804304file-title a:visited {text-decoration:none;}#yiv2175804304 div.yiv2175804304photo-title a, #yiv2175804304 div.yiv2175804304photo-title a:active, #yiv2175804304 div.yiv2175804304photo-title a:hover, #yiv2175804304 div.yiv2175804304photo-title a:visited {text-decoration:none;}#yiv2175804304 div#yiv2175804304ygrp-mlmsg #yiv2175804304ygrp-msg p a span.yiv2175804304yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2175804304 .yiv2175804304green {color:#628c2a;}#yiv2175804304 .yiv2175804304MsoNormal {margin:0 0 0 0;}#yiv2175804304 o {font-size:0;}#yiv2175804304 #yiv2175804304photos div {float:left;width:72px;}#yiv2175804304 #yiv2175804304photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv2175804304 #yiv2175804304photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2175804304 #yiv2175804304reco-category {font-size:77%;}#yiv2175804304 #yiv2175804304reco-desc {font-size:77%;}#yiv2175804304 .yiv2175804304replbq {margin:4px;}#yiv2175804304 #yiv2175804304ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2175804304 #yiv2175804304ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2175804304 #yiv2175804304ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2175804304 #yiv2175804304ygrp-mlmsg select, #yiv2175804304 input, #yiv2175804304 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2175804304 #yiv2175804304ygrp-mlmsg pre, #yiv2175804304 code {font:115% monospace;}#yiv2175804304 #yiv2175804304ygrp-mlmsg * {line-height:1.22em;}#yiv2175804304 #yiv2175804304ygrp-mlmsg #yiv2175804304logo {padding-bottom:10px;}#yiv2175804304 #yiv2175804304ygrp-msg p a {font-family:Verdana;}#yiv2175804304 #yiv2175804304ygrp-msg p#yiv2175804304attach-count span {color:#1E66AE;font-weight:700;}#yiv2175804304 #yiv2175804304ygrp-reco #yiv2175804304reco-head {color:#ff7900;font-weight:700;}#yiv2175804304 #yiv2175804304ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2175804304 #yiv2175804304ygrp-sponsor #yiv2175804304ov li a {font-size:130%;text-decoration:none;}#yiv2175804304 #yiv2175804304ygrp-sponsor #yiv2175804304ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2175804304 #yiv2175804304ygrp-sponsor #yiv2175804304ov ul {margin:0;padding:0 0 0 8px;}#yiv2175804304 #yiv2175804304ygrp-text {font-family:Georgia;}#yiv2175804304 #yiv2175804304ygrp-text p {margin:0 0 1em 0;}#yiv2175804304 #yiv2175804304ygrp-text tt {font-size:120%;}#yiv2175804304 #yiv2175804304ygrp-vital ul li:last-child {border-right:none !important;}#yiv2175804304