Rabu, 06 Januari 2016

[belajar-excel] Digest Number 3711

8 Messages

Digest #3711
1a
Bls: [belajar-excel] File VBA Error by "nursay saefulloh" nursay_saefulloh
1b
Re: Bls: [belajar-excel] File VBA Error by "Warsito Ito" warsitoito14
2
VBA Expand Form by "Septian Eko Saputro"
3a
Absen pergi Supir. by "nursay saefulloh" nursay_saefulloh
3b
Bls: [belajar-excel] Absen pergi Supir. by "nursay saefulloh" nursay_saefulloh
4a
Tombol hapus pd userform by "Pauzan Ozan" b3ki_cot
4b
Tombol hapus pd userform by "Pauzan Ozan" b3ki_cot
5
Filter data dengan 2 Kriteria by "Warsito Ito" warsitoito14

Messages

Tue Jan 5, 2016 8:01 am (PST) . Posted by:

"nursay saefulloh" nursay_saefulloh

di VBA toolbar tidak ada DTPICKER nya. om,,,coba di cek de.


Pada Selasa, 5 Januari 2016 14:07, "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Apakah CurrentRegion di Komputer ini Indonesian ?Kalau ya, coba ganti Englsih US.
Salam,HK


From: "Warsito Ito warsitoito14@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Tuesday, 5 January 2016, 12:57
Subject: [belajar-excel] File VBA Error

  Kepada para master yang baik hati,..
Sya punya file excel vba yang di share lewat homegroup,dan ada satu komputer yang tidak bisa membuka nya

error dengan peringatan Compile error pada

lwaktu.caption = FormatDateTime(Time, vbLongTime)
ltanggal.Caption = Format(Date, "dddd,dd mmmm yyyy")
semoga para master bisa memberikan solusinya

Terima kasih

Ito


#yiv8364330327 #yiv8364330327 -- #yiv8364330327ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8364330327 #yiv8364330327ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8364330327 #yiv8364330327ygrp-mkp #yiv8364330327hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8364330327 #yiv8364330327ygrp-mkp #yiv8364330327ads {margin-bottom:10px;}#yiv8364330327 #yiv8364330327ygrp-mkp .yiv8364330327ad {padding:0 0;}#yiv8364330327 #yiv8364330327ygrp-mkp .yiv8364330327ad p {margin:0;}#yiv8364330327 #yiv8364330327ygrp-mkp .yiv8364330327ad a {color:#0000ff;text-decoration:none;}#yiv8364330327 #yiv8364330327ygrp-sponsor #yiv8364330327ygrp-lc {font-family:Arial;}#yiv8364330327 #yiv8364330327ygrp-sponsor #yiv8364330327ygrp-lc #yiv8364330327hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8364330327 #yiv8364330327ygrp-sponsor #yiv8364330327ygrp-lc .yiv8364330327ad {margin-bottom:10px;padding:0 0;}#yiv8364330327 #yiv8364330327actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8364330327 #yiv8364330327activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8364330327 #yiv8364330327activity span {font-weight:700;}#yiv8364330327 #yiv8364330327activity span:first-child {text-transform:uppercase;}#yiv8364330327 #yiv8364330327activity span a {color:#5085b6;text-decoration:none;}#yiv8364330327 #yiv8364330327activity span span {color:#ff7900;}#yiv8364330327 #yiv8364330327activity span .yiv8364330327underline {text-decoration:underline;}#yiv8364330327 .yiv8364330327attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8364330327 .yiv8364330327attach div a {text-decoration:none;}#yiv8364330327 .yiv8364330327attach img {border:none;padding-right:5px;}#yiv8364330327 .yiv8364330327attach label {display:block;margin-bottom:5px;}#yiv8364330327 .yiv8364330327attach label a {text-decoration:none;}#yiv8364330327 blockquote {margin:0 0 0 4px;}#yiv8364330327 .yiv8364330327bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8364330327 .yiv8364330327bold a {text-decoration:none;}#yiv8364330327 dd.yiv8364330327last p a {font-family:Verdana;font-weight:700;}#yiv8364330327 dd.yiv8364330327last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8364330327 dd.yiv8364330327last p span.yiv8364330327yshortcuts {margin-right:0;}#yiv8364330327 div.yiv8364330327attach-table div div a {text-decoration:none;}#yiv8364330327 div.yiv8364330327attach-table {width:400px;}#yiv8364330327 div.yiv8364330327file-title a, #yiv8364330327 div.yiv8364330327file-title a:active, #yiv8364330327 div.yiv8364330327file-title a:hover, #yiv8364330327 div.yiv8364330327file-title a:visited {text-decoration:none;}#yiv8364330327 div.yiv8364330327photo-title a, #yiv8364330327 div.yiv8364330327photo-title a:active, #yiv8364330327 div.yiv8364330327photo-title a:hover, #yiv8364330327 div.yiv8364330327photo-title a:visited {text-decoration:none;}#yiv8364330327 div#yiv8364330327ygrp-mlmsg #yiv8364330327ygrp-msg p a span.yiv8364330327yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8364330327 .yiv8364330327green {color:#628c2a;}#yiv8364330327 .yiv8364330327MsoNormal {margin:0 0 0 0;}#yiv8364330327 o {font-size:0;}#yiv8364330327 #yiv8364330327photos div {float:left;width:72px;}#yiv8364330327 #yiv8364330327photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv8364330327 #yiv8364330327photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8364330327 #yiv8364330327reco-category {font-size:77%;}#yiv8364330327 #yiv8364330327reco-desc {font-size:77%;}#yiv8364330327 .yiv8364330327replbq {margin:4px;}#yiv8364330327 #yiv8364330327ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8364330327 #yiv8364330327ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8364330327 #yiv8364330327ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8364330327 #yiv8364330327ygrp-mlmsg select, #yiv8364330327 input, #yiv8364330327 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8364330327 #yiv8364330327ygrp-mlmsg pre, #yiv8364330327 code {font:115% monospace;}#yiv8364330327 #yiv8364330327ygrp-mlmsg * {line-height:1.22em;}#yiv8364330327 #yiv8364330327ygrp-mlmsg #yiv8364330327logo {padding-bottom:10px;}#yiv8364330327 #yiv8364330327ygrp-msg p a {font-family:Verdana;}#yiv8364330327 #yiv8364330327ygrp-msg p#yiv8364330327attach-count span {color:#1E66AE;font-weight:700;}#yiv8364330327 #yiv8364330327ygrp-reco #yiv8364330327reco-head {color:#ff7900;font-weight:700;}#yiv8364330327 #yiv8364330327ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8364330327 #yiv8364330327ygrp-sponsor #yiv8364330327ov li a {font-size:130%;text-decoration:none;}#yiv8364330327 #yiv8364330327ygrp-sponsor #yiv8364330327ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8364330327 #yiv8364330327ygrp-sponsor #yiv8364330327ov ul {margin:0;padding:0 0 0 8px;}#yiv8364330327 #yiv8364330327ygrp-text {font-family:Georgia;}#yiv8364330327 #yiv8364330327ygrp-text p {margin:0 0 1em 0;}#yiv8364330327 #yiv8364330327ygrp-text tt {font-size:120%;}#yiv8364330327 #yiv8364330327ygrp-vital ul li:last-child {border-right:none !important;}#yiv8364330327

Tue Jan 5, 2016 7:31 pm (PST) . Posted by:

"Warsito Ito" warsitoito14

Ok terima kasih saya atas jawabanya

salam

Ito


On Tuesday, January 5, 2016 11:01 PM, "nursay saefulloh nursay_saefulloh@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> wrote:


  di VBA toolbar tidak ada DTPICKER nya. om,,,coba di cek de.


Pada Selasa, 5 Januari 2016 14:07, "hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Apakah CurrentRegion di Komputer ini Indonesian ?Kalau ya, coba ganti Englsih US.
Salam,HK


From: "Warsito Ito warsitoito14@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Tuesday, 5 January 2016, 12:57
Subject: [belajar-excel] File VBA Error

  Kepada para master yang baik hati,..
Sya punya file excel vba yang di share lewat homegroup,dan ada satu komputer yang tidak bisa membuka nya

error dengan peringatan Compile error pada

lwaktu.caption = FormatDateTime(Time, vbLongTime)
ltanggal.Caption = Format(Date, "dddd,dd mmmm yyyy")
semoga para master bisa memberikan solusinya

Terima kasih

Ito


#yiv1662882641 #yiv1662882641 -- #yiv1662882641ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1662882641 #yiv1662882641ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1662882641 #yiv1662882641ygrp-mkp #yiv1662882641hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1662882641 #yiv1662882641ygrp-mkp #yiv1662882641ads {margin-bottom:10px;}#yiv1662882641 #yiv1662882641ygrp-mkp .yiv1662882641ad {padding:0 0;}#yiv1662882641 #yiv1662882641ygrp-mkp .yiv1662882641ad p {margin:0;}#yiv1662882641 #yiv1662882641ygrp-mkp .yiv1662882641ad a {color:#0000ff;text-decoration:none;}#yiv1662882641 #yiv1662882641ygrp-sponsor #yiv1662882641ygrp-lc {font-family:Arial;}#yiv1662882641 #yiv1662882641ygrp-sponsor #yiv1662882641ygrp-lc #yiv1662882641hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1662882641 #yiv1662882641ygrp-sponsor #yiv1662882641ygrp-lc .yiv1662882641ad {margin-bottom:10px;padding:0 0;}#yiv1662882641 #yiv1662882641actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1662882641 #yiv1662882641activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1662882641 #yiv1662882641activity span {font-weight:700;}#yiv1662882641 #yiv1662882641activity span:first-child {text-transform:uppercase;}#yiv1662882641 #yiv1662882641activity span a {color:#5085b6;text-decoration:none;}#yiv1662882641 #yiv1662882641activity span span {color:#ff7900;}#yiv1662882641 #yiv1662882641activity span .yiv1662882641underline {text-decoration:underline;}#yiv1662882641 .yiv1662882641attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1662882641 .yiv1662882641attach div a {text-decoration:none;}#yiv1662882641 .yiv1662882641attach img {border:none;padding-right:5px;}#yiv1662882641 .yiv1662882641attach label {display:block;margin-bottom:5px;}#yiv1662882641 .yiv1662882641attach label a {text-decoration:none;}#yiv1662882641 blockquote {margin:0 0 0 4px;}#yiv1662882641 .yiv1662882641bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1662882641 .yiv1662882641bold a {text-decoration:none;}#yiv1662882641 dd.yiv1662882641last p a {font-family:Verdana;font-weight:700;}#yiv1662882641 dd.yiv1662882641last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1662882641 dd.yiv1662882641last p span.yiv1662882641yshortcuts {margin-right:0;}#yiv1662882641 div.yiv1662882641attach-table div div a {text-decoration:none;}#yiv1662882641 div.yiv1662882641attach-table {width:400px;}#yiv1662882641 div.yiv1662882641file-title a, #yiv1662882641 div.yiv1662882641file-title a:active, #yiv1662882641 div.yiv1662882641file-title a:hover, #yiv1662882641 div.yiv1662882641file-title a:visited {text-decoration:none;}#yiv1662882641 div.yiv1662882641photo-title a, #yiv1662882641 div.yiv1662882641photo-title a:active, #yiv1662882641 div.yiv1662882641photo-title a:hover, #yiv1662882641 div.yiv1662882641photo-title a:visited {text-decoration:none;}#yiv1662882641 div#yiv1662882641ygrp-mlmsg #yiv1662882641ygrp-msg p a span.yiv1662882641yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1662882641 .yiv1662882641green {color:#628c2a;}#yiv1662882641 .yiv1662882641MsoNormal {margin:0 0 0 0;}#yiv1662882641 o {font-size:0;}#yiv1662882641 #yiv1662882641photos div {float:left;width:72px;}#yiv1662882641 #yiv1662882641photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv1662882641 #yiv1662882641photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1662882641 #yiv1662882641reco-category {font-size:77%;}#yiv1662882641 #yiv1662882641reco-desc {font-size:77%;}#yiv1662882641 .yiv1662882641replbq {margin:4px;}#yiv1662882641 #yiv1662882641ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1662882641 #yiv1662882641ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1662882641 #yiv1662882641ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1662882641 #yiv1662882641ygrp-mlmsg select, #yiv1662882641 input, #yiv1662882641 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1662882641 #yiv1662882641ygrp-mlmsg pre, #yiv1662882641 code {font:115% monospace;}#yiv1662882641 #yiv1662882641ygrp-mlmsg * {line-height:1.22em;}#yiv1662882641 #yiv1662882641ygrp-mlmsg #yiv1662882641logo {padding-bottom:10px;}#yiv1662882641 #yiv1662882641ygrp-msg p a {font-family:Verdana;}#yiv1662882641 #yiv1662882641ygrp-msg p#yiv1662882641attach-count span {color:#1E66AE;font-weight:700;}#yiv1662882641 #yiv1662882641ygrp-reco #yiv1662882641reco-head {color:#ff7900;font-weight:700;}#yiv1662882641 #yiv1662882641ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1662882641 #yiv1662882641ygrp-sponsor #yiv1662882641ov li a {font-size:130%;text-decoration:none;}#yiv1662882641 #yiv1662882641ygrp-sponsor #yiv1662882641ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1662882641 #yiv1662882641ygrp-sponsor #yiv1662882641ov ul {margin:0;padding:0 0 0 8px;}#yiv1662882641 #yiv1662882641ygrp-text {font-family:Georgia;}#yiv1662882641 #yiv1662882641ygrp-text p {margin:0 0 1em 0;}#yiv1662882641 #yiv1662882641ygrp-text tt {font-size:120%;}#yiv1662882641 #yiv1662882641ygrp-vital ul li:last-child {border-right:none !important;}#yiv1662882641

Tue Jan 5, 2016 8:01 am (PST) . Posted by:

"Septian Eko Saputro"

Dear Para Master Excel

saya mempunyai sebuah kasus dengan VBA.
1. Data yang saya sisipkan adalah data antara inputan awal dan hasil
inputan nantinya.
2. Saya mempunyai sebuah data surat perjanjian yang mempunyai berbagai
termin pembayaran.
3. Dalam 1 surat perjanjian tersebut misalnya mempunyai 4 termin
pembayaran.
4. Proses inputan yang dilakukan melalui sebuah Form inputan, dan ketika
memasukkan jumlah termin surat perjanjian tersebut akan *expand* dengan
jumlah kolom inputan sesuai dengan jumlah termin tersebut dengan kolom
tambahan nilai termin dan tanggal jatuh tempo termin.
5. aktivitas inputan tersebut akan menghasilkan data seperti di sheet data
inputan termin
pertanyaan:
a. Apakah VBA bisa memunculkan hal tersebut dengan *automatic* ketika
isikan jumlah termin pada form inputan surat perjanjian? dengan fungsi VBA
apa terkait dengan prosedur tersebut?
b. jika tidak, apakah ada alternatif lain terkait dengan prosedur yang bisa
dilakukan guna mendapatkan hasil data seperti pada sheet inputan data
termin tersebut.

Demikian para master, mohon percerahan terkait dengan case tersebut.

Salam,
Monnalissa

Tue Jan 5, 2016 8:03 am (PST) . Posted by:

"nursay saefulloh" nursay_saefulloh


Selamat pagi para sesepuh XL.
Ane punya userform yg biasa untuk absen karyawan biasa,dan ingin sya tanyakan !
Bagaimana cara Memodifikasi Userform tersebut agar bisa digunakan untuk mengisi Absen Supir yang BERTUGAS keluar KOTA. Sesuai dengan jumlah hari kota tujuan tersebut.

Kota
Hari
Jakarta
Jkt
1
Bogor
Bgr
2
Bandung
Bdg
3
Cirebon
Crb
4
Padang
Pdg
10
Aceh
Ach
14


AA Kid pergi ke Crb Tanggal 2 dan ke Jkt Tanggal 9, maka akan terisi di nama AA dari tgl 2 sampai tgl 5 ke Crb. Begitu juga pada tgl 9 pergi ke Jkt
Saya mengisi di Userform HANYA tgl 2 ke Crb dan tgl 9 ke Jkt
Bagaimana rumus VBA untuk masalah ini.
Contoh :
Nama
1
2
3
4
5
6
7
8
9
10
11
dst
AA Kid

Crb
Crb
Crb
Crb



JKt




Mungkin ini kata2x yg bisa saya tulis, maklum ga bisa merangkai kata-kata mutiara.
Contoh : Terlampir.


Terimakasih....

--- Mods ---
File lampiran yang melebihi 250KB dilepas dari email. Silakan penanya menngirim ulang file lampiran yang teah diusahakan maksimal 250KB dengan cara me-reply email ini.
--------------




Tue Jan 5, 2016 7:32 pm (PST) . Posted by:

"nursay saefulloh" nursay_saefulloh

Revisi Lampiran Absen Supir


Pada Selasa, 5 Januari 2016 20:50, "nursay saefulloh nursay_saefulloh@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Selamat pagi parasesepuh XL.Ane punya userform ygbiasa untuk absen karyawan biasa,dan ingin sya tanyakan !Bagaimana caraMemodifikasi Userform tersebut agar bisa digunakan untuk mengisi Absen Supiryang BERTUGAS keluar KOTA. Sesuai dengan jumlah hari kota tujuan tersebut. 
| Kota | Hari |
| Jakarta | Jkt | 1 |
| Bogor  | Bgr | 2 |
| Bandung | Bdg | 3 |
| Cirebon | Crb | 4 |
| Padang  | Pdg | 10 |
| Aceh | Ach | 14 |

  AA Kid pergi ke CrbTanggal 2 dan ke Jkt Tanggal 9, maka akan terisi di nama AA dari tgl 2 sampaitgl 5 ke Crb. Begitu juga pada tgl 9 pergi ke JktSaya mengisi di UserformHANYA tgl 2 ke Crb dan tgl 9 ke JktBagaimana rumus VBAuntuk masalah ini.Contoh :
| Nama | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | dst |
| AA Kid |   | Crb | Crb | Crb | Crb |   |   |   | JKt |   |   |   |

 Mungkin ini kata2x ygbisa saya tulis, maklum ga bisa merangkai kata-kata mutiara.Contoh : Terlampir.  Terimakasih....

--- Mods ---
File lampiran yang melebihi 250KB dilepas dari email. Silakan penanya menngirim ulang file lampiran yang teah diusahakan maksimal 250KB dengan cara me-reply email ini.
--------------
#yiv8281911073 #yiv8281911073 -- #yiv8281911073ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8281911073 #yiv8281911073ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8281911073 #yiv8281911073ygrp-mkp #yiv8281911073hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8281911073 #yiv8281911073ygrp-mkp #yiv8281911073ads {margin-bottom:10px;}#yiv8281911073 #yiv8281911073ygrp-mkp .yiv8281911073ad {padding:0 0;}#yiv8281911073 #yiv8281911073ygrp-mkp .yiv8281911073ad p {margin:0;}#yiv8281911073 #yiv8281911073ygrp-mkp .yiv8281911073ad a {color:#0000ff;text-decoration:none;}#yiv8281911073 #yiv8281911073ygrp-sponsor #yiv8281911073ygrp-lc {font-family:Arial;}#yiv8281911073 #yiv8281911073ygrp-sponsor #yiv8281911073ygrp-lc #yiv8281911073hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8281911073 #yiv8281911073ygrp-sponsor #yiv8281911073ygrp-lc .yiv8281911073ad {margin-bottom:10px;padding:0 0;}#yiv8281911073 #yiv8281911073actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8281911073 #yiv8281911073activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8281911073 #yiv8281911073activity span {font-weight:700;}#yiv8281911073 #yiv8281911073activity span:first-child {text-transform:uppercase;}#yiv8281911073 #yiv8281911073activity span a {color:#5085b6;text-decoration:none;}#yiv8281911073 #yiv8281911073activity span span {color:#ff7900;}#yiv8281911073 #yiv8281911073activity span .yiv8281911073underline {text-decoration:underline;}#yiv8281911073 .yiv8281911073attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8281911073 .yiv8281911073attach div a {text-decoration:none;}#yiv8281911073 .yiv8281911073attach img {border:none;padding-right:5px;}#yiv8281911073 .yiv8281911073attach label {display:block;margin-bottom:5px;}#yiv8281911073 .yiv8281911073attach label a {text-decoration:none;}#yiv8281911073 blockquote {margin:0 0 0 4px;}#yiv8281911073 .yiv8281911073bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8281911073 .yiv8281911073bold a {text-decoration:none;}#yiv8281911073 dd.yiv8281911073last p a {font-family:Verdana;font-weight:700;}#yiv8281911073 dd.yiv8281911073last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8281911073 dd.yiv8281911073last p span.yiv8281911073yshortcuts {margin-right:0;}#yiv8281911073 div.yiv8281911073attach-table div div a {text-decoration:none;}#yiv8281911073 div.yiv8281911073attach-table {width:400px;}#yiv8281911073 div.yiv8281911073file-title a, #yiv8281911073 div.yiv8281911073file-title a:active, #yiv8281911073 div.yiv8281911073file-title a:hover, #yiv8281911073 div.yiv8281911073file-title a:visited {text-decoration:none;}#yiv8281911073 div.yiv8281911073photo-title a, #yiv8281911073 div.yiv8281911073photo-title a:active, #yiv8281911073 div.yiv8281911073photo-title a:hover, #yiv8281911073 div.yiv8281911073photo-title a:visited {text-decoration:none;}#yiv8281911073 div#yiv8281911073ygrp-mlmsg #yiv8281911073ygrp-msg p a span.yiv8281911073yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8281911073 .yiv8281911073green {color:#628c2a;}#yiv8281911073 .yiv8281911073MsoNormal {margin:0 0 0 0;}#yiv8281911073 o {font-size:0;}#yiv8281911073 #yiv8281911073photos div {float:left;width:72px;}#yiv8281911073 #yiv8281911073photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv8281911073 #yiv8281911073photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8281911073 #yiv8281911073reco-category {font-size:77%;}#yiv8281911073 #yiv8281911073reco-desc {font-size:77%;}#yiv8281911073 .yiv8281911073replbq {margin:4px;}#yiv8281911073 #yiv8281911073ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8281911073 #yiv8281911073ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8281911073 #yiv8281911073ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8281911073 #yiv8281911073ygrp-mlmsg select, #yiv8281911073 input, #yiv8281911073 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8281911073 #yiv8281911073ygrp-mlmsg pre, #yiv8281911073 code {font:115% monospace;}#yiv8281911073 #yiv8281911073ygrp-mlmsg * {line-height:1.22em;}#yiv8281911073 #yiv8281911073ygrp-mlmsg #yiv8281911073logo {padding-bottom:10px;}#yiv8281911073 #yiv8281911073ygrp-msg p a {font-family:Verdana;}#yiv8281911073 #yiv8281911073ygrp-msg p#yiv8281911073attach-count span {color:#1E66AE;font-weight:700;}#yiv8281911073 #yiv8281911073ygrp-reco #yiv8281911073reco-head {color:#ff7900;font-weight:700;}#yiv8281911073 #yiv8281911073ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8281911073 #yiv8281911073ygrp-sponsor #yiv8281911073ov li a {font-size:130%;text-decoration:none;}#yiv8281911073 #yiv8281911073ygrp-sponsor #yiv8281911073ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8281911073 #yiv8281911073ygrp-sponsor #yiv8281911073ov ul {margin:0;padding:0 0 0 8px;}#yiv8281911073 #yiv8281911073ygrp-text {font-family:Georgia;}#yiv8281911073 #yiv8281911073ygrp-text p {margin:0 0 1em 0;}#yiv8281911073 #yiv8281911073ygrp-text tt {font-size:120%;}#yiv8281911073 #yiv8281911073ygrp-vital ul li:last-child {border-right:none !important;}#yiv8281911073

Tue Jan 5, 2016 11:57 pm (PST) . Posted by:

"Pauzan Ozan" b3ki_cot

Dear para pkar excel Salam Sya mw mnanyakn bgaimna vba tombl hapus data pda userform yg sy buat pd lmpiran ni .yg sy ingnkn stlh mnghpus slh stu bris dta mka no urut pda dta trsbut ttp berurutan. Brkut sy lmpirkn file biar lbih jlas Ats bntuan pra mr excel sy ucpkn trmksih

Wed Jan 6, 2016 1:21 am (PST) . Posted by:

"Warsito Ito" warsitoito14

Para Master yang BudimanSaya punya problem  pencarian data dengan 2 kriteria untuk menampilkan no surat jalan No.Surat jalan tersebut berdasarkan Nama perusahaan (Kriteria 1) dan flow masuk / keluar (Kriteria 2)Private Sub textflow_Change()

Dim rngnamaPt As Range 

If cmkepada.ListIndex <> -1 Then
    With Sheets("Record SJoutsourche").Range("F:F")     
         Set rngnamaPt = .Find(cmkepada.Text and textflow.Text, .Resize(1, 1), lookat:=xlWhole,searchdirection:=xlPrevious)
        
         If Not rngnamaPt Is Nothing Then    
                txtnosuratjalan.Text = rngnamaPt.Offset(0, -3).Value  
            
               
   
               
                Else
                txtnosuratjalan.Text = vbNullString
                   End If
    End With
               
         End If
End SubScript tersebut errror  pada text yang warna merah
semoga para master dapat memberikan solusinya

Terima kasih

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

Posting Komentar