Jumat, 30 September 2016

[belajar-excel] Digest Number 3979

7 Messages

Digest #3979

Messages

Thu Sep 29, 2016 2:50 am (PDT) . Posted by:

"Heru Safrudin" heru.safrudin



Dear B-Exceller,

Bisakah property columnheads pada Listbox diberi judul kolom ?

Mohon pencerahannya

Makasih

Heru Safrudin

<ymsgr:sendIM?heru.safrudin>; Heru SafrudinBISI,Heru Safrudin,YM online

Thu Sep 29, 2016 8:49 am (PDT) . Posted by:

"Darto Chandra"

Mohon petunjuk, bagaimana memunculkan nama hari di kolom warna
kuning pada file terlampir. Terima kasih Darto Chandra

Thu Sep 29, 2016 10:43 pm (PDT) . Posted by:

"odong nando"

di cell yang ingin anda munculkan hari, format cell dengan custom format cell menjadi "DDDD" tanpa tanda "".setelah itu manfaatkan fungsi DATE pada cell yang akan anda munculkan hari. br,

odong nando

Dari: "'Darto Chandra' d_c@gmx.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Kamis, 29 September 2016 21:33
Judul: [belajar-excel] Menampilkan nama hari sesuai tanggal [1 Attachment]

  Mohon petunjuk, bagaimana memunculkan nama hari di kolom warna kuning pada file terlampir. Terima kasih  Darto Chandra #yiv0930257931 #yiv0930257931 -- #yiv0930257931ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0930257931 #yiv0930257931ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0930257931 #yiv0930257931ygrp-mkp #yiv0930257931hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0930257931 #yiv0930257931ygrp-mkp #yiv0930257931ads {margin-bottom:10px;}#yiv0930257931 #yiv0930257931ygrp-mkp .yiv0930257931ad {padding:0 0;}#yiv0930257931 #yiv0930257931ygrp-mkp .yiv0930257931ad p {margin:0;}#yiv0930257931 #yiv0930257931ygrp-mkp .yiv0930257931ad a {color:#0000ff;text-decoration:none;}#yiv0930257931 #yiv0930257931ygrp-sponsor #yiv0930257931ygrp-lc {font-family:Arial;}#yiv0930257931 #yiv0930257931ygrp-sponsor #yiv0930257931ygrp-lc #yiv0930257931hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0930257931 #yiv0930257931ygrp-sponsor #yiv0930257931ygrp-lc .yiv0930257931ad {margin-bottom:10px;padding:0 0;}#yiv0930257931 #yiv0930257931actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0930257931 #yiv0930257931activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0930257931 #yiv0930257931activity span {font-weight:700;}#yiv0930257931 #yiv0930257931activity span:first-child {text-transform:uppercase;}#yiv0930257931 #yiv0930257931activity span a {color:#5085b6;text-decoration:none;}#yiv0930257931 #yiv0930257931activity span span {color:#ff7900;}#yiv0930257931 #yiv0930257931activity span .yiv0930257931underline {text-decoration:underline;}#yiv0930257931 .yiv0930257931attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0930257931 .yiv0930257931attach div a {text-decoration:none;}#yiv0930257931 .yiv0930257931attach img {border:none;padding-right:5px;}#yiv0930257931 .yiv0930257931attach label {display:block;margin-bottom:5px;}#yiv0930257931 .yiv0930257931attach label a {text-decoration:none;}#yiv0930257931 blockquote {margin:0 0 0 4px;}#yiv0930257931 .yiv0930257931bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0930257931 .yiv0930257931bold a {text-decoration:none;}#yiv0930257931 dd.yiv0930257931last p a {font-family:Verdana;font-weight:700;}#yiv0930257931 dd.yiv0930257931last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0930257931 dd.yiv0930257931last p span.yiv0930257931yshortcuts {margin-right:0;}#yiv0930257931 div.yiv0930257931attach-table div div a {text-decoration:none;}#yiv0930257931 div.yiv0930257931attach-table {width:400px;}#yiv0930257931 div.yiv0930257931file-title a, #yiv0930257931 div.yiv0930257931file-title a:active, #yiv0930257931 div.yiv0930257931file-title a:hover, #yiv0930257931 div.yiv0930257931file-title a:visited {text-decoration:none;}#yiv0930257931 div.yiv0930257931photo-title a, #yiv0930257931 div.yiv0930257931photo-title a:active, #yiv0930257931 div.yiv0930257931photo-title a:hover, #yiv0930257931 div.yiv0930257931photo-title a:visited {text-decoration:none;}#yiv0930257931 div#yiv0930257931ygrp-mlmsg #yiv0930257931ygrp-msg p a span.yiv0930257931yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0930257931 .yiv0930257931green {color:#628c2a;}#yiv0930257931 .yiv0930257931MsoNormal {margin:0 0 0 0;}#yiv0930257931 o {font-size:0;}#yiv0930257931 #yiv0930257931photos div {float:left;width:72px;}#yiv0930257931 #yiv0930257931photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv0930257931 #yiv0930257931photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0930257931 #yiv0930257931reco-category {font-size:77%;}#yiv0930257931 #yiv0930257931reco-desc {font-size:77%;}#yiv0930257931 .yiv0930257931replbq {margin:4px;}#yiv0930257931 #yiv0930257931ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0930257931 #yiv0930257931ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0930257931 #yiv0930257931ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0930257931 #yiv0930257931ygrp-mlmsg select, #yiv0930257931 input, #yiv0930257931 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0930257931 #yiv0930257931ygrp-mlmsg pre, #yiv0930257931 code {font:115% monospace;}#yiv0930257931 #yiv0930257931ygrp-mlmsg * {line-height:1.22em;}#yiv0930257931 #yiv0930257931ygrp-mlmsg #yiv0930257931logo {padding-bottom:10px;}#yiv0930257931 #yiv0930257931ygrp-msg p a {font-family:Verdana;}#yiv0930257931 #yiv0930257931ygrp-msg p#yiv0930257931attach-count span {color:#1E66AE;font-weight:700;}#yiv0930257931 #yiv0930257931ygrp-reco #yiv0930257931reco-head {color:#ff7900;font-weight:700;}#yiv0930257931 #yiv0930257931ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0930257931 #yiv0930257931ygrp-sponsor #yiv0930257931ov li a {font-size:130%;text-decoration:none;}#yiv0930257931 #yiv0930257931ygrp-sponsor #yiv0930257931ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0930257931 #yiv0930257931ygrp-sponsor #yiv0930257931ov ul {margin:0;padding:0 0 0 8px;}#yiv0930257931 #yiv0930257931ygrp-text {font-family:Georgia;}#yiv0930257931 #yiv0930257931ygrp-text p {margin:0 0 1em 0;}#yiv0930257931 #yiv0930257931ygrp-text tt {font-size:120%;}#yiv0930257931 #yiv0930257931ygrp-vital ul li:last-child {border-right:none !important;}#yiv0930257931

Thu Sep 29, 2016 11:41 pm (PDT) . Posted by:

"Susilo -"

Dear Darto

Coba pergunakan fungsi Text

= TEXT(H4,"DDD") <-- untuk menyebutkan hari dengan 3 digit
= TEXT(H4,"DDDD") <-- untuk menyebutkan hari secara lengkap

Terima kasih
Susilo

2016-09-29 21:33 GMT+07:00 'Darto Chandra' d_c@gmx.com [belajar-excel] <
belajar-excel@yahoogroups.com>:

>
>
> Mohon petunjuk, bagaimana memunculkan nama hari di kolom warna kuning pada
> file terlampir. Terima kasih
>
> Darto Chandra
>
>
>

Thu Sep 29, 2016 7:48 pm (PDT) . Posted by:

praztmath

Makasih mas toby, akan saya pelajari dan coba saya kembangkan..

Sent from Mail for Windows 10

From: Toby kenzo tobykenzo@yahoo.co.id [belajar-excel]

Thu Sep 29, 2016 11:41 pm (PDT) . Posted by:

cheivory_bridge

Yth. Para Master


Assalaamu'alaikum wr wb


Mohon pencerahannya dalam case terlampir ..


Terima kasih


Wassalaamu&#39;alaikum wr wb


Ari

Fri Sep 30, 2016 1:43 am (PDT) . Posted by:

"odong nando"

saya coba dengan menghilangkan spin button, dan di tambahkan filter
br,

odong nando

Dari: "cheivory_bridge@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Jumat, 30 September 2016 13:22
Judul: [belajar-excel] Case Row - amplop honor [1 Attachment]

  Yth. Para Master
Assalaamu'alaikum wr wb
Mohon pencerahannya dalam case terlampir ..
Terima kasih
Wassalaamu&#39;alaikum wr wb
Ari #yiv4674881636 #yiv4674881636 -- #yiv4674881636ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4674881636 #yiv4674881636ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4674881636 #yiv4674881636ygrp-mkp #yiv4674881636hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4674881636 #yiv4674881636ygrp-mkp #yiv4674881636ads {margin-bottom:10px;}#yiv4674881636 #yiv4674881636ygrp-mkp .yiv4674881636ad {padding:0 0;}#yiv4674881636 #yiv4674881636ygrp-mkp .yiv4674881636ad p {margin:0;}#yiv4674881636 #yiv4674881636ygrp-mkp .yiv4674881636ad a {color:#0000ff;text-decoration:none;}#yiv4674881636 #yiv4674881636ygrp-sponsor #yiv4674881636ygrp-lc {font-family:Arial;}#yiv4674881636 #yiv4674881636ygrp-sponsor #yiv4674881636ygrp-lc #yiv4674881636hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4674881636 #yiv4674881636ygrp-sponsor #yiv4674881636ygrp-lc .yiv4674881636ad {margin-bottom:10px;padding:0 0;}#yiv4674881636 #yiv4674881636actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4674881636 #yiv4674881636activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4674881636 #yiv4674881636activity span {font-weight:700;}#yiv4674881636 #yiv4674881636activity span:first-child {text-transform:uppercase;}#yiv4674881636 #yiv4674881636activity span a {color:#5085b6;text-decoration:none;}#yiv4674881636 #yiv4674881636activity span span {color:#ff7900;}#yiv4674881636 #yiv4674881636activity span .yiv4674881636underline {text-decoration:underline;}#yiv4674881636 .yiv4674881636attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4674881636 .yiv4674881636attach div a {text-decoration:none;}#yiv4674881636 .yiv4674881636attach img {border:none;padding-right:5px;}#yiv4674881636 .yiv4674881636attach label {display:block;margin-bottom:5px;}#yiv4674881636 .yiv4674881636attach label a {text-decoration:none;}#yiv4674881636 blockquote {margin:0 0 0 4px;}#yiv4674881636 .yiv4674881636bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4674881636 .yiv4674881636bold a {text-decoration:none;}#yiv4674881636 dd.yiv4674881636last p a {font-family:Verdana;font-weight:700;}#yiv4674881636 dd.yiv4674881636last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4674881636 dd.yiv4674881636last p span.yiv4674881636yshortcuts {margin-right:0;}#yiv4674881636 div.yiv4674881636attach-table div div a {text-decoration:none;}#yiv4674881636 div.yiv4674881636attach-table {width:400px;}#yiv4674881636 div.yiv4674881636file-title a, #yiv4674881636 div.yiv4674881636file-title a:active, #yiv4674881636 div.yiv4674881636file-title a:hover, #yiv4674881636 div.yiv4674881636file-title a:visited {text-decoration:none;}#yiv4674881636 div.yiv4674881636photo-title a, #yiv4674881636 div.yiv4674881636photo-title a:active, #yiv4674881636 div.yiv4674881636photo-title a:hover, #yiv4674881636 div.yiv4674881636photo-title a:visited {text-decoration:none;}#yiv4674881636 div#yiv4674881636ygrp-mlmsg #yiv4674881636ygrp-msg p a span.yiv4674881636yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4674881636 .yiv4674881636green {color:#628c2a;}#yiv4674881636 .yiv4674881636MsoNormal {margin:0 0 0 0;}#yiv4674881636 o {font-size:0;}#yiv4674881636 #yiv4674881636photos div {float:left;width:72px;}#yiv4674881636 #yiv4674881636photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv4674881636 #yiv4674881636photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4674881636 #yiv4674881636reco-category {font-size:77%;}#yiv4674881636 #yiv4674881636reco-desc {font-size:77%;}#yiv4674881636 .yiv4674881636replbq {margin:4px;}#yiv4674881636 #yiv4674881636ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4674881636 #yiv4674881636ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4674881636 #yiv4674881636ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4674881636 #yiv4674881636ygrp-mlmsg select, #yiv4674881636 input, #yiv4674881636 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4674881636 #yiv4674881636ygrp-mlmsg pre, #yiv4674881636 code {font:115% monospace;}#yiv4674881636 #yiv4674881636ygrp-mlmsg * {line-height:1.22em;}#yiv4674881636 #yiv4674881636ygrp-mlmsg #yiv4674881636logo {padding-bottom:10px;}#yiv4674881636 #yiv4674881636ygrp-msg p a {font-family:Verdana;}#yiv4674881636 #yiv4674881636ygrp-msg p#yiv4674881636attach-count span {color:#1E66AE;font-weight:700;}#yiv4674881636 #yiv4674881636ygrp-reco #yiv4674881636reco-head {color:#ff7900;font-weight:700;}#yiv4674881636 #yiv4674881636ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4674881636 #yiv4674881636ygrp-sponsor #yiv4674881636ov li a {font-size:130%;text-decoration:none;}#yiv4674881636 #yiv4674881636ygrp-sponsor #yiv4674881636ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4674881636 #yiv4674881636ygrp-sponsor #yiv4674881636ov ul {margin:0;padding:0 0 0 8px;}#yiv4674881636 #yiv4674881636ygrp-text {font-family:Georgia;}#yiv4674881636 #yiv4674881636ygrp-text p {margin:0 0 1em 0;}#yiv4674881636 #yiv4674881636ygrp-text tt {font-size:120%;}#yiv4674881636 #yiv4674881636ygrp-vital ul li:last-child {border-right:none !important;}#yiv4674881636

============================================================
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
---------------------------------------------------------------------

Tidak ada komentar:

Poskan Komentar