Kalau pake sheet harusnya lebih mudah, yang pasti form inputnya berikut
macronya harus pindah dulu ke Workbook Master bukan Workbook User1, User2 dan
User3.
Silakan dicoba dulu, kalau sdh mentok bisa dishare mentoknya dimana....dengan
begitu ilmu yang kita pelajari akan "melekat" dalam memori kita.
Coba tulis pseudo code ("bahasa manusia") nya dulu.
Salam,HK
Sent from Yahoo Mail on Android
On Wed, Feb 14, 2018 at 18:32, Stephen Saputro stephensapu...@gmail.com
[belajar-excel]<belajar-excel@yahoogroups.com> wrote:
Terima kasih banyak Pak Hendrik untuk bantuannya,
Kalau saya boleh tanya lagi, seandainya nama yang entri di ganti ke sheet bukan
ke workbook, vba yang ThisWrokbook.Name diubah menjadi apa ya Pak?
2018-02-14 16:58 GMT+07:00 hendrik karnadi hendrikkarn...@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com>:
Coba download dan extract file terlampir ke suatu dir (mis D:\).Hasil extract
adalah Master dan User1....untuk User2, User3, dstnya tinggal disesuaikan
Macronya seperti Macro pada User1.
Salam, HK
On Wednesday, 14 February 2018, 4:09:13 PM GMT+7, Stephen Saputro
stephensapu...@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com >
wrote:
File nya saya lampirkan lagi ya Pak, hehe
Terima kasih
2018-02-14 11:21 GMT+07:00 hendrik karnadi hendrikkarn...@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com >:
Filenya mana ???
Salam,HK
On Wednesday, 14 February 2018, 10:58:11 AM GMT+7, Stephen Saputro
stephensapu...@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com >
wrote:
Dear Pak Hendrik & semua pakar Excel,
Mohon kiranya dapat di bantu, dari file yang ada ini bisakah di bantu agar data
yang di input di userform langsung terkirim ke file master tanpa harus transit
lagi di sheet input ?
Terima kasih
2018-02-14 10:42 GMT+07:00 hendrik karnadi hendrikkarn...@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com >:
Hai Yusuf,Macro yang mana, dibuat seperti apa ?
Salam,HK
On Wednesday, 14 February 2018, 9:39:36 AM GMT+7, y.ron...@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com > wrote:
Dear Hendrik Karnadi,
Kl macro di buat seperti itu, harus dirubah bagaimana?Terimakasih
Regards,Yusuf
#yiv3231820614 #yiv3231820614 -- #yiv3231820614ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3231820614
#yiv3231820614ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3231820614
#yiv3231820614ygrp-mkp #yiv3231820614hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv3231820614 #yiv3231820614ygrp-mkp #yiv3231820614ads
{margin-bottom:10px;}#yiv3231820614 #yiv3231820614ygrp-mkp .yiv3231820614ad
{padding:0 0;}#yiv3231820614 #yiv3231820614ygrp-mkp .yiv3231820614ad p
{margin:0;}#yiv3231820614 #yiv3231820614ygrp-mkp .yiv3231820614ad a
{color:#0000ff;text-decoration:none;}#yiv3231820614 #yiv3231820614ygrp-sponsor
#yiv3231820614ygrp-lc {font-family:Arial;}#yiv3231820614
#yiv3231820614ygrp-sponsor #yiv3231820614ygrp-lc #yiv3231820614hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3231820614
#yiv3231820614ygrp-sponsor #yiv3231820614ygrp-lc .yiv3231820614ad
{margin-bottom:10px;padding:0 0;}#yiv3231820614 #yiv3231820614actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3231820614
#yiv3231820614activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3231820614
#yiv3231820614activity span {font-weight:700;}#yiv3231820614
#yiv3231820614activity span:first-child
{text-transform:uppercase;}#yiv3231820614 #yiv3231820614activity span a
{color:#5085b6;text-decoration:none;}#yiv3231820614 #yiv3231820614activity span
span {color:#ff7900;}#yiv3231820614 #yiv3231820614activity span
.yiv3231820614underline {text-decoration:underline;}#yiv3231820614
.yiv3231820614attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv3231820614 .yiv3231820614attach div a
{text-decoration:none;}#yiv3231820614 .yiv3231820614attach img
{border:none;padding-right:5px;}#yiv3231820614 .yiv3231820614attach label
{display:block;margin-bottom:5px;}#yiv3231820614 .yiv3231820614attach label a
{text-decoration:none;}#yiv3231820614 blockquote {margin:0 0 0
4px;}#yiv3231820614 .yiv3231820614bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3231820614
.yiv3231820614bold a {text-decoration:none;}#yiv3231820614 dd.yiv3231820614last
p a {font-family:Verdana;font-weight:700;}#yiv3231820614 dd.yiv3231820614last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3231820614
dd.yiv3231820614last p span.yiv3231820614yshortcuts
{margin-right:0;}#yiv3231820614 div.yiv3231820614attach-table div div a
{text-decoration:none;}#yiv3231820614 div.yiv3231820614attach-table
{width:400px;}#yiv3231820614 div.yiv3231820614file-title a, #yiv3231820614
div.yiv3231820614file-title a:active, #yiv3231820614
div.yiv3231820614file-title a:hover, #yiv3231820614 div.yiv3231820614file-title
a:visited {text-decoration:none;}#yiv3231820614 div.yiv3231820614photo-title a,
#yiv3231820614 div.yiv3231820614photo-title a:active, #yiv3231820614
div.yiv3231820614photo-title a:hover, #yiv3231820614
div.yiv3231820614photo-title a:visited {text-decoration:none;}#yiv3231820614
div#yiv3231820614ygrp-mlmsg #yiv3231820614ygrp-msg p a
span.yiv3231820614yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3231820614
.yiv3231820614green {color:#628c2a;}#yiv3231820614 .yiv3231820614MsoNormal
{margin:0 0 0 0;}#yiv3231820614 o {font-size:0;}#yiv3231820614
#yiv3231820614photos div {float:left;width:72px;}#yiv3231820614
#yiv3231820614photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv3231820614
#yiv3231820614photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3231820614
#yiv3231820614reco-category {font-size:77%;}#yiv3231820614
#yiv3231820614reco-desc {font-size:77%;}#yiv3231820614 .yiv3231820614replbq
{margin:4px;}#yiv3231820614 #yiv3231820614ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv3231820614 #yiv3231820614ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3231820614
#yiv3231820614ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3231820614
#yiv3231820614ygrp-mlmsg select, #yiv3231820614 input, #yiv3231820614 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3231820614
#yiv3231820614ygrp-mlmsg pre, #yiv3231820614 code {font:115%
monospace;}#yiv3231820614 #yiv3231820614ygrp-mlmsg *
{line-height:1.22em;}#yiv3231820614 #yiv3231820614ygrp-mlmsg #yiv3231820614logo
{padding-bottom:10px;}#yiv3231820614 #yiv3231820614ygrp-msg p a
{font-family:Verdana;}#yiv3231820614 #yiv3231820614ygrp-msg
p#yiv3231820614attach-count span {color:#1E66AE;font-weight:700;}#yiv3231820614
#yiv3231820614ygrp-reco #yiv3231820614reco-head
{color:#ff7900;font-weight:700;}#yiv3231820614 #yiv3231820614ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv3231820614 #yiv3231820614ygrp-sponsor
#yiv3231820614ov li a {font-size:130%;text-decoration:none;}#yiv3231820614
#yiv3231820614ygrp-sponsor #yiv3231820614ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3231820614
#yiv3231820614ygrp-sponsor #yiv3231820614ov ul {margin:0;padding:0 0 0
8px;}#yiv3231820614 #yiv3231820614ygrp-text
{font-family:Georgia;}#yiv3231820614 #yiv3231820614ygrp-text p {margin:0 0 1em
0;}#yiv3231820614 #yiv3231820614ygrp-text tt {font-size:120%;}#yiv3231820614
#yiv3231820614ygrp-vital ul li:last-child {border-right:none
!important;}#yiv3231820614
