Sabtu, 30 Juni 2018

[belajar-excel] Digest Number 4530

2 Messages

Digest #4530
1a
Kalender pada Excel 2010 by "hendrik karnadi" hendrikkarnadi

Messages

Sat Jun 30, 2018 3:23 am (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Selamat sore rekan2 BeExcel....
Buat rekan2 yang masih memerlukan kalender waktu menginput tgl pada Sheet Excel, terlampir adalah file Add-ins (.xlam) yang perlu ditempatkan pada dir yang sama dengan file excel yang kita buka.
Sy lampirkan juga file berisi macro untuk menempatkan file Add-ins di atas pada Ribbon Add-ins (Developer, Add-ins).
Semoga bermanfaat.
Salam,HK

Sent from Yahoo Mail on Android

Sat Jun 30, 2018 7:56 am (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Bisa juga dipakai s/d Excel 2016.Sumbernya dari internet.
Salam,HK

Sent from Yahoo Mail on Android

On Sat, Jun 30, 2018 at 17:23, hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]<belajar-excel@yahoogroups.com> wrote:  

Selamat sore rekan2 BeExcel....
Buat rekan2 yang masih memerlukan kalender waktu menginput tgl pada Sheet Excel, terlampir adalah file Add-ins (.xlam) yang perlu ditempatkan pada dir yang sama dengan file excel yang kita buka.
Sy lampirkan juga file berisi macro untuk menempatkan file Add-ins di atas pada Ribbon Add-ins (Developer, Add-ins).
Semoga bermanfaat.
Salam,HK

Sent from Yahoo Mail on Android #yiv9301703787 #yiv9301703787 -- #yiv9301703787ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9301703787 #yiv9301703787ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9301703787 #yiv9301703787ygrp-mkp #yiv9301703787hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9301703787 #yiv9301703787ygrp-mkp #yiv9301703787ads {margin-bottom:10px;}#yiv9301703787 #yiv9301703787ygrp-mkp .yiv9301703787ad {padding:0 0;}#yiv9301703787 #yiv9301703787ygrp-mkp .yiv9301703787ad p {margin:0;}#yiv9301703787 #yiv9301703787ygrp-mkp .yiv9301703787ad a {color:#0000ff;text-decoration:none;}#yiv9301703787 #yiv9301703787ygrp-sponsor #yiv9301703787ygrp-lc {font-family:Arial;}#yiv9301703787 #yiv9301703787ygrp-sponsor #yiv9301703787ygrp-lc #yiv9301703787hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9301703787 #yiv9301703787ygrp-sponsor #yiv9301703787ygrp-lc .yiv9301703787ad {margin-bottom:10px;padding:0 0;}#yiv9301703787 #yiv9301703787actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9301703787 #yiv9301703787activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9301703787 #yiv9301703787activity span {font-weight:700;}#yiv9301703787 #yiv9301703787activity span:first-child {text-transform:uppercase;}#yiv9301703787 #yiv9301703787activity span a {color:#5085b6;text-decoration:none;}#yiv9301703787 #yiv9301703787activity span span {color:#ff7900;}#yiv9301703787 #yiv9301703787activity span ..yiv9301703787underline {text-decoration:underline;}#yiv9301703787 .yiv9301703787attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9301703787 .yiv9301703787attach div a {text-decoration:none;}#yiv9301703787 .yiv9301703787attach img {border:none;padding-right:5px;}#yiv9301703787 .yiv9301703787attach label {display:block;margin-bottom:5px;}#yiv9301703787 .yiv9301703787attach label a {text-decoration:none;}#yiv9301703787 blockquote {margin:0 0 0 4px;}#yiv9301703787 .yiv9301703787bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9301703787 .yiv9301703787bold a {text-decoration:none;}#yiv9301703787 dd.yiv9301703787last p a {font-family:Verdana;font-weight:700;}#yiv9301703787 dd.yiv9301703787last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9301703787 dd.yiv9301703787last p span.yiv9301703787yshortcuts {margin-right:0;}#yiv9301703787 div.yiv9301703787attach-table div div a {text-decoration:none;}#yiv9301703787 div.yiv9301703787attach-table {width:400px;}#yiv9301703787 div.yiv9301703787file-title a, #yiv9301703787 div.yiv9301703787file-title a:active, #yiv9301703787 div.yiv9301703787file-title a:hover, #yiv9301703787 div.yiv9301703787file-title a:visited {text-decoration:none;}#yiv9301703787 div.yiv9301703787photo-title a, #yiv9301703787 div.yiv9301703787photo-title a:active, #yiv9301703787 div.yiv9301703787photo-title a:hover, #yiv9301703787 div.yiv9301703787photo-title a:visited {text-decoration:none;}#yiv9301703787 div#yiv9301703787ygrp-mlmsg #yiv9301703787ygrp-msg p a span.yiv9301703787yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9301703787 .yiv9301703787green {color:#628c2a;}#yiv9301703787 .yiv9301703787MsoNormal {margin:0 0 0 0;}#yiv9301703787 o {font-size:0;}#yiv9301703787 #yiv9301703787photos div {float:left;width:72px;}#yiv9301703787 #yiv9301703787photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv9301703787 #yiv9301703787photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9301703787 #yiv9301703787reco-category {font-size:77%;}#yiv9301703787 #yiv9301703787reco-desc {font-size:77%;}#yiv9301703787 .yiv9301703787replbq {margin:4px;}#yiv9301703787 #yiv9301703787ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9301703787 #yiv9301703787ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9301703787 #yiv9301703787ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9301703787 #yiv9301703787ygrp-mlmsg select, #yiv9301703787 input, #yiv9301703787 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9301703787 #yiv9301703787ygrp-mlmsg pre, #yiv9301703787 code {font:115% monospace;}#yiv9301703787 #yiv9301703787ygrp-mlmsg * {line-height:1.22em;}#yiv9301703787 #yiv9301703787ygrp-mlmsg #yiv9301703787logo {padding-bottom:10px;}#yiv9301703787 #yiv9301703787ygrp-msg p a {font-family:Verdana;}#yiv9301703787 #yiv9301703787ygrp-msg p#yiv9301703787attach-count span {color:#1E66AE;font-weight:700;}#yiv9301703787 #yiv9301703787ygrp-reco #yiv9301703787reco-head {color:#ff7900;font-weight:700;}#yiv9301703787 #yiv9301703787ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9301703787 #yiv9301703787ygrp-sponsor #yiv9301703787ov li a {font-size:130%;text-decoration:none;}#yiv9301703787 #yiv9301703787ygrp-sponsor #yiv9301703787ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9301703787 #yiv9301703787ygrp-sponsor #yiv9301703787ov ul {margin:0;padding:0 0 0 8px;}#yiv9301703787 #yiv9301703787ygrp-text {font-family:Georgia;}#yiv9301703787 #yiv9301703787ygrp-text p {margin:0 0 1em 0;}#yiv9301703787 #yiv9301703787ygrp-text tt {font-size:120%;}#yiv9301703787 #yiv9301703787ygrp-vital ul li:last-child {border-right:none !important;}#yiv9301703787
============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------
READ MORE....
Diposting oleh EXCEL FEED LEARNING di 23.39 0 komentar

[smf_addin] Digest Number 4351

5 Messages

Digest #4351

Messages

Fri Jun 29, 2018 8:16 am (PDT) . Posted by:

JCHyjun

Hello,


smfGetYahooPortfolioView from SMF-AddIn ver. 2.1.2017.11.30 worked fine with Excel 2010 and Windows 7 but in new Windows 10 laptop with the same Excel 2010 quotes are not updated (I got the absolutely the same numbers checking quotes at 10AM and 11AM during open market).


SMF-AddIn ver. 2.1.2018.01.24 does NOT work at all in Windows 10 laptop. One point I noticed that new XLA file is smaller than previous one (Is it supposed to be?).



I reinstalled SMF-AddIn ver. 2.1.2017.11.30 back and got the same problem of frozen quotes.



How to fix the problem?


Thank you
JCH



Fri Jun 29, 2018 9:11 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You are using the smfForceRecalculation macro to force updates, right?

If that's not updating your quotes, make sure you have your Internet Option
set to always get a fresh copy of a web page.

On Fri, Jun 29, 2018 at 8:16 AM, jchyjun@
​...
wrote:

>
> smfGetYahooPortfolioView from SMF-AddIn ver. 2.1.2017.11.30 worked fine
> with Excel 2010 and Windows 7 but in new Windows 10 laptop with the same
> Excel 2010 quotes are not updated (I got the absolutely the same numbers
> checking quotes at 10AM and 11AM during open market).
>
> SMF-AddIn ver. 2.1.2018.01.24 does NOT work at all in Windows 10 laptop.
> One point I noticed that new XLA file is smaller than previous one (Is it
> supposed to be?).
>
> I reinstalled SMF-AddIn ver. 2.1.2017.11.30 back and got the same problem
> of frozen quotes.
>
> How to fix the problem?
>
>

Sat Jun 30, 2018 2:39 am (PDT) . Posted by:

timdbui

Hello,


I am sure this question had been asked before, but could anyone please tell me what are the SMF element numbers to get the company name and its latest stock price? Thanks so much for your help! Tim

Sat Jun 30, 2018 2:50 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

For current quotes, take a look at the smfGetYahooPortfolioView() function.
Both documentation and template are on the website.

On Sat, Jun 30, 2018 at 2:28 AM, timdbui@
​...
wrote:

> I am sure this question had been asked before, but could anyone please
> tell me what are the SMF element numbers to get the company name and its
> latest stock price? Thanks so much for your help! Tim
>
>

Sat Jun 30, 2018 4:30 am (PDT) . Posted by:

timdbui

Thank you for your quick reply, Randy!
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
READ MORE....
Diposting oleh EXCEL FEED LEARNING di 05.30 0 komentar

Jumat, 29 Juni 2018

[belajar-excel] Digest Number 4529

8 Messages

Digest #4529
1b
Re: Copy Data Antar Sheet Dengan Criteria "KIRIM" by "hendrik karnadi" hendrikkarnadi
2.1
Re: Absensi [1 Attachment] by "hendrik karnadi" hendrikkarnadi
2.2
Bls: [belajar-excel] Absensi [1 Attachment] by "Denny Oktavianus" denny_y86
2.3
Re: Bls: [belajar-excel] Absensi by "hendrik karnadi" hendrikkarnadi
2.4
Re: Bls: [belajar-excel] Absensi by "denny_y86" denny_y86

Messages

Thu Jun 28, 2018 10:51 pm (PDT) . Posted by:

y.roni35

Dear Pak Dede,


Lampiran yg mana?
Kok tidak ada




Regards,
Yusuf

Fri Jun 29, 2018 12:05 am (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Yusuf,Jawaban yang saya kirim tgl 19 dan 20 Juni sdh dicoba ?
Jwb tgl 19 JuniAda kiriteria di Sheet Terima range N1 dan N2,N1 ditulis Description, N2 ditulis KIRIM
Jwb tgl 20 JuniMacro yang sdh diperbaiki.
Salam,HK

Sent from Yahoo Mail on Android

On Fri, Jun 29, 2018 at 12:51, y.roni35@yahoo.com [belajar-excel]<belajar-excel@yahoogroups.com> wrote:  

Dear Pak Dede,
Lampiran yg mana?Kok tidak ada

Regards,Yusuf
#yiv9843684402 #yiv9843684402 -- #yiv9843684402ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9843684402 #yiv9843684402ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9843684402 #yiv9843684402ygrp-mkp #yiv9843684402hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9843684402 #yiv9843684402ygrp-mkp #yiv9843684402ads {margin-bottom:10px;}#yiv9843684402 #yiv9843684402ygrp-mkp .yiv9843684402ad {padding:0 0;}#yiv9843684402 #yiv9843684402ygrp-mkp .yiv9843684402ad p {margin:0;}#yiv9843684402 #yiv9843684402ygrp-mkp .yiv9843684402ad a {color:#0000ff;text-decoration:none;}#yiv9843684402 #yiv9843684402ygrp-sponsor #yiv9843684402ygrp-lc {font-family:Arial;}#yiv9843684402 #yiv9843684402ygrp-sponsor #yiv9843684402ygrp-lc #yiv9843684402hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9843684402 #yiv9843684402ygrp-sponsor #yiv9843684402ygrp-lc .yiv9843684402ad {margin-bottom:10px;padding:0 0;}#yiv9843684402 #yiv9843684402actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9843684402 #yiv9843684402activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9843684402 #yiv9843684402activity span {font-weight:700;}#yiv9843684402 #yiv9843684402activity span:first-child {text-transform:uppercase;}#yiv9843684402 #yiv9843684402activity span a {color:#5085b6;text-decoration:none;}#yiv9843684402 #yiv9843684402activity span span {color:#ff7900;}#yiv9843684402 #yiv9843684402activity span .yiv9843684402underline {text-decoration:underline;}#yiv9843684402 .yiv9843684402attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9843684402 .yiv9843684402attach div a {text-decoration:none;}#yiv9843684402 .yiv9843684402attach img {border:none;padding-right:5px;}#yiv9843684402 .yiv9843684402attach label {display:block;margin-bottom:5px;}#yiv9843684402 .yiv9843684402attach label a {text-decoration:none;}#yiv9843684402 blockquote {margin:0 0 0 4px;}#yiv9843684402 .yiv9843684402bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9843684402 .yiv9843684402bold a {text-decoration:none;}#yiv9843684402 dd.yiv9843684402last p a {font-family:Verdana;font-weight:700;}#yiv9843684402 dd.yiv9843684402last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9843684402 dd.yiv9843684402last p span.yiv9843684402yshortcuts {margin-right:0;}#yiv9843684402 div.yiv9843684402attach-table div div a {text-decoration:none;}#yiv9843684402 div.yiv9843684402attach-table {width:400px;}#yiv9843684402 div.yiv9843684402file-title a, #yiv9843684402 div.yiv9843684402file-title a:active, #yiv9843684402 div.yiv9843684402file-title a:hover, #yiv9843684402 div.yiv9843684402file-title a:visited {text-decoration:none;}#yiv9843684402 div.yiv9843684402photo-title a, #yiv9843684402 div.yiv9843684402photo-title a:active, #yiv9843684402 div.yiv9843684402photo-title a:hover, #yiv9843684402 div.yiv9843684402photo-title a:visited {text-decoration:none;}#yiv9843684402 div#yiv9843684402ygrp-mlmsg #yiv9843684402ygrp-msg p a span.yiv9843684402yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9843684402 .yiv9843684402green {color:#628c2a;}#yiv9843684402 .yiv9843684402MsoNormal {margin:0 0 0 0;}#yiv9843684402 o {font-size:0;}#yiv9843684402 #yiv9843684402photos div {float:left;width:72px;}#yiv9843684402 #yiv9843684402photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv9843684402 #yiv9843684402photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9843684402 #yiv9843684402reco-category {font-size:77%;}#yiv9843684402 #yiv9843684402reco-desc {font-size:77%;}#yiv9843684402 .yiv9843684402replbq {margin:4px;}#yiv9843684402 #yiv9843684402ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9843684402 #yiv9843684402ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9843684402 #yiv9843684402ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9843684402 #yiv9843684402ygrp-mlmsg select, #yiv9843684402 input, #yiv9843684402 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9843684402 #yiv9843684402ygrp-mlmsg pre, #yiv9843684402 code {font:115% monospace;}#yiv9843684402 #yiv9843684402ygrp-mlmsg * {line-height:1..22em;}#yiv9843684402 #yiv9843684402ygrp-mlmsg #yiv9843684402logo {padding-bottom:10px;}#yiv9843684402 #yiv9843684402ygrp-msg p a {font-family:Verdana;}#yiv9843684402 #yiv9843684402ygrp-msg p#yiv9843684402attach-count span {color:#1E66AE;font-weight:700;}#yiv9843684402 #yiv9843684402ygrp-reco #yiv9843684402reco-head {color:#ff7900;font-weight:700;}#yiv9843684402 #yiv9843684402ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9843684402 #yiv9843684402ygrp-sponsor #yiv9843684402ov li a {font-size:130%;text-decoration:none;}#yiv9843684402 #yiv9843684402ygrp-sponsor #yiv9843684402ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9843684402 #yiv9843684402ygrp-sponsor #yiv9843684402ov ul {margin:0;padding:0 0 0 8px;}#yiv9843684402 #yiv9843684402ygrp-text {font-family:Georgia;}#yiv9843684402 #yiv9843684402ygrp-text p {margin:0 0 1em 0;}#yiv9843684402 #yiv9843684402ygrp-text tt {font-size:120%;}#yiv9843684402 #yiv9843684402ygrp-vital ul li:last-child {border-right:none !important;}#yiv9843684402

Fri Jun 29, 2018 12:01 am (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Denny,
Pakai Macro ya.Jangan lupa aktifkan Macronya terlebih dahulu.
Salam,HK

On Thursday, 28 June 2018, 4:46:22 PM GMT+7, Denny Oktavianus denny_y86@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

 

Dear all,
Selamat Sore.

Mohon di bantu kiranya bisa membantu untuk  case absensi ini.

Terima kasih atas bantuannya .
Denny

Fri Jun 29, 2018 9:37 am (PDT) . Posted by:

"Denny Oktavianus" denny_y86

dear pak hendrik,

Terima kasih atas bantuan bapak, sudah kita ikuti sesuai arahan dan berhasil.

salam
denny


Pada Jumat, 29 Juni 2018 14:01, "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Hai Denny,
Pakai Macro ya.Jangan lupa aktifkan Macronya terlebih dahulu.
Salam,HK

On Thursday, 28 June 2018, 4:46:22 PM GMT+7, Denny Oktavianus denny_y86@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

  Dear all,
Selamat Sore.

Mohon di bantu kiranya bisa membantu untuk  case absensi ini.

Terima kasih atas bantuannya .
Denny #yiv2857145364 #yiv2857145364 -- #yiv2857145364ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2857145364 #yiv2857145364ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2857145364 #yiv2857145364ygrp-mkp #yiv2857145364hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2857145364 #yiv2857145364ygrp-mkp #yiv2857145364ads {margin-bottom:10px;}#yiv2857145364 #yiv2857145364ygrp-mkp .yiv2857145364ad {padding:0 0;}#yiv2857145364 #yiv2857145364ygrp-mkp .yiv2857145364ad p {margin:0;}#yiv2857145364 #yiv2857145364ygrp-mkp .yiv2857145364ad a {color:#0000ff;text-decoration:none;}#yiv2857145364 #yiv2857145364ygrp-sponsor #yiv2857145364ygrp-lc {font-family:Arial;}#yiv2857145364 #yiv2857145364ygrp-sponsor #yiv2857145364ygrp-lc #yiv2857145364hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2857145364 #yiv2857145364ygrp-sponsor #yiv2857145364ygrp-lc .yiv2857145364ad {margin-bottom:10px;padding:0 0;}#yiv2857145364 #yiv2857145364actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2857145364 #yiv2857145364activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2857145364 #yiv2857145364activity span {font-weight:700;}#yiv2857145364 #yiv2857145364activity span:first-child {text-transform:uppercase;}#yiv2857145364 #yiv2857145364activity span a {color:#5085b6;text-decoration:none;}#yiv2857145364 #yiv2857145364activity span span {color:#ff7900;}#yiv2857145364 #yiv2857145364activity span .yiv2857145364underline {text-decoration:underline;}#yiv2857145364 .yiv2857145364attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2857145364 .yiv2857145364attach div a {text-decoration:none;}#yiv2857145364 .yiv2857145364attach img {border:none;padding-right:5px;}#yiv2857145364 .yiv2857145364attach label {display:block;margin-bottom:5px;}#yiv2857145364 .yiv2857145364attach label a {text-decoration:none;}#yiv2857145364 blockquote {margin:0 0 0 4px;}#yiv2857145364 .yiv2857145364bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2857145364 .yiv2857145364bold a {text-decoration:none;}#yiv2857145364 dd.yiv2857145364last p a {font-family:Verdana;font-weight:700;}#yiv2857145364 dd.yiv2857145364last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2857145364 dd.yiv2857145364last p span.yiv2857145364yshortcuts {margin-right:0;}#yiv2857145364 div.yiv2857145364attach-table div div a {text-decoration:none;}#yiv2857145364 div.yiv2857145364attach-table {width:400px;}#yiv2857145364 div.yiv2857145364file-title a, #yiv2857145364 div.yiv2857145364file-title a:active, #yiv2857145364 div.yiv2857145364file-title a:hover, #yiv2857145364 div.yiv2857145364file-title a:visited {text-decoration:none;}#yiv2857145364 div.yiv2857145364photo-title a, #yiv2857145364 div.yiv2857145364photo-title a:active, #yiv2857145364 div.yiv2857145364photo-title a:hover, #yiv2857145364 div.yiv2857145364photo-title a:visited {text-decoration:none;}#yiv2857145364 div#yiv2857145364ygrp-mlmsg #yiv2857145364ygrp-msg p a span.yiv2857145364yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2857145364 .yiv2857145364green {color:#628c2a;}#yiv2857145364 .yiv2857145364MsoNormal {margin:0 0 0 0;}#yiv2857145364 o {font-size:0;}#yiv2857145364 #yiv2857145364photos div {float:left;width:72px;}#yiv2857145364 #yiv2857145364photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv2857145364 #yiv2857145364photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2857145364 #yiv2857145364reco-category {font-size:77%;}#yiv2857145364 #yiv2857145364reco-desc {font-size:77%;}#yiv2857145364 .yiv2857145364replbq {margin:4px;}#yiv2857145364 #yiv2857145364ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2857145364 #yiv2857145364ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2857145364 #yiv2857145364ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2857145364 #yiv2857145364ygrp-mlmsg select, #yiv2857145364 input, #yiv2857145364 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2857145364 #yiv2857145364ygrp-mlmsg pre, #yiv2857145364 code {font:115% monospace;}#yiv2857145364 #yiv2857145364ygrp-mlmsg * {line-height:1.22em;}#yiv2857145364 #yiv2857145364ygrp-mlmsg #yiv2857145364logo {padding-bottom:10px;}#yiv2857145364 #yiv2857145364ygrp-msg p a {font-family:Verdana;}#yiv2857145364 #yiv2857145364ygrp-msg p#yiv2857145364attach-count span {color:#1E66AE;font-weight:700;}#yiv2857145364 #yiv2857145364ygrp-reco #yiv2857145364reco-head {color:#ff7900;font-weight:700;}#yiv2857145364 #yiv2857145364ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2857145364 #yiv2857145364ygrp-sponsor #yiv2857145364ov li a {font-size:130%;text-decoration:none;}#yiv2857145364 #yiv2857145364ygrp-sponsor #yiv2857145364ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2857145364 #yiv2857145364ygrp-sponsor #yiv2857145364ov ul {margin:0;padding:0 0 0 8px;}#yiv2857145364 #yiv2857145364ygrp-text {font-family:Georgia;}#yiv2857145364 #yiv2857145364ygrp-text p {margin:0 0 1em 0;}#yiv2857145364 #yiv2857145364ygrp-text tt {font-size:120%;}#yiv2857145364 #yiv2857145364ygrp-vital ul li:last-child {border-right:none !important;}#yiv2857145364

Fri Jun 29, 2018 7:25 pm (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Denny,
Terima kasih kembali.Sedikit tambahan, keuntungan dgn menggunakan macro adalah nama dan tanggalnya bisa ditambah asalkan "struktur" datanya tidak berubah,- Data mulai dari A1- Nama mulai dari baris ke 3- Tanggal mulai dari kolom ke 2
Salam,HK

Sent from Yahoo Mail on Android

On Fri, Jun 29, 2018 at 23:39, Denny Oktavianus denny_y86@yahoo.co.id [belajar-excel]<belajar-excel@yahoogroups.com> wrote:  

dear pak hendrik,

Terima kasih atas bantuan bapak, sudah kita ikuti sesuai arahan dan berhasil.

salam
denny


Pada Jumat, 29 Juni 2018 14:01, "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Hai Denny,
Pakai Macro ya.Jangan lupa aktifkan Macronya terlebih dahulu.
Salam,HK

On Thursday, 28 June 2018, 4:46:22 PM GMT+7, Denny Oktavianus denny_y86@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

  Dear all,
Selamat Sore.

Mohon di bantu kiranya bisa membantu untuk  case absensi ini.

Terima kasih atas bantuannya .
Denny

#yiv1846563302 #yiv1846563302 -- #yiv1846563302ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1846563302 #yiv1846563302ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1846563302 #yiv1846563302ygrp-mkp #yiv1846563302hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1846563302 #yiv1846563302ygrp-mkp #yiv1846563302ads {margin-bottom:10px;}#yiv1846563302 #yiv1846563302ygrp-mkp .yiv1846563302ad {padding:0 0;}#yiv1846563302 #yiv1846563302ygrp-mkp .yiv1846563302ad p {margin:0;}#yiv1846563302 #yiv1846563302ygrp-mkp .yiv1846563302ad a {color:#0000ff;text-decoration:none;}#yiv1846563302 #yiv1846563302ygrp-sponsor #yiv1846563302ygrp-lc {font-family:Arial;}#yiv1846563302 #yiv1846563302ygrp-sponsor #yiv1846563302ygrp-lc #yiv1846563302hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1846563302 #yiv1846563302ygrp-sponsor #yiv1846563302ygrp-lc .yiv1846563302ad {margin-bottom:10px;padding:0 0;}#yiv1846563302 #yiv1846563302actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1846563302 #yiv1846563302activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1846563302 #yiv1846563302activity span {font-weight:700;}#yiv1846563302 #yiv1846563302activity span:first-child {text-transform:uppercase;}#yiv1846563302 #yiv1846563302activity span a {color:#5085b6;text-decoration:none;}#yiv1846563302 #yiv1846563302activity span span {color:#ff7900;}#yiv1846563302 #yiv1846563302activity span .yiv1846563302underline {text-decoration:underline;}#yiv1846563302 .yiv1846563302attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1846563302 .yiv1846563302attach div a {text-decoration:none;}#yiv1846563302 .yiv1846563302attach img {border:none;padding-right:5px;}#yiv1846563302 .yiv1846563302attach label {display:block;margin-bottom:5px;}#yiv1846563302 .yiv1846563302attach label a {text-decoration:none;}#yiv1846563302 blockquote {margin:0 0 0 4px;}#yiv1846563302 .yiv1846563302bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1846563302 .yiv1846563302bold a {text-decoration:none;}#yiv1846563302 dd.yiv1846563302last p a {font-family:Verdana;font-weight:700;}#yiv1846563302 dd.yiv1846563302last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1846563302 dd.yiv1846563302last p span.yiv1846563302yshortcuts {margin-right:0;}#yiv1846563302 div.yiv1846563302attach-table div div a {text-decoration:none;}#yiv1846563302 div.yiv1846563302attach-table {width:400px;}#yiv1846563302 div.yiv1846563302file-title a, #yiv1846563302 div.yiv1846563302file-title a:active, #yiv1846563302 div.yiv1846563302file-title a:hover, #yiv1846563302 div.yiv1846563302file-title a:visited {text-decoration:none;}#yiv1846563302 div.yiv1846563302photo-title a, #yiv1846563302 div.yiv1846563302photo-title a:active, #yiv1846563302 div.yiv1846563302photo-title a:hover, #yiv1846563302 div.yiv1846563302photo-title a:visited {text-decoration:none;}#yiv1846563302 div#yiv1846563302ygrp-mlmsg #yiv1846563302ygrp-msg p a span.yiv1846563302yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1846563302 .yiv1846563302green {color:#628c2a;}#yiv1846563302 .yiv1846563302MsoNormal {margin:0 0 0 0;}#yiv1846563302 o {font-size:0;}#yiv1846563302 #yiv1846563302photos div {float:left;width:72px;}#yiv1846563302 #yiv1846563302photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv1846563302 #yiv1846563302photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1846563302 #yiv1846563302reco-category {font-size:77%;}#yiv1846563302 #yiv1846563302reco-desc {font-size:77%;}#yiv1846563302 .yiv1846563302replbq {margin:4px;}#yiv1846563302 #yiv1846563302ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1846563302 #yiv1846563302ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1846563302 #yiv1846563302ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1846563302 #yiv1846563302ygrp-mlmsg select, #yiv1846563302 input, #yiv1846563302 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1846563302 #yiv1846563302ygrp-mlmsg pre, #yiv1846563302 code {font:115% monospace;}#yiv1846563302 #yiv1846563302ygrp-mlmsg * {line-height:1.22em;}#yiv1846563302 #yiv1846563302ygrp-mlmsg #yiv1846563302logo {padding-bottom:10px;}#yiv1846563302 #yiv1846563302ygrp-msg p a {font-family:Verdana;}#yiv1846563302 #yiv1846563302ygrp-msg p#yiv1846563302attach-count span {color:#1E66AE;font-weight:700;}#yiv1846563302 #yiv1846563302ygrp-reco #yiv1846563302reco-head {color:#ff7900;font-weight:700;}#yiv1846563302 #yiv1846563302ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1846563302 #yiv1846563302ygrp-sponsor #yiv1846563302ov li a {font-size:130%;text-decoration:none;}#yiv1846563302 #yiv1846563302ygrp-sponsor #yiv1846563302ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1846563302 #yiv1846563302ygrp-sponsor #yiv1846563302ov ul {margin:0;padding:0 0 0 8px;}#yiv1846563302 #yiv1846563302ygrp-text {font-family:Georgia;}#yiv1846563302 #yiv1846563302ygrp-text p {margin:0 0 1em 0;}#yiv1846563302 #yiv1846563302ygrp-text tt {font-size:120%;}#yiv1846563302 #yiv1846563302ygrp-vital ul li:last-child {border-right:none !important;}#yiv1846563302

Fri Jun 29, 2018 8:52 pm (PDT) . Posted by:

"denny_y86" denny_y86

Terima kasih Pak Hendrik atas informasi tambahan. Sukses selalu untuk bapak. 
Sudah kita coba dan berhasil. 
Salam
Denny

Sent from my Samsung Galaxy smartphone.
-------- Original message --------From: "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> Date: 30/06/2018 09:21 (GMT+07:00) To: belajar-excel@yahoogroups.com Subject: Re: Bls: [belajar-excel] Absensi

 

Hai Denny,
Terima kasih kembali.Sedikit tambahan, keuntungan dgn menggunakan macro adalah nama dan tanggalnya bisa ditambah asalkan "struktur" datanya tidak berubah,- Data mulai dari A1- Nama mulai dari baris ke 3- Tanggal mulai dari kolom ke 2
Salam,HK

Sent from Yahoo Mail on Android
On Fri, Jun 29, 2018 at 23:39, Denny Oktavianus denny_y86@yahoo.co.id [belajar-excel]<belajar-excel@yahoogroups.com> wrote:
 

dear pak hendrik,

Terima kasih atas bantuan bapak, sudah kita ikuti sesuai arahan dan berhasil.

salam
denny


Pada Jumat, 29 Juni 2018 14:01, "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


 

Hai Denny,
Pakai Macro ya.Jangan lupa aktifkan Macronya terlebih dahulu.
Salam,HK

On Thursday, 28 June 2018, 4:46:22 PM GMT+7, Denny Oktavianus denny_y86@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> wrote:



 

Dear all,
Selamat Sore.

Mohon di bantu kiranya bisa membantu untuk  case absensi ini.

Terima kasih atas bantuannya .
Denny

Fri Jun 29, 2018 3:56 am (PDT) . Posted by:

"Tio Adi Bayu Adjie"

Terima kasih Pak Hendrik, semoga Allah membalas kebaikan Pak Hendrik.
Benar seperti contoh file yang memang saya butuhkan. Tapi agak komplek persoalan saya. Tapi saya explore dulu..

Thank you
Best Regards,
Tio

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: 28 Juni 2018 16:40
To: Tio Adi Bayu Adjie tio.adjie@ptssb.co.id [belajar-excel]
Subject: Re: [belajar-excel] Pencarian data di userform dan menampilkan isinya di list boc [1 Attachment]


Hai Tio,
Krn ga ada contohnya, jawbannya juga mereka-reka (jawaban yg mungkin mirip)..
Dari jawaban si mbah atas pertanyaan di milis ini sebelumnya, terlampir adalah suatu file berisi UserForm (jika diklik) yang ada ComboBox dan ListBoxnya.
Pilih pada ComboBox dan data akan ditampilkan pada ListBox yang berada pada UserForm yang sama.

Salam,
HK


On Thursday, 28 June 2018, 1:41:15 PM GMT+7, Tio Adi Bayu Adjie tio.adjie@ptssb.co.id [belajar-excel] <belajar-excel@yahoogroups.com> wrote:




Dear B-Exceller,



Mohon bantuannya. Bagaimana cara mencari data di userform dan menampilkan isinya di list box.



Thank you

Best Regards,

Tio



Fri Jun 29, 2018 6:58 am (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Sy sdh standby net meeting
On Friday, 29 June 2018, 5:56:36 PM GMT+7, Tio Adi Bayu Adjie tio.adjie@ptssb.co.id [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

 

Terima kasih Pak Hendrik, semoga Allah membalas kebaikan Pak Hendrik.

Benar seperti contoh file yang memang saya butuhkan. Tapi agak komplek persoalan saya. Tapi saya explore dulu..

 

Thank you

Best Regards,

Tio

 

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@yahoogroups.com]
Sent: 28 Juni 2018 16:40
To: Tio Adi Bayu Adjie tio.adjie@ptssb.co.id [belajar-excel]
Subject: Re: [belajar-excel] Pencarian data di userform dan menampilkan isinya di list boc [1 Attachment]

 

 

Hai Tio,

Krn ga ada contohnya, jawbannya juga mereka-reka (jawaban yg mungkin mirip)..

Dari jawaban si mbah atas pertanyaan di milis ini sebelumnya, terlampir adalah suatu file berisi UserForm (jika diklik) yang ada ComboBox dan ListBoxnya. 

Pilih pada ComboBox dan data akan ditampilkan pada ListBox yang berada pada UserForm yang sama.

 

Salam,

HK

 

 

On Thursday, 28 June 2018, 1:41:15 PM GMT+7, Tio Adi Bayu Adjie tio.adjie@ptssb.co.id [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

 

 

 

Dear B-Exceller,

 

Mohon bantuannya. Bagaimana cara mencari data di userform dan menampilkan isinya di list box.

 

Thank you

Best Regards,

Tio

 


============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------
READ MORE....
Diposting oleh EXCEL FEED LEARNING di 21.54 0 komentar
Langganan: Postingan (Atom)