Messages
Mon Jul 29, 2019 10:44 pm (PDT) . Posted by:
Wa'alaikum salaam,
File terlampir menggunakan protected sheet tanpa menggunakan macro.
Apakah sudah sesuai yang diinginkan?
Wassalam
-zainul
Sent from Mail for Windows 10
From: HAIRUL ALAM ha_mj76@yahoo.co.id [belajar-excel]
Sent: Tuesday, July 30, 2019 7:47 AM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] menampilkan hasil tanpa formula di excel dengan script macro
Salam
Para Master
mohon pencerahahannya dengan code script macro menampilkan hasil formula tanpa menampilkan rumus di cell excel, seperti file terlampir
Terimakasih
Assalamualaikum
Hairul Alam
Mon Jul 29, 2019 11:56 pm (PDT) . Posted by:
Kalau hanya sekedar look up, terlalu ribet kalau harus memakai VBA, itu
menurut saya hehe.
Kalau kasus seperti ini masih bisa optimalkan pivot, terus tinggal di
tambahin slicer untuk mempercantik.
1. blok semua table, tekan ctrl + T
[image: image.png]
2. klik my table has header
[image: image.png]
3. tetap di blok table nya, terus pilih insert > pivot table
[image: image.png]
5. Selanjut nya tinggal ikut conth nya, Untuk Slicer, ada di tab Analyse >
Insert Slicer > klik "No"
[image: image.png]
6. Langkah selanjutnya tinggal inpu t data dan refresh data
On Tue, Jul 30, 2019 at 7:47 AM HAIRUL ALAM ha_mj76@yahoo.co.id
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:
>
>
> Salam
> Para Master
>
> mohon pencerahahannya dengan code script macro menampilkan hasil formula
> tanpa menampilkan rumus di cell excel, seperti file terlampir
>
> Terimakasih
>
> Assalamualaikum
>
> Hairul Alam
>
>
>
Tue Jul 30, 2019 12:03 am (PDT) . Posted by:
Coba ganti codenya spt ini :Sheets("b").Range("c4").Value2 = Evaluate("=VLOOKUP(B4,a!B4:D6,2,FALSE)")
Salam,HK
Pada Selasa, 30 Juli 2019 07.47.34 WIB, HAIRUL ALAM ha_mj76@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> menulis:
SalamPara Master
mohon pencerahahannya dengan code script macro menampilkan hasil formula tanpa menampilkan rumus di cell excel, seperti file terlampir
Terimakasih
Assalamualaikum
Hairul Alam
Tue Jul 30, 2019 1:45 am (PDT) . Posted by:
Terimakasih
Maaf yang saya maksud untuk hasilnya tidak muncul formula tapi hasil dari vlookup nya saja seperti yang terlampir sebelumnya dan itu cuma 1 contoh dan jika banyak akan tetap hasil saja
Terimakasih
Pada Selasa, 30 Juli 2019 12.44.47 WIB, Zainul Ulum zainul_ulum@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:
Wa'alaikum salaam,
File terlampir menggunakan protected sheet tanpa menggunakan macro.
Apakah sudah sesuai yang diinginkan?
Wassalam
-zainul
Sent from Mail for Windows 10
From: HAIRUL ALAM ha_mj76@yahoo.co.id [belajar-excel]
Sent: Tuesday, July 30, 2019 7:47 AM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] menampilkan hasil tanpa formula di excel dengan script macro
Salam
Para Master
mohon pencerahahannya dengan code script macro menampilkan hasil formula tanpa menampilkan rumus di cell excel, seperti file terlampir
Terimakasih
Assalamualaikum
Hairul Alam
#yiv0658632402 #yiv0658632402 -- #yiv0658632402ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0658632402 #yiv0658632402ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0658632402 #yiv0658632402ygrp-mkp #yiv0658632402hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0658632402 #yiv0658632402ygrp-mkp #yiv0658632402ads {margin-bottom:10px;}#yiv0658632402 #yiv0658632402ygrp-mkp .yiv0658632402ad {padding:0 0;}#yiv0658632402 #yiv0658632402ygrp-mkp .yiv0658632402ad p {margin:0;}#yiv0658632402 #yiv0658632402ygrp-mkp .yiv0658632402ad a {color:#0000ff;text-decoration:none;}#yiv0658632402 #yiv0658632402ygrp-sponsor #yiv0658632402ygrp-lc {font-family:Arial;}#yiv0658632402 #yiv0658632402ygrp-sponsor #yiv0658632402ygrp-lc #yiv0658632402hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0658632402 #yiv0658632402ygrp-sponsor #yiv0658632402ygrp-lc .yiv0658632402ad {margin-bottom:10px;padding:0 0;}#yiv0658632402 #yiv0658632402actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0658632402 #yiv0658632402activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0658632402 #yiv0658632402activity span {font-weight:700;}#yiv0658632402 #yiv0658632402activity span:first-child {text-transform:uppercase;}#yiv0658632402 #yiv0658632402activity span a {color:#5085b6;text-decoration:none;}#yiv0658632402 #yiv0658632402activity span span {color:#ff7900;}#yiv0658632402 #yiv0658632402activity span .yiv0658632402underline {text-decoration:underline;}#yiv0658632402 .yiv0658632402attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0658632402 .yiv0658632402attach div a {text-decoration:none;}#yiv0658632402 .yiv0658632402attach img {border:none;padding-right:5px;}#yiv0658632402 .yiv0658632402attach label {display:block;margin-bottom:5px;}#yiv0658632402 .yiv0658632402attach label a {text-decoration:none;}#yiv0658632402 blockquote {margin:0 0 0 4px;}#yiv0658632402 .yiv0658632402bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0658632402 .yiv0658632402bold a {text-decoration:none;}#yiv0658632402 dd.yiv0658632402last p a {font-family:Verdana;font-weight:700;}#yiv0658632402 dd.yiv0658632402last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0658632402 dd.yiv0658632402last p span..yiv0658632402yshortcuts {margin-right:0;}#yiv0658632402 div.yiv0658632402attach-table div div a {text-decoration:none;}#yiv0658632402 div.yiv0658632402attach-table {width:400px;}#yiv0658632402 div.yiv0658632402file-title a, #yiv0658632402 div.yiv0658632402file-title a:active, #yiv0658632402 div.yiv0658632402file-title a:hover, #yiv0658632402 div.yiv0658632402file-title a:visited {text-decoration:none;}#yiv0658632402 div.yiv0658632402photo-title a, #yiv0658632402 div.yiv0658632402photo-title a:active, #yiv0658632402 div..yiv0658632402photo-title a:hover, #yiv0658632402 div.yiv0658632402photo-title a:visited {text-decoration:none;}#yiv0658632402 div#yiv0658632402ygrp-mlmsg #yiv0658632402ygrp-msg p a span.yiv0658632402yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0658632402 .yiv0658632402green {color:#628c2a;}#yiv0658632402 .yiv0658632402MsoNormal {margin:0 0 0 0;}#yiv0658632402 o {font-size:0;}#yiv0658632402 #yiv0658632402photos div {float:left;width:72px;}#yiv0658632402 #yiv0658632402photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv0658632402 #yiv0658632402photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0658632402 #yiv0658632402reco-category {font-size:77%;}#yiv0658632402 #yiv0658632402reco-desc {font-size:77%;}#yiv0658632402 .yiv0658632402replbq {margin:4px;}#yiv0658632402 #yiv0658632402ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0658632402 #yiv0658632402ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0658632402 #yiv0658632402ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0658632402 #yiv0658632402ygrp-mlmsg select, #yiv0658632402 input, #yiv0658632402 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0658632402 #yiv0658632402ygrp-mlmsg pre, #yiv0658632402 code {font:115% monospace;}#yiv0658632402 #yiv0658632402ygrp-mlmsg * {line-height:1.22em;}#yiv0658632402 #yiv0658632402ygrp-mlmsg #yiv0658632402logo {padding-bottom:10px;}#yiv0658632402 #yiv0658632402ygrp-msg p a {font-family:Verdana;}#yiv0658632402 #yiv0658632402ygrp-msg p#yiv0658632402attach-count span {color:#1E66AE;font-weight:700;}#yiv0658632402 #yiv0658632402ygrp-reco #yiv0658632402reco-head {color:#ff7900;font-weight:700;}#yiv0658632402 #yiv0658632402ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0658632402 #yiv0658632402ygrp-sponsor #yiv0658632402ov li a {font-size:130%;text-decoration:none;}#yiv0658632402 #yiv0658632402ygrp-sponsor #yiv0658632402ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0658632402 #yiv0658632402ygrp-sponsor #yiv0658632402ov ul {margin:0;padding:0 0 0 8px;}#yiv0658632402 #yiv0658632402ygrp-text {font-family:Georgia;}#yiv0658632402 #yiv0658632402ygrp-text p {margin:0 0 1em 0;}#yiv0658632402 #yiv0658632402ygrp-text tt {font-size:120%;}#yiv0658632402 #yiv0658632402ygrp-vital ul li:last-child {border-right:none !important;}#yiv0658632402
Tue Jul 30, 2019 2:13 am (PDT) . Posted by:
Kalo pakai macro, bisa menggunakan code di bawah:
Sub v()
Const RUMUS_C4 As String = "=VLOOKUP(B4,a!$B$4:$D$6,2,FALSE)"
Const RUMUS_D4 As String = "=VLOOKUP(B4,a!$B$4:$D$6,3,FALSE)"
Const KOLOM_ISIAN As String = "B", KOLOM_TANGGAL As String = "C", KOLOM_JUMLAH As String = "D"
Const barisAwal As Long = 4
Const barisMax As Long = 10000
Const shtTarget As String = "b"
With Worksheets(shtTarget)
'mencari baris input terakhir
Dim n As Long
n = .Range(KOLOM_ISIAN & barisMax).End(xlUp).Row
'tentukan range tanggal (kolom c) dan range jumlah (kolom d)
Dim rgTanggal As Range, rgJumlah As Range
Set rgTanggal = .Range(KOLOM_TANGGAL & barisAwal & ":" & KOLOM_TANGGAL & n)
Set rgJumlah = .Range(KOLOM_JUMLAH & barisAwal & ":" & KOLOM_JUMLAH & n)
'mengisi formula
rgTanggal.Formula = RUMUS_C4
rgJumlah.Formula = RUMUS_D4
'rubah menjadi value
rgTanggal.Value = rgTanggal.Value
rgJumlah.Value = rgJumlah.Value
End With
End Sub
Tue Jul 30, 2019 5:42 am (PDT) . Posted by:
Terimakasih Ilmunya Master
Pada Selasa, 30 Juli 2019 16.14.14 WIB, zainul_ulum@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:
Kalo pakai macro, bisa menggunakan code di bawah:
Sub v() Const RUMUS_C4 As String = "=VLOOKUP(B4,a!$B$4:$D$6,2,FALSE)" Const RUMUS_D4 As String = "=VLOOKUP(B4,a!$B$4:$D$6,3,FALSE)" Const KOLOM_ISIAN As String = "B", KOLOM_TANGGAL As String = "C", KOLOM_JUMLAH As String = "D" Const barisAwal As Long = 4 Const barisMax As Long = 10000 Const shtTarget As String = "b" With Worksheets(shtTarget) 'mencari baris input terakhir Dim n As Long n = .Range(KOLOM_ISIAN & barisMax).End(xlUp).Row 'tentukan range tanggal (kolom c) dan range jumlah (kolom d) Dim rgTanggal As Range, rgJumlah As Range Set rgTanggal = .Range(KOLOM_TANGGAL & barisAwal & ":" & KOLOM_TANGGAL & n) Set rgJumlah = .Range(KOLOM_JUMLAH & barisAwal & ":" & KOLOM_JUMLAH & n) 'mengisi formula rgTanggal.Formula = RUMUS_C4 rgJumlah.Formula = RUMUS_D4 'rubah menjadi value rgTanggal.Value = rgTanggal.Value rgJumlah.Value = rgJumlah.Value End With End Sub
#yiv5631128258 #yiv5631128258 -- #yiv5631128258ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5631128258 #yiv5631128258ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5631128258 #yiv5631128258ygrp-mkp #yiv5631128258hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5631128258 #yiv5631128258ygrp-mkp #yiv5631128258ads {margin-bottom:10px;}#yiv5631128258 #yiv5631128258ygrp-mkp .yiv5631128258ad {padding:0 0;}#yiv5631128258 #yiv5631128258ygrp-mkp .yiv5631128258ad p {margin:0;}#yiv5631128258 #yiv5631128258ygrp-mkp .yiv5631128258ad a {color:#0000ff;text-decoration:none;}#yiv5631128258 #yiv5631128258ygrp-sponsor #yiv5631128258ygrp-lc {font-family:Arial;}#yiv5631128258 #yiv5631128258ygrp-sponsor #yiv5631128258ygrp-lc #yiv5631128258hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5631128258 #yiv5631128258ygrp-sponsor #yiv5631128258ygrp-lc .yiv5631128258ad {margin-bottom:10px;padding:0 0;}#yiv5631128258 #yiv5631128258actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5631128258 #yiv5631128258activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5631128258 #yiv5631128258activity span {font-weight:700;}#yiv5631128258 #yiv5631128258activity span:first-child {text-transform:uppercase;}#yiv5631128258 #yiv5631128258activity span a {color:#5085b6;text-decoration:none;}#yiv5631128258 #yiv5631128258activity span span {color:#ff7900;}#yiv5631128258 #yiv5631128258activity span .yiv5631128258underline {text-decoration:underline;}#yiv5631128258 .yiv5631128258attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5631128258 .yiv5631128258attach div a {text-decoration:none;}#yiv5631128258 .yiv5631128258attach img {border:none;padding-right:5px;}#yiv5631128258 .yiv5631128258attach label {display:block;margin-bottom:5px;}#yiv5631128258 .yiv5631128258attach label a {text-decoration:none;}#yiv5631128258 blockquote {margin:0 0 0 4px;}#yiv5631128258 .yiv5631128258bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5631128258 .yiv5631128258bold a {text-decoration:none;}#yiv5631128258 dd.yiv5631128258last p a {font-family:Verdana;font-weight:700;}#yiv5631128258 dd.yiv5631128258last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5631128258 dd.yiv5631128258last p span.yiv5631128258yshortcuts {margin-right:0;}#yiv5631128258 div.yiv5631128258attach-table div div a {text-decoration:none;}#yiv5631128258 div.yiv5631128258attach-table {width:400px;}#yiv5631128258 div.yiv5631128258file-title a, #yiv5631128258 div.yiv5631128258file-title a:active, #yiv5631128258 div.yiv5631128258file-title a:hover, #yiv5631128258 div.yiv5631128258file-title a:visited {text-decoration:none;}#yiv5631128258 div.yiv5631128258photo-title a, #yiv5631128258 div.yiv5631128258photo-title a:active, #yiv5631128258 div.yiv5631128258photo-title a:hover, #yiv5631128258 div.yiv5631128258photo-title a:visited {text-decoration:none;}#yiv5631128258 div#yiv5631128258ygrp-mlmsg #yiv5631128258ygrp-msg p a span.yiv5631128258yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5631128258 .yiv5631128258green {color:#628c2a;}#yiv5631128258 .yiv5631128258MsoNormal {margin:0 0 0 0;}#yiv5631128258 o {font-size:0;}#yiv5631128258 #yiv5631128258photos div {float:left;width:72px;}#yiv5631128258 #yiv5631128258photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv5631128258 #yiv5631128258photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5631128258 #yiv5631128258reco-category {font-size:77%;}#yiv5631128258 #yiv5631128258reco-desc {font-size:77%;}#yiv5631128258 .yiv5631128258replbq {margin:4px;}#yiv5631128258 #yiv5631128258ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5631128258 #yiv5631128258ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5631128258 #yiv5631128258ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5631128258 #yiv5631128258ygrp-mlmsg select, #yiv5631128258 input, #yiv5631128258 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5631128258 #yiv5631128258ygrp-mlmsg pre, #yiv5631128258 code {font:115% monospace;}#yiv5631128258 #yiv5631128258ygrp-mlmsg * {line-height:1..22em;}#yiv5631128258 #yiv5631128258ygrp-mlmsg #yiv5631128258logo {padding-bottom:10px;}#yiv5631128258 #yiv5631128258ygrp-msg p a {font-family:Verdana;}#yiv5631128258 #yiv5631128258ygrp-msg p#yiv5631128258attach-count span {color:#1E66AE;font-weight:700;}#yiv5631128258 #yiv5631128258ygrp-reco #yiv5631128258reco-head {color:#ff7900;font-weight:700;}#yiv5631128258 #yiv5631128258ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5631128258 #yiv5631128258ygrp-sponsor #yiv5631128258ov li a {font-size:130%;text-decoration:none;}#yiv5631128258 #yiv5631128258ygrp-sponsor #yiv5631128258ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5631128258 #yiv5631128258ygrp-sponsor #yiv5631128258ov ul {margin:0;padding:0 0 0 8px;}#yiv5631128258 #yiv5631128258ygrp-text {font-family:Georgia;}#yiv5631128258 #yiv5631128258ygrp-text p {margin:0 0 1em 0;}#yiv5631128258 #yiv5631128258ygrp-text tt {font-size:120%;}#yiv5631128258 #yiv5631128258ygrp-vital ul li:last-child {border-right:none !important;}#yiv5631128258
Mon Jul 29, 2019 11:56 pm (PDT) . Posted by:
Terima kasih sekali atas bantuannya... namun ada yang menurut saya masih kurang contoh Rp. 131.000,00 terbilangnya seratus tiga puluh seribu Rupiah, menurut saya terbilangnya Seratus Tiga Puluh satu Ribu Rupiah.... mohon masukannya..
On Thursday, July 25, 2019, 11:52:52 AM GMT+7, Zainul Ulum zainul_ulum@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:
Mas Imam,
Sudah aku tulis di https://cadex.co/2017/10/15/xls-pmg-08-fungsi-terbilang-di-excel-tanpa-macro-versi-mega-formula-rev-03/
Untuk penjelasannya.
Terimakasih,
-zainul
Sent from Mail for Windows 10
From: imam cahyo yuwono chyywn@yahoo.com [belajar-excel]
Sent: Thursday, July 25, 2019 10:12 AM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Mega Formula terbilang (terbilang tanpa macro)
Dear para expert mohon bantuan penjelasan tentang formula terbilang dibawah ini
mohon pencerahan fungsi formula dan perbaikan pada formula yang ada
Terima kasih
#yiv3817558797 #yiv3817558797 -- #yiv3817558797ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3817558797 #yiv3817558797ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3817558797 #yiv3817558797ygrp-mkp #yiv3817558797hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3817558797 #yiv3817558797ygrp-mkp #yiv3817558797ads {margin-bottom:10px;}#yiv3817558797 #yiv3817558797ygrp-mkp .yiv3817558797ad {padding:0 0;}#yiv3817558797 #yiv3817558797ygrp-mkp .yiv3817558797ad p {margin:0;}#yiv3817558797 #yiv3817558797ygrp-mkp .yiv3817558797ad a {color:#0000ff;text-decoration:none;}#yiv3817558797 #yiv3817558797ygrp-sponsor #yiv3817558797ygrp-lc {font-family:Arial;}#yiv3817558797 #yiv3817558797ygrp-sponsor #yiv3817558797ygrp-lc #yiv3817558797hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3817558797 #yiv3817558797ygrp-sponsor #yiv3817558797ygrp-lc .yiv3817558797ad {margin-bottom:10px;padding:0 0;}#yiv3817558797 #yiv3817558797actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3817558797 #yiv3817558797activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3817558797 #yiv3817558797activity span {font-weight:700;}#yiv3817558797 #yiv3817558797activity span:first-child {text-transform:uppercase;}#yiv3817558797 #yiv3817558797activity span a {color:#5085b6;text-decoration:none;}#yiv3817558797 #yiv3817558797activity span span {color:#ff7900;}#yiv3817558797 #yiv3817558797activity span .yiv3817558797underline {text-decoration:underline;}#yiv3817558797 .yiv3817558797attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3817558797 .yiv3817558797attach div a {text-decoration:none;}#yiv3817558797 .yiv3817558797attach img {border:none;padding-right:5px;}#yiv3817558797 .yiv3817558797attach label {display:block;margin-bottom:5px;}#yiv3817558797 .yiv3817558797attach label a {text-decoration:none;}#yiv3817558797 blockquote {margin:0 0 0 4px;}#yiv3817558797 .yiv3817558797bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3817558797 .yiv3817558797bold a {text-decoration:none;}#yiv3817558797 dd.yiv3817558797last p a {font-family:Verdana;font-weight:700;}#yiv3817558797 dd.yiv3817558797last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3817558797 dd.yiv3817558797last p span.yiv3817558797yshortcuts {margin-right:0;}#yiv3817558797 div.yiv3817558797attach-table div div a {text-decoration:none;}#yiv3817558797 div.yiv3817558797attach-table {width:400px;}#yiv3817558797 div.yiv3817558797file-title a, #yiv3817558797 div.yiv3817558797file-title a:active, #yiv3817558797 div.yiv3817558797file-title a:hover, #yiv3817558797 div.yiv3817558797file-title a:visited {text-decoration:none;}#yiv3817558797 div.yiv3817558797photo-title a, #yiv3817558797 div.yiv3817558797photo-title a:active, #yiv3817558797 div.yiv3817558797photo-title a:hover, #yiv3817558797 div.yiv3817558797photo-title a:visited {text-decoration:none;}#yiv3817558797 div#yiv3817558797ygrp-mlmsg #yiv3817558797ygrp-msg p a span.yiv3817558797yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3817558797 .yiv3817558797green {color:#628c2a;}#yiv3817558797 .yiv3817558797MsoNormal {margin:0 0 0 0;}#yiv3817558797 o {font-size:0;}#yiv3817558797 #yiv3817558797photos div {float:left;width:72px;}#yiv3817558797 #yiv3817558797photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv3817558797 #yiv3817558797photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3817558797 #yiv3817558797reco-category {font-size:77%;}#yiv3817558797 #yiv3817558797reco-desc {font-size:77%;}#yiv3817558797 .yiv3817558797replbq {margin:4px;}#yiv3817558797 #yiv3817558797ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3817558797 #yiv3817558797ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3817558797 #yiv3817558797ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3817558797 #yiv3817558797ygrp-mlmsg select, #yiv3817558797 input, #yiv3817558797 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3817558797 #yiv3817558797ygrp-mlmsg pre, #yiv3817558797 code {font:115% monospace;}#yiv3817558797 #yiv3817558797ygrp-mlmsg * {line-height:1..22em;}#yiv3817558797 #yiv3817558797ygrp-mlmsg #yiv3817558797logo {padding-bottom:10px;}#yiv3817558797 #yiv3817558797ygrp-msg p a {font-family:Verdana;}#yiv3817558797 #yiv3817558797ygrp-msg p#yiv3817558797attach-count span {color:#1E66AE;font-weight:700;}#yiv3817558797 #yiv3817558797ygrp-reco #yiv3817558797reco-head {color:#ff7900;font-weight:700;}#yiv3817558797 #yiv3817558797ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3817558797 #yiv3817558797ygrp-sponsor #yiv3817558797ov li a {font-size:130%;text-decoration:none;}#yiv3817558797 #yiv3817558797ygrp-sponsor #yiv3817558797ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3817558797 #yiv3817558797ygrp-sponsor #yiv3817558797ov ul {margin:0;padding:0 0 0 8px;}#yiv3817558797 #yiv3817558797ygrp-text {font-family:Georgia;}#yiv3817558797 #yiv3817558797ygrp-text p {margin:0 0 1em 0;}#yiv3817558797 #yiv3817558797ygrp-text tt {font-size:120%;}#yiv3817558797 #yiv3817558797ygrp-vital ul li:last-child {border-right:none !important;}#yiv3817558797
Tue Jul 30, 2019 1:51 am (PDT) . Posted by:
Terimakasih koreksinya Mas Imam,
Akan saya koreksi formulanya.
Wassalam,
-zainul
Sent from Mail for Windows 10
From: imam cahyo yuwono chyywn@yahoo.com [belajar-excel]
Sent: Tuesday, July 30, 2019 1:56 PM
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] Mega Formula terbilang (terbilang tanpa macro)
Terima kasih sekali atas bantuannya... namun ada yang menurut saya masih kurang contoh Rp. 131.000,00 terbilangnya seratus tiga puluh seribu Rupiah, menurut saya terbilangnya Seratus Tiga Puluh satu Ribu Rupiah...
mohon masukannya..
On Thursday, July 25, 2019, 11:52:52 AM GMT+7, Zainul Ulum zainul_ulum@yahoo..com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:
Mas Imam,
Sudah aku tulis di https://cadex.co/2017/10/15/xls-pmg-08-fungsi-terbilang-di-excel-tanpa-macro-versi-mega-formula-rev-03/
Untuk penjelasannya.
Terimakasih,
-zainul
Sent from Mail for Windows 10
From: imam cahyo yuwono chyywn@yahoo.com [belajar-excel]
Sent: Thursday, July 25, 2019 10:12 AM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Mega Formula terbilang (terbilang tanpa macro)
Dear para expert mohon bantuan penjelasan tentang formula terbilang dibawah ini
mohon pencerahan fungsi formula dan perbaikan pada formula yang ada
Terima kasih
Tue Jul 30, 2019 5:42 am (PDT) . Posted by:
maaf ada tambahan Mas Zainul... angka 1000 (Seribu) (satu Ribu) terbilang nya menjadi 1 (satu)terima kasih
On Tuesday, July 30, 2019, 03:52:21 PM GMT+7, Zainul Ulum zainul_ulum@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:
Terimakasih koreksinya Mas Imam,
Akan saya koreksi formulanya.
Wassalam,
-zainul
Sent from Mail for Windows 10
From: imam cahyo yuwono chyywn@yahoo.com [belajar-excel]
Sent: Tuesday, July 30, 2019 1:56 PM
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] Mega Formula terbilang (terbilang tanpa macro)
Terima kasih sekali atas bantuannya... namun ada yang menurut saya masih kurang contoh Rp. 131.000,00 terbilangnya seratus tiga puluh seribu Rupiah, menurut saya terbilangnya Seratus Tiga Puluh satu Ribu Rupiah...
mohon masukannya..
On Thursday, July 25, 2019, 11:52:52 AM GMT+7, Zainul Ulum zainul_ulum@yahoo..com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:
Mas Imam,
Sudah aku tulis di https://cadex.co/2017/10/15/xls-pmg-08-fungsi-terbilang-di-excel-tanpa-macro-versi-mega-formula-rev-03/
Untuk penjelasannya.
Terimakasih,
-zainul
Sent from Mail for Windows 10
From: imam cahyo yuwono chyywn@yahoo.com [belajar-excel]
Sent: Thursday, July 25, 2019 10:12 AM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Mega Formula terbilang (terbilang tanpa macro)
Dear para expert mohon bantuan penjelasan tentang formula terbilang dibawah ini
mohon pencerahan fungsi formula dan perbaikan pada formula yang ada
Terima kasih
#yiv7436276588 #yiv7436276588 -- #yiv7436276588ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7436276588 #yiv7436276588ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7436276588 #yiv7436276588ygrp-mkp #yiv7436276588hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv7436276588 #yiv7436276588ygrp-mkp #yiv7436276588ads {margin-bottom:10px;}#yiv7436276588 #yiv7436276588ygrp-mkp .yiv7436276588ad {padding:0 0;}#yiv7436276588 #yiv7436276588ygrp-mkp .yiv7436276588ad p {margin:0;}#yiv7436276588 #yiv7436276588ygrp-mkp .yiv7436276588ad a {color:#0000ff;text-decoration:none;}#yiv7436276588 #yiv7436276588ygrp-sponsor #yiv7436276588ygrp-lc {font-family:Arial;}#yiv7436276588 #yiv7436276588ygrp-sponsor #yiv7436276588ygrp-lc #yiv7436276588hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7436276588 #yiv7436276588ygrp-sponsor #yiv7436276588ygrp-lc .yiv7436276588ad {margin-bottom:10px;padding:0 0;}#yiv7436276588 #yiv7436276588actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7436276588 #yiv7436276588activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7436276588 #yiv7436276588activity span {font-weight:700;}#yiv7436276588 #yiv7436276588activity span:first-child {text-transform:uppercase;}#yiv7436276588 #yiv7436276588activity span a {color:#5085b6;text-decoration:none;}#yiv7436276588 #yiv7436276588activity span span {color:#ff7900;}#yiv7436276588 #yiv7436276588activity span .yiv7436276588underline {text-decoration:underline;}#yiv7436276588 .yiv7436276588attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv7436276588 .yiv7436276588attach div a {text-decoration:none;}#yiv7436276588 .yiv7436276588attach img {border:none;padding-right:5px;}#yiv7436276588 .yiv7436276588attach label {display:block;margin-bottom:5px;}#yiv7436276588 .yiv7436276588attach label a {text-decoration:none;}#yiv7436276588 blockquote {margin:0 0 0 4px;}#yiv7436276588 .yiv7436276588bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv7436276588 .yiv7436276588bold a {text-decoration:none;}#yiv7436276588 dd.yiv7436276588last p a {font-family:Verdana;font-weight:700;}#yiv7436276588 dd..yiv7436276588last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7436276588 dd.yiv7436276588last p span.yiv7436276588yshortcuts {margin-right:0;}#yiv7436276588 div.yiv7436276588attach-table div div a {text-decoration:none;}#yiv7436276588 div.yiv7436276588attach-table {width:400px;}#yiv7436276588 div.yiv7436276588file-title a, #yiv7436276588 div.yiv7436276588file-title a:active, #yiv7436276588 div.yiv7436276588file-title a:hover, #yiv7436276588 div.yiv7436276588file-title a:visited {text-decoration:none;}#yiv7436276588 div.yiv7436276588photo-title a, #yiv7436276588 div.yiv7436276588photo-title a:active, #yiv7436276588 div.yiv7436276588photo-title a:hover, #yiv7436276588 div.yiv7436276588photo-title a:visited {text-decoration:none;}#yiv7436276588 div#yiv7436276588ygrp-mlmsg #yiv7436276588ygrp-msg p a span.yiv7436276588yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7436276588 .yiv7436276588green {color:#628c2a;}#yiv7436276588 .yiv7436276588MsoNormal {margin:0 0 0 0;}#yiv7436276588 o {font-size:0;}#yiv7436276588 #yiv7436276588photos div {float:left;width:72px;}#yiv7436276588 #yiv7436276588photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv7436276588 #yiv7436276588photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7436276588 #yiv7436276588reco-category {font-size:77%;}#yiv7436276588 #yiv7436276588reco-desc {font-size:77%;}#yiv7436276588 .yiv7436276588replbq {margin:4px;}#yiv7436276588 #yiv7436276588ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv7436276588 #yiv7436276588ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7436276588 #yiv7436276588ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7436276588 #yiv7436276588ygrp-mlmsg select, #yiv7436276588 input, #yiv7436276588 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv7436276588 #yiv7436276588ygrp-mlmsg pre, #yiv7436276588 code {font:115% monospace;}#yiv7436276588 #yiv7436276588ygrp-mlmsg * {line-height:1.22em;}#yiv7436276588 #yiv7436276588ygrp-mlmsg #yiv7436276588logo {padding-bottom:10px;}#yiv7436276588 #yiv7436276588ygrp-msg p a {font-family:Verdana;}#yiv7436276588 #yiv7436276588ygrp-msg p#yiv7436276588attach-count span {color:#1E66AE;font-weight:700;}#yiv7436276588 #yiv7436276588ygrp-reco #yiv7436276588reco-head {color:#ff7900;font-weight:700;}#yiv7436276588 #yiv7436276588ygrp-reco {margin-bottom:20px;padding:0px;}#yiv7436276588 #yiv7436276588ygrp-sponsor #yiv7436276588ov li a {font-size:130%;text-decoration:none;}#yiv7436276588 #yiv7436276588ygrp-sponsor #yiv7436276588ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv7436276588 #yiv7436276588ygrp-sponsor #yiv7436276588ov ul {margin:0;padding:0 0 0 8px;}#yiv7436276588 #yiv7436276588ygrp-text {font-family:Georgia;}#yiv7436276588 #yiv7436276588ygrp-text p {margin:0 0 1em 0;}#yiv7436276588 #yiv7436276588ygrp-text tt {font-size:120%;}#yiv7436276588 #yiv7436276588ygrp-vital ul li:last-child {border-right:none !important;}#yiv7436276588
Mon Jul 29, 2019 11:56 pm (PDT) . Posted by:
Pak Kid,
Problem Solved. Terima kasih Pak Kid.
On Tue, Jul 30, 2019 at 1:22 AM 'Mr. Kid' mr.nmkid@gmail.com
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:
>
>
> terlampir
>
> On Mon, Jul 29, 2019 at 4:05 PM Stephen Saputro stephensaputro@gmail.com
> [belajar-excel] <belajar-excel@yahoogroups.com> wrote:
>
>>
>>
>> Hanya ada ini aja Pak Kid,
>>
>> [image: image.png]
>>
>> On Mon, Jul 29, 2019 at 2:18 PM 'Mr. Kid' mr.nmkid@gmail.com
>> [belajar-excel] <belajar-excel@yahoogroups..com
>> <belajar-excel@yahoogroups.com>> wrote:
>>
>>>
>>>
>>> di cek di worksheet yang ada pivot table-nya......
>>>
>>>
>>> On Mon, Jul 29, 2019 at 1:49 PM Stephen Saputro
>>> stephensaputro@gmail..com <stephensaputro@gmail.com> [belajar-excel] <
>>> belajar-excel@yahoogroups.com> wrote:
>>>
>>>>
>>>>
>>>> Pak Kid,
>>>>
>>>> Sudah saya cek tapi gak ada, saya cuman pake 1 event di thisworkbook
>>>>
>>>> [image: image.png]
>>>>
>>>> Sebenar nya masih bisa di skip sih masalah ini, hanya saja sedikit
>>>> mengganggu,
>>>>
>>>> On Mon, Jul 29, 2019 at 10:52 AM 'Mr. Kid' mr.nmkid@gmail.com
>>>> [belajar-excel] <belajar-excel@yahoogroups.com
>>>> <belajar-excel@yahoogroups..com>> wrote:
>>>>
>>>>>
>>>>>
>>>>> Mungkin ada 2 event di sheet itu.
>>>>>
>>>>> Sent from my smart enough phone
>>>>>
>>>>> On Jul 29, 2019, at 10:11, Stephen Saputro stephensaputro@gmail.com
>>>>> [belajar-excel] <belajar-excel@yahoogroups.com> wrote:
>>>>>
>>>>>
>>>>>
>>>>> Pak Kid,
>>>>>
>>>>> Saya coba script di bawah ini dan berhasil :
>>>>>
>>>>> Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal
>>>>> Target As Range, Cancel As Boolean)
>>>>>
>>>>> On Error Resume Next
>>>>> If Left(Target.Value, 2) = "\\" Then
>>>>> ActiveWorkbook.FollowHyperlink Address:=Target..Value, NewWindow:=True
>>>>> End If
>>>>>
>>>>> End Sub
>>>>>
>>>>> Tapi setelah saya melakukan script yang sama di kertas kerja yang
>>>>> sesungguhnya, kenapa kotak dialog di bawah ini jadi muncul dua kali ya Pak ?
>>>>>
>>>>> <image.png>
>>>>>
>>>>> On Thu, Feb 21, 2019 at 2:46 PM Stephen Saputro <
>>>>> stephensaputro@gmail.com> wrote:
>>>>>
>>>>>> Pak Kid,
>>>>>>
>>>>>> Terima kasih untuk clue nya. Akan coba saya cerna dulu ya Pak.
>>>>>>
>>>>>>
>>>>>> Regards
>>>>>> Adi
>>>>>>
>>>>>> On Thu, Feb 21, 2019 at 1:49 PM 'Mr. Kid' mr.nmkid@gmail..com
>>>>>> [belajar-excel] <belajar-excel@yahoogroups..com
>>>>>> <belajar-excel@yahoogroups.com>> wrote:
>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> harus tahu nama field yang berisi teks url nya
>>>>>>> supaya bisa membatasi kerja event di area field itu saja.
>>>>>>> pakai error trap juga, supaya gak ribet harus periksa apakah cells
>>>>>>> yang ditunjuk berisi url atau sekadar teks biasa.
>>>>>>>
>>>>>>> Regards,
>>>>>>> Kid
>>>>>>>
>>>>>>>
>>>>>>> On Wed, Feb 20, 2019 at 12:10 PM Stephen Saputro
>>>>>>> stephensaputro@gmail.com [belajar-excel] <
>>>>>>> belajar-excel@yahoogroups.com> wrote:
>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Dear Teman2 Milis,
>>>>>>>>
>>>>>>>> Mohon dapat di bantu kasus saya, Saya sedang membuat pivot, yang di
>>>>>>>> dalamnya ada hyperlink yang jika di klik akan membuka suatu document. Untuk
>>>>>>>> mengaktivkan hyperlink di pivot, saya menggunakan script di bawah ini :
>>>>>>>>
>>>>>>>>
>>>>>>>> ----------------------------------------------------------
>>>>>>>> Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal
>>>>>>>> Target As Range)
>>>>>>>>
>>>>>>>> Dim ptc As PivotTable, Value As Variant, Rng As Range
>>>>>>>> For Each ptc In Worksheets(Sh.Name).PivotTables
>>>>>>>> If Not Intersect(Target, Range(ptc........TableRange1.Address)) Is
>>>>>>>> Nothing Then
>>>>>>>> If Left(Target.Value, 2) = "\\" Then
>>>>>>>> ActiveWorkbook.FollowHyperlink Address:=Target.Value,
>>>>>>>> NewWindow:=True
>>>>>>>> End If
>>>>>>>> End If
>>>>>>>> Next ptc
>>>>>>>> End Sub
>>>>>>>>
>>>>>>>>
>>>>>>>> ----------------------------------------------------------
>>>>>>>>
>>>>>>>> Hanya saja ada beberapa masalah yang saya hadapi.
>>>>>>>>
>>>>>>>> 1. ketika saya melakukan select range di pivot, maka yang muncul
>>>>>>>> adalah seperti ini :
>>>>>>>>
>>>>>>>> Select range
>>>>>>>> <image.png>
>>>>>>>>
>>>>>>>> Message 1
>>>>>>>> <image.png>
>>>>>>>>
>>>>>>>> 2.. Waktu hyperlink di klik, akan keluar Ok or Cancel, dan waktu
>>>>>>>> cancel di klik, maka yang muncul adalah seperti ini :
>>>>>>>>
>>>>>>>> <image.png>
>>>>>>>>
>>>>>>>> Message 2
>>>>>>>> <image.png>
>>>>>>>>
>>>>>>>> Mohon bantuan teman teman semuanya, bagaimana agar cara nya
>>>>>>>> menghilangkan error ini agar message 1 dan juga message 2 tidak muncul lagi
>>>>>>>>
>>>>>>>>
>>>>>>>> Terima kasih
>>>>>>>>
>>>>>>>>
>
Tue Jul 30, 2019 6:02 am (PDT) . Posted by:
Apakah Bisa UserForm Lookup Ke Data Excel, Seperti Rumus = (samadengan)
