[belajar-excel] Digest Number 3988

Milis Belajar Microsoft Excel Group

4 Messages

Digest #3988

1

mengarahkan ke sheet tertentu ketika file excel dibuka by "farud oke"

2a

Rumus Deskripsi by "heru mulyono"

2b

Bls: [belajar-excel] Rumus Deskripsi [1 Attachment] by "Toby kenzo" tobykenzo

3a

Bls: [belajar-excel] merubah tgl teks kem numerik [1 Attachment] by "Toby kenzo" tobykenzo

Messages

1

mengarahkan ke sheet tertentu ketika file excel dibuka

Sun Oct 9, 2016 5:34 pm (PDT) . Posted by:

"farud oke"

Assalamualaikum wr.wb
mohon bantuan para master sekalian,saya punya file dan sudah diberi scrip
VBA di workbook seperti ini

Private Sub WorkBook_Open()

Application.Visible = False

UserForm1.Show

Application.Visible = True

End Sub

karena rencana form tersebut yg akan saya jadikan menu utama.

yang ingin saya tanyakan,setiap file ini mau dibuka saya ingin mengarahkan
langsung ke sheet 1 karena di sheet 1 ada penjelasan untuk mengaktifkan
macro.saya sertakan contohnya juga

Atas bantuan para master sekalian saya sampaikan terimakasih

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

2a

Rumus Deskripsi

Sun Oct 9, 2016 9:11 pm (PDT) . Posted by:

"heru mulyono"

Yth,
Master Excel
Mohon bantuan atas permasalahan saya. File terlampir
Terimakasih

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

2b

Bls: [belajar-excel] Rumus Deskripsi [1 Attachment]

Mon Oct 10, 2016 1:03 am (PDT) . Posted by:

"Toby kenzo" tobykenzo

Dear Mulyono,
Sepertinya Case ini pernah ada sebelumnya, coba kamu buka2 lagi file2nya yang terdahulu...
TerimaKasih.

Pada Senin, 10 Oktober 2016 11:11, "heru mulyono hmulyono24@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Yth,Master ExcelMohon bantuan atas permasalahan saya. File terlampirTerimakasih #yiv5375154316 #yiv5375154316 -- #yiv5375154316ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5375154316 #yiv5375154316ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5375154316 #yiv5375154316ygrp-mkp #yiv5375154316hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5375154316 #yiv5375154316ygrp-mkp #yiv5375154316ads {margin-bottom:10px;}#yiv5375154316 #yiv5375154316ygrp-mkp .yiv5375154316ad {padding:0 0;}#yiv5375154316 #yiv5375154316ygrp-mkp .yiv5375154316ad p {margin:0;}#yiv5375154316 #yiv5375154316ygrp-mkp .yiv5375154316ad a {color:#0000ff;text-decoration:none;}#yiv5375154316 #yiv5375154316ygrp-sponsor #yiv5375154316ygrp-lc {font-family:Arial;}#yiv5375154316 #yiv5375154316ygrp-sponsor #yiv5375154316ygrp-lc #yiv5375154316hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5375154316 #yiv5375154316ygrp-sponsor #yiv5375154316ygrp-lc .yiv5375154316ad {margin-bottom:10px;padding:0 0;}#yiv5375154316 #yiv5375154316actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5375154316 #yiv5375154316activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5375154316 #yiv5375154316activity span {font-weight:700;}#yiv5375154316 #yiv5375154316activity span:first-child {text-transform:uppercase;}#yiv5375154316 #yiv5375154316activity span a {color:#5085b6;text-decoration:none;}#yiv5375154316 #yiv5375154316activity span span {color:#ff7900;}#yiv5375154316 #yiv5375154316activity span .yiv5375154316underline {text-decoration:underline;}#yiv5375154316 .yiv5375154316attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5375154316 .yiv5375154316attach div a {text-decoration:none;}#yiv5375154316 .yiv5375154316attach img {border:none;padding-right:5px;}#yiv5375154316 .yiv5375154316attach label {display:block;margin-bottom:5px;}#yiv5375154316 .yiv5375154316attach label a {text-decoration:none;}#yiv5375154316 blockquote {margin:0 0 0 4px;}#yiv5375154316 .yiv5375154316bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5375154316 .yiv5375154316bold a {text-decoration:none;}#yiv5375154316 dd.yiv5375154316last p a {font-family:Verdana;font-weight:700;}#yiv5375154316 dd.yiv5375154316last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5375154316 dd.yiv5375154316last p span.yiv5375154316yshortcuts {margin-right:0;}#yiv5375154316 div.yiv5375154316attach-table div div a {text-decoration:none;}#yiv5375154316 div.yiv5375154316attach-table {width:400px;}#yiv5375154316 div.yiv5375154316file-title a, #yiv5375154316 div.yiv5375154316file-title a:active, #yiv5375154316 div.yiv5375154316file-title a:hover, #yiv5375154316 div.yiv5375154316file-title a:visited {text-decoration:none;}#yiv5375154316 div.yiv5375154316photo-title a, #yiv5375154316 div.yiv5375154316photo-title a:active, #yiv5375154316 div.yiv5375154316photo-title a:hover, #yiv5375154316 div.yiv5375154316photo-title a:visited {text-decoration:none;}#yiv5375154316 div#yiv5375154316ygrp-mlmsg #yiv5375154316ygrp-msg p a span.yiv5375154316yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5375154316 .yiv5375154316green {color:#628c2a;}#yiv5375154316 .yiv5375154316MsoNormal {margin:0 0 0 0;}#yiv5375154316 o {font-size:0;}#yiv5375154316 #yiv5375154316photos div {float:left;width:72px;}#yiv5375154316 #yiv5375154316photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv5375154316 #yiv5375154316photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5375154316 #yiv5375154316reco-category {font-size:77%;}#yiv5375154316 #yiv5375154316reco-desc {font-size:77%;}#yiv5375154316 .yiv5375154316replbq {margin:4px;}#yiv5375154316 #yiv5375154316ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5375154316 #yiv5375154316ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5375154316 #yiv5375154316ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5375154316 #yiv5375154316ygrp-mlmsg select, #yiv5375154316 input, #yiv5375154316 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5375154316 #yiv5375154316ygrp-mlmsg pre, #yiv5375154316 code {font:115% monospace;}#yiv5375154316 #yiv5375154316ygrp-mlmsg * {line-height:1.22em;}#yiv5375154316 #yiv5375154316ygrp-mlmsg #yiv5375154316logo {padding-bottom:10px;}#yiv5375154316 #yiv5375154316ygrp-msg p a {font-family:Verdana;}#yiv5375154316 #yiv5375154316ygrp-msg p#yiv5375154316attach-count span {color:#1E66AE;font-weight:700;}#yiv5375154316 #yiv5375154316ygrp-reco #yiv5375154316reco-head {color:#ff7900;font-weight:700;}#yiv5375154316 #yiv5375154316ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5375154316 #yiv5375154316ygrp-sponsor #yiv5375154316ov li a {font-size:130%;text-decoration:none;}#yiv5375154316 #yiv5375154316ygrp-sponsor #yiv5375154316ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5375154316 #yiv5375154316ygrp-sponsor #yiv5375154316ov ul {margin:0;padding:0 0 0 8px;}#yiv5375154316 #yiv5375154316ygrp-text {font-family:Georgia;}#yiv5375154316 #yiv5375154316ygrp-text p {margin:0 0 1em 0;}#yiv5375154316 #yiv5375154316ygrp-text tt {font-size:120%;}#yiv5375154316 #yiv5375154316ygrp-vital ul li:last-child {border-right:none !important;}#yiv5375154316

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

3a

Bls: [belajar-excel] merubah tgl teks kem numerik [1 Attachment]

Mon Oct 10, 2016 12:52 am (PDT) . Posted by:

"Toby kenzo" tobykenzo

Dear Roheandi,
Di tambahkan 3 pada formula Find nya:
=DATE(1900+100*(RIGHT(A1,2)*1<31)+RIGHT(A1,2),(FIND(MID(A1,4,3),"JANFEBMARAPRMAYJUNJULAUGSEPOCTNOVDEC")+3)/3,LEFT(A1,2))
TerimaKasih.

Pada Minggu, 9 Oktober 2016 9:30, "roy sumarna rohendi_2000@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  assalamu alaikum
mohon pencerahan materi telah diajarkan mr kid tentang merubah tanggal tek ke numerik tentang pembagi 3 tiga karena nilai bulannya jadi turun satu.. terima kasih
wasalam
rohaendi
#yiv0103917276 #yiv0103917276 -- #yiv0103917276ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0103917276 #yiv0103917276ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0103917276 #yiv0103917276ygrp-mkp #yiv0103917276hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0103917276 #yiv0103917276ygrp-mkp #yiv0103917276ads {margin-bottom:10px;}#yiv0103917276 #yiv0103917276ygrp-mkp .yiv0103917276ad {padding:0 0;}#yiv0103917276 #yiv0103917276ygrp-mkp .yiv0103917276ad p {margin:0;}#yiv0103917276 #yiv0103917276ygrp-mkp .yiv0103917276ad a {color:#0000ff;text-decoration:none;}#yiv0103917276 #yiv0103917276ygrp-sponsor #yiv0103917276ygrp-lc {font-family:Arial;}#yiv0103917276 #yiv0103917276ygrp-sponsor #yiv0103917276ygrp-lc #yiv0103917276hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0103917276 #yiv0103917276ygrp-sponsor #yiv0103917276ygrp-lc .yiv0103917276ad {margin-bottom:10px;padding:0 0;}#yiv0103917276 #yiv0103917276actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0103917276 #yiv0103917276activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0103917276 #yiv0103917276activity span {font-weight:700;}#yiv0103917276 #yiv0103917276activity span:first-child {text-transform:uppercase;}#yiv0103917276 #yiv0103917276activity span a {color:#5085b6;text-decoration:none;}#yiv0103917276 #yiv0103917276activity span span {color:#ff7900;}#yiv0103917276 #yiv0103917276activity span .yiv0103917276underline {text-decoration:underline;}#yiv0103917276 .yiv0103917276attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0103917276 .yiv0103917276attach div a {text-decoration:none;}#yiv0103917276 .yiv0103917276attach img {border:none;padding-right:5px;}#yiv0103917276 .yiv0103917276attach label {display:block;margin-bottom:5px;}#yiv0103917276 .yiv0103917276attach label a {text-decoration:none;}#yiv0103917276 blockquote {margin:0 0 0 4px;}#yiv0103917276 .yiv0103917276bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0103917276 .yiv0103917276bold a {text-decoration:none;}#yiv0103917276 dd.yiv0103917276last p a {font-family:Verdana;font-weight:700;}#yiv0103917276 dd.yiv0103917276last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0103917276 dd.yiv0103917276last p span.yiv0103917276yshortcuts {margin-right:0;}#yiv0103917276 div.yiv0103917276attach-table div div a {text-decoration:none;}#yiv0103917276 div.yiv0103917276attach-table {width:400px;}#yiv0103917276 div.yiv0103917276file-title a, #yiv0103917276 div.yiv0103917276file-title a:active, #yiv0103917276 div.yiv0103917276file-title a:hover, #yiv0103917276 div.yiv0103917276file-title a:visited {text-decoration:none;}#yiv0103917276 div.yiv0103917276photo-title a, #yiv0103917276 div.yiv0103917276photo-title a:active, #yiv0103917276 div.yiv0103917276photo-title a:hover, #yiv0103917276 div.yiv0103917276photo-title a:visited {text-decoration:none;}#yiv0103917276 div#yiv0103917276ygrp-mlmsg #yiv0103917276ygrp-msg p a span.yiv0103917276yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0103917276 .yiv0103917276green {color:#628c2a;}#yiv0103917276 .yiv0103917276MsoNormal {margin:0 0 0 0;}#yiv0103917276 o {font-size:0;}#yiv0103917276 #yiv0103917276photos div {float:left;width:72px;}#yiv0103917276 #yiv0103917276photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv0103917276 #yiv0103917276photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0103917276 #yiv0103917276reco-category {font-size:77%;}#yiv0103917276 #yiv0103917276reco-desc {font-size:77%;}#yiv0103917276 .yiv0103917276replbq {margin:4px;}#yiv0103917276 #yiv0103917276ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0103917276 #yiv0103917276ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0103917276 #yiv0103917276ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0103917276 #yiv0103917276ygrp-mlmsg select, #yiv0103917276 input, #yiv0103917276 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0103917276 #yiv0103917276ygrp-mlmsg pre, #yiv0103917276 code {font:115% monospace;}#yiv0103917276 #yiv0103917276ygrp-mlmsg * {line-height:1.22em;}#yiv0103917276 #yiv0103917276ygrp-mlmsg #yiv0103917276logo {padding-bottom:10px;}#yiv0103917276 #yiv0103917276ygrp-msg p a {font-family:Verdana;}#yiv0103917276 #yiv0103917276ygrp-msg p#yiv0103917276attach-count span {color:#1E66AE;font-weight:700;}#yiv0103917276 #yiv0103917276ygrp-reco #yiv0103917276reco-head {color:#ff7900;font-weight:700;}#yiv0103917276 #yiv0103917276ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0103917276 #yiv0103917276ygrp-sponsor #yiv0103917276ov li a {font-size:130%;text-decoration:none;}#yiv0103917276 #yiv0103917276ygrp-sponsor #yiv0103917276ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0103917276 #yiv0103917276ygrp-sponsor #yiv0103917276ov ul {margin:0;padding:0 0 0 8px;}#yiv0103917276 #yiv0103917276ygrp-text {font-family:Georgia;}#yiv0103917276 #yiv0103917276ygrp-text p {margin:0 0 1em 0;}#yiv0103917276 #yiv0103917276ygrp-text tt {font-size:120%;}#yiv0103917276 #yiv0103917276ygrp-vital ul li:last-child {border-right:none !important;}#yiv0103917276

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

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

Visit Your Group

• New Members 4

• Privacy • Unsubscribe • Terms of Use