Hai Kamirin,Saya coba jawab pake macro.
Salam,HK
From: "Kamirin Faqoth [email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
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 <[email protected]>
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.
#yiv0209570405 #yiv0209570405 -- #yiv0209570405ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0209570405
#yiv0209570405ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0209570405
#yiv0209570405ygrp-mkp #yiv0209570405hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0209570405 #yiv0209570405ygrp-mkp #yiv0209570405ads
{margin-bottom:10px;}#yiv0209570405 #yiv0209570405ygrp-mkp .yiv0209570405ad
{padding:0 0;}#yiv0209570405 #yiv0209570405ygrp-mkp .yiv0209570405ad p
{margin:0;}#yiv0209570405 #yiv0209570405ygrp-mkp .yiv0209570405ad a
{color:#0000ff;text-decoration:none;}#yiv0209570405 #yiv0209570405ygrp-sponsor
#yiv0209570405ygrp-lc {font-family:Arial;}#yiv0209570405
#yiv0209570405ygrp-sponsor #yiv0209570405ygrp-lc #yiv0209570405hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0209570405
#yiv0209570405ygrp-sponsor #yiv0209570405ygrp-lc .yiv0209570405ad
{margin-bottom:10px;padding:0 0;}#yiv0209570405 #yiv0209570405actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0209570405
#yiv0209570405activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0209570405
#yiv0209570405activity span {font-weight:700;}#yiv0209570405
#yiv0209570405activity span:first-child
{text-transform:uppercase;}#yiv0209570405 #yiv0209570405activity span a
{color:#5085b6;text-decoration:none;}#yiv0209570405 #yiv0209570405activity span
span {color:#ff7900;}#yiv0209570405 #yiv0209570405activity span
.yiv0209570405underline {text-decoration:underline;}#yiv0209570405
.yiv0209570405attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0209570405 .yiv0209570405attach div a
{text-decoration:none;}#yiv0209570405 .yiv0209570405attach img
{border:none;padding-right:5px;}#yiv0209570405 .yiv0209570405attach label
{display:block;margin-bottom:5px;}#yiv0209570405 .yiv0209570405attach label a
{text-decoration:none;}#yiv0209570405 blockquote {margin:0 0 0
4px;}#yiv0209570405 .yiv0209570405bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0209570405
.yiv0209570405bold a {text-decoration:none;}#yiv0209570405 dd.yiv0209570405last
p a {font-family:Verdana;font-weight:700;}#yiv0209570405 dd.yiv0209570405last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0209570405
dd.yiv0209570405last p span.yiv0209570405yshortcuts
{margin-right:0;}#yiv0209570405 div.yiv0209570405attach-table div div a
{text-decoration:none;}#yiv0209570405 div.yiv0209570405attach-table
{width:400px;}#yiv0209570405 div.yiv0209570405file-title a, #yiv0209570405
div.yiv0209570405file-title a:active, #yiv0209570405
div.yiv0209570405file-title a:hover, #yiv0209570405 div.yiv0209570405file-title
a:visited {text-decoration:none;}#yiv0209570405 div.yiv0209570405photo-title a,
#yiv0209570405 div.yiv0209570405photo-title a:active, #yiv0209570405
div.yiv0209570405photo-title a:hover, #yiv0209570405
div.yiv0209570405photo-title a:visited {text-decoration:none;}#yiv0209570405
div#yiv0209570405ygrp-mlmsg #yiv0209570405ygrp-msg p a
span.yiv0209570405yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0209570405
.yiv0209570405green {color:#628c2a;}#yiv0209570405 .yiv0209570405MsoNormal
{margin:0 0 0 0;}#yiv0209570405 o {font-size:0;}#yiv0209570405
#yiv0209570405photos div {float:left;width:72px;}#yiv0209570405
#yiv0209570405photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv0209570405
#yiv0209570405photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0209570405
#yiv0209570405reco-category {font-size:77%;}#yiv0209570405
#yiv0209570405reco-desc {font-size:77%;}#yiv0209570405 .yiv0209570405replbq
{margin:4px;}#yiv0209570405 #yiv0209570405ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0209570405 #yiv0209570405ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0209570405
#yiv0209570405ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0209570405
#yiv0209570405ygrp-mlmsg select, #yiv0209570405 input, #yiv0209570405 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0209570405
#yiv0209570405ygrp-mlmsg pre, #yiv0209570405 code {font:115%
monospace;}#yiv0209570405 #yiv0209570405ygrp-mlmsg *
{line-height:1.22em;}#yiv0209570405 #yiv0209570405ygrp-mlmsg #yiv0209570405logo
{padding-bottom:10px;}#yiv0209570405 #yiv0209570405ygrp-msg p a
{font-family:Verdana;}#yiv0209570405 #yiv0209570405ygrp-msg
p#yiv0209570405attach-count span {color:#1E66AE;font-weight:700;}#yiv0209570405
#yiv0209570405ygrp-reco #yiv0209570405reco-head
{color:#ff7900;font-weight:700;}#yiv0209570405 #yiv0209570405ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv0209570405 #yiv0209570405ygrp-sponsor
#yiv0209570405ov li a {font-size:130%;text-decoration:none;}#yiv0209570405
#yiv0209570405ygrp-sponsor #yiv0209570405ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0209570405
#yiv0209570405ygrp-sponsor #yiv0209570405ov ul {margin:0;padding:0 0 0
8px;}#yiv0209570405 #yiv0209570405ygrp-text
{font-family:Georgia;}#yiv0209570405 #yiv0209570405ygrp-text p {margin:0 0 1em
0;}#yiv0209570405 #yiv0209570405ygrp-text tt {font-size:120%;}#yiv0209570405
#yiv0209570405ygrp-vital ul li:last-child {border-right:none
!important;}#yiv0209570405
re_Database GKR.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
