Maaf, sebelum diklik...smileynya harus diisi macro (Assign Macro) dulu. Salam,
HK
----- Forwarded Message -----
From: hendrik karnadi <hendrikkarn...@yahoo.com>
To: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Sent: Wednesday, 27 July 2016, 12:50
Subject: Re: [belajar-excel] Trs: Step by step buat Form Message Box [1
Attachment]
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.
#yiv6246879729 -- #yiv6246879729ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6246879729
#yiv6246879729ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6246879729
#yiv6246879729ygrp-mkp #yiv6246879729hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6246879729 #yiv6246879729ygrp-mkp #yiv6246879729ads
{margin-bottom:10px;}#yiv6246879729 #yiv6246879729ygrp-mkp .yiv6246879729ad
{padding:0 0;}#yiv6246879729 #yiv6246879729ygrp-mkp .yiv6246879729ad p
{margin:0;}#yiv6246879729 #yiv6246879729ygrp-mkp .yiv6246879729ad a
{color:#0000ff;text-decoration:none;}#yiv6246879729 #yiv6246879729ygrp-sponsor
#yiv6246879729ygrp-lc {font-family:Arial;}#yiv6246879729
#yiv6246879729ygrp-sponsor #yiv6246879729ygrp-lc #yiv6246879729hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6246879729
#yiv6246879729ygrp-sponsor #yiv6246879729ygrp-lc .yiv6246879729ad
{margin-bottom:10px;padding:0 0;}#yiv6246879729 #yiv6246879729actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6246879729
#yiv6246879729activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6246879729
#yiv6246879729activity span {font-weight:700;}#yiv6246879729
#yiv6246879729activity span:first-child
{text-transform:uppercase;}#yiv6246879729 #yiv6246879729activity span a
{color:#5085b6;text-decoration:none;}#yiv6246879729 #yiv6246879729activity span
span {color:#ff7900;}#yiv6246879729 #yiv6246879729activity span
.yiv6246879729underline {text-decoration:underline;}#yiv6246879729
.yiv6246879729attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6246879729 .yiv6246879729attach div a
{text-decoration:none;}#yiv6246879729 .yiv6246879729attach img
{border:none;padding-right:5px;}#yiv6246879729 .yiv6246879729attach label
{display:block;margin-bottom:5px;}#yiv6246879729 .yiv6246879729attach label a
{text-decoration:none;}#yiv6246879729 blockquote {margin:0 0 0
4px;}#yiv6246879729 .yiv6246879729bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6246879729
.yiv6246879729bold a {text-decoration:none;}#yiv6246879729 dd.yiv6246879729last
p a {font-family:Verdana;font-weight:700;}#yiv6246879729 dd.yiv6246879729last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6246879729
dd.yiv6246879729last p span.yiv6246879729yshortcuts
{margin-right:0;}#yiv6246879729 div.yiv6246879729attach-table div div a
{text-decoration:none;}#yiv6246879729 div.yiv6246879729attach-table
{width:400px;}#yiv6246879729 div.yiv6246879729file-title a, #yiv6246879729
div.yiv6246879729file-title a:active, #yiv6246879729
div.yiv6246879729file-title a:hover, #yiv6246879729 div.yiv6246879729file-title
a:visited {text-decoration:none;}#yiv6246879729 div.yiv6246879729photo-title a,
#yiv6246879729 div.yiv6246879729photo-title a:active, #yiv6246879729
div.yiv6246879729photo-title a:hover, #yiv6246879729
div.yiv6246879729photo-title a:visited {text-decoration:none;}#yiv6246879729
div#yiv6246879729ygrp-mlmsg #yiv6246879729ygrp-msg p a
span.yiv6246879729yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6246879729
.yiv6246879729green {color:#628c2a;}#yiv6246879729 .yiv6246879729MsoNormal
{margin:0 0 0 0;}#yiv6246879729 o {font-size:0;}#yiv6246879729
#yiv6246879729photos div {float:left;width:72px;}#yiv6246879729
#yiv6246879729photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv6246879729
#yiv6246879729photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6246879729
#yiv6246879729reco-category {font-size:77%;}#yiv6246879729
#yiv6246879729reco-desc {font-size:77%;}#yiv6246879729 .yiv6246879729replbq
{margin:4px;}#yiv6246879729 #yiv6246879729ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6246879729 #yiv6246879729ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6246879729
#yiv6246879729ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6246879729
#yiv6246879729ygrp-mlmsg select, #yiv6246879729 input, #yiv6246879729 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6246879729
#yiv6246879729ygrp-mlmsg pre, #yiv6246879729 code {font:115%
monospace;}#yiv6246879729 #yiv6246879729ygrp-mlmsg *
{line-height:1.22em;}#yiv6246879729 #yiv6246879729ygrp-mlmsg #yiv6246879729logo
{padding-bottom:10px;}#yiv6246879729 #yiv6246879729ygrp-msg p a
{font-family:Verdana;}#yiv6246879729 #yiv6246879729ygrp-msg
p#yiv6246879729attach-count span {color:#1E66AE;font-weight:700;}#yiv6246879729
#yiv6246879729ygrp-reco #yiv6246879729reco-head
{color:#ff7900;font-weight:700;}#yiv6246879729 #yiv6246879729ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv6246879729 #yiv6246879729ygrp-sponsor
#yiv6246879729ov li a {font-size:130%;text-decoration:none;}#yiv6246879729
#yiv6246879729ygrp-sponsor #yiv6246879729ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6246879729
#yiv6246879729ygrp-sponsor #yiv6246879729ov ul {margin:0;padding:0 0 0
8px;}#yiv6246879729 #yiv6246879729ygrp-text
{font-family:Georgia;}#yiv6246879729 #yiv6246879729ygrp-text p {margin:0 0 1em
0;}#yiv6246879729 #yiv6246879729ygrp-text tt {font-size:120%;}#yiv6246879729
#yiv6246879729ygrp-vital ul li:last-child {border-right:none
!important;}#yiv6246879729
re_Database GKR.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
