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
