[belajar-excel] Digest Number 4589

Milis Belajar Microsoft Excel Group

6 Messages

Digest #4589

1a

Formula PO Status by "halak hita"

1b

Re: Formula PO Status [1 Attachment] by "hendrik karnadi" hendrikkarnadi

1c

Re: Formula PO Status by "halak hita"

1d

Re: Formula PO Status by "ghozi alkatiri" ghozialkatiri

2a

Re: Nama userform dijadikan variable by "Tio Ali" tioali2011

3

Kelompok Tiket Manjadi Tiket Berurutan by "Nunuk Y Saptaningtyas"

Messages

1a

Formula PO Status

Thu Sep 6, 2018 2:12 am (PDT) . Posted by:

"halak hita"

Dear para Master
Mohon dibantu, bagaimana formula yang tepat agar PO Status dapat otomatis.
apabila hanya isi kolom qty supply maka status nya dapat otomatis berubah
sesuai contoh terlampir.

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

1b

Re: Formula PO Status [1 Attachment]

Thu Sep 6, 2018 3:15 am (PDT) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai halak kita,Coba pakai fungsi If.Pada kolom PO Status diketik:=If(Q...=0,"Closed","Partial Released").
Salam,HJK

On Thursday, 6 September 2018, 4:12:57 PM GMT+7, halak hita halakhita1983@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

 

Dear para MasterMohon dibantu, bagaimana formula yang tepat agar PO Status dapat otomatis. apabila hanya isi kolom qty supply maka status nya dapat otomatis berubah sesuai contoh terlampir.

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

1c

Re: Formula PO Status

Thu Sep 6, 2018 5:04 am (PDT) . Posted by:

"halak hita"

Terima kasih pak HK
Mogin dibantu pak, bagaimana rumus yg dikolom "Item Status" agar hasilnya
sesuai dgn contoh.

Sudah dicoba masukkan formula "PO Status" sesuai yg bapak sarankan.
Bgmna agar baris keduanya agar tetap kosong karena 1 (satu) PO mencakup
status item yg didalamnya (sehingga tidak double status dalam nomor PO yg
sama)

Pada tanggal Kam, 6 Sep 2018 17:16, hendrik karnadi hendrikkarnadi@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com> menulis:

>
>
> Hai halak kita,
> Coba pakai fungsi If.
> Pada kolom PO Status diketik:
> =If(Q...=0,"Closed","Partial Released").
>
> Salam,
> HJK
>
>
>
> On Thursday, 6 September 2018, 4:12:57 PM GMT+7, halak hita
> halakhita1983@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com>
> wrote:
>
>
>
>
> Dear para Master
> Mohon dibantu, bagaimana formula yang tepat agar PO Status dapat otomatis.
> apabila hanya isi kolom qty supply maka status nya dapat otomatis berubah
> sesuai contoh terlampir.
>
>
>
>

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

1d

Re: Formula PO Status

Thu Sep 6, 2018 9:14 pm (PDT) . Posted by:

"ghozi alkatiri" ghozialkatiri

coba file terlampir formula pada kolom blok merah
wassalam
Ghozi alkatiri
Pada Kamis, 6 September 2018 19.38.07 WIB, halak hita halakhita1983@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 

Terima kasih pak HKMogin dibantu pak, bagaimana rumus yg dikolom "Item Status" agar hasilnya sesuai dgn contoh.
Sudah dicoba masukkan formula "PO Status" sesuai yg bapak sarankan.Bgmna agar baris keduanya agar tetap kosong karena 1 (satu) PO mencakup status item yg didalamnya (sehingga tidak double status dalam nomor PO yg sama)
Pada tanggal Kam, 6 Sep 2018 17:16, hendrik karnadi hendrikkarnadi@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 

Hai halak kita,Coba pakai fungsi If.Pada kolom PO Status diketik:=If(Q...=0,"Closed","Partial Released").
Salam,HJK

On Thursday, 6 September 2018, 4:12:57 PM GMT+7, halak hita halakhita1983@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

 

Dear para MasterMohon dibantu, bagaimana formula yang tepat agar PO Status dapat otomatis. apabila hanya isi kolom qty supply maka status nya dapat otomatis berubah sesuai contoh terlampir.

#yiv0085634656 #yiv0085634656 -- #yiv0085634656ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0085634656 #yiv0085634656ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0085634656 #yiv0085634656ygrp-mkp #yiv0085634656hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0085634656 #yiv0085634656ygrp-mkp #yiv0085634656ads {margin-bottom:10px;}#yiv0085634656 #yiv0085634656ygrp-mkp .yiv0085634656ad {padding:0 0;}#yiv0085634656 #yiv0085634656ygrp-mkp .yiv0085634656ad p {margin:0;}#yiv0085634656 #yiv0085634656ygrp-mkp .yiv0085634656ad a {color:#0000ff;text-decoration:none;}#yiv0085634656 #yiv0085634656ygrp-sponsor #yiv0085634656ygrp-lc {font-family:Arial;}#yiv0085634656 #yiv0085634656ygrp-sponsor #yiv0085634656ygrp-lc #yiv0085634656hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0085634656 #yiv0085634656ygrp-sponsor #yiv0085634656ygrp-lc .yiv0085634656ad {margin-bottom:10px;padding:0 0;}#yiv0085634656 #yiv0085634656actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0085634656 #yiv0085634656activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0085634656 #yiv0085634656activity span {font-weight:700;}#yiv0085634656 #yiv0085634656activity span:first-child {text-transform:uppercase;}#yiv0085634656 #yiv0085634656activity span a {color:#5085b6;text-decoration:none;}#yiv0085634656 #yiv0085634656activity span span {color:#ff7900;}#yiv0085634656 #yiv0085634656activity span .yiv0085634656underline {text-decoration:underline;}#yiv0085634656 .yiv0085634656attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0085634656 .yiv0085634656attach div a {text-decoration:none;}#yiv0085634656 .yiv0085634656attach img {border:none;padding-right:5px;}#yiv0085634656 .yiv0085634656attach label {display:block;margin-bottom:5px;}#yiv0085634656 .yiv0085634656attach label a {text-decoration:none;}#yiv0085634656 blockquote {margin:0 0 0 4px;}#yiv0085634656 .yiv0085634656bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0085634656 .yiv0085634656bold a {text-decoration:none;}#yiv0085634656 dd.yiv0085634656last p a {font-family:Verdana;font-weight:700;}#yiv0085634656 dd.yiv0085634656last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0085634656 dd.yiv0085634656last p span.yiv0085634656yshortcuts {margin-right:0;}#yiv0085634656 div.yiv0085634656attach-table div div a {text-decoration:none;}#yiv0085634656 div.yiv0085634656attach-table {width:400px;}#yiv0085634656 div.yiv0085634656file-title a, #yiv0085634656 div.yiv0085634656file-title a:active, #yiv0085634656 div.yiv0085634656file-title a:hover, #yiv0085634656 div.yiv0085634656file-title a:visited {text-decoration:none;}#yiv0085634656 div.yiv0085634656photo-title a, #yiv0085634656 div.yiv0085634656photo-title a:active, #yiv0085634656 div.yiv0085634656photo-title a:hover, #yiv0085634656 div.yiv0085634656photo-title a:visited {text-decoration:none;}#yiv0085634656 div#yiv0085634656ygrp-mlmsg #yiv0085634656ygrp-msg p a span.yiv0085634656yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0085634656 .yiv0085634656green {color:#628c2a;}#yiv0085634656 .yiv0085634656MsoNormal {margin:0 0 0 0;}#yiv0085634656 o {font-size:0;}#yiv0085634656 #yiv0085634656photos div {float:left;width:72px;}#yiv0085634656 #yiv0085634656photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv0085634656 #yiv0085634656photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0085634656 #yiv0085634656reco-category {font-size:77%;}#yiv0085634656 #yiv0085634656reco-desc {font-size:77%;}#yiv0085634656 .yiv0085634656replbq {margin:4px;}#yiv0085634656 #yiv0085634656ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0085634656 #yiv0085634656ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0085634656 #yiv0085634656ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0085634656 #yiv0085634656ygrp-mlmsg select, #yiv0085634656 input, #yiv0085634656 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0085634656 #yiv0085634656ygrp-mlmsg pre, #yiv0085634656 code {font:115% monospace;}#yiv0085634656 #yiv0085634656ygrp-mlmsg * {line-height:1.22em;}#yiv0085634656 #yiv0085634656ygrp-mlmsg #yiv0085634656logo {padding-bottom:10px;}#yiv0085634656 #yiv0085634656ygrp-msg p a {font-family:Verdana;}#yiv0085634656 #yiv0085634656ygrp-msg p#yiv0085634656attach-count span {color:#1E66AE;font-weight:700;}#yiv0085634656 #yiv0085634656ygrp-reco #yiv0085634656reco-head {color:#ff7900;font-weight:700;}#yiv0085634656 #yiv0085634656ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0085634656 #yiv0085634656ygrp-sponsor #yiv0085634656ov li a {font-size:130%;text-decoration:none;}#yiv0085634656 #yiv0085634656ygrp-sponsor #yiv0085634656ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0085634656 #yiv0085634656ygrp-sponsor #yiv0085634656ov ul {margin:0;padding:0 0 0 8px;}#yiv0085634656 #yiv0085634656ygrp-text {font-family:Georgia;}#yiv0085634656 #yiv0085634656ygrp-text p {margin:0 0 1em 0;}#yiv0085634656 #yiv0085634656ygrp-text tt {font-size:120%;}#yiv0085634656 #yiv0085634656ygrp-vital ul li:last-child {border-right:none !important;}#yiv0085634656

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

2a

Re: Nama userform dijadikan variable

Thu Sep 6, 2018 2:13 am (PDT) . Posted by:

"Tio Ali" tioali2011

Terima kasih Mr. Kid atas jawabannya. Semoga Allah membalas kebaikannya dengan berlipat ganda.
Pertanyaannya : Kenapa setelah tambah control (frame) tidak terdeteksi setelah klik tombol List nama Frame ? Kalau tidak tambah control (frame), terdeteksi setelah klik tombol List nama frame . Seharusnya kan kalau tambah Frame, maka terbaca nama controlnya adalah Frame2, tapi selalu hanya Frame1 yang terbaca.
File terlampir..Terima kasih jawabannya.
Wassalamu alaikum.Tio

Pada Rabu, 5 September 2018 15.17.19 WIB, 'Mr. Kid' mr.nmkid@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

 

Begini :public sub ListControl( sForm as string )    dim ctl as control   'tidak pakai s, karena ingin object individu (bukan collection)    dim frm as userform  'tidak pakai s, karena ingin object individu (bukan collection)    on error goto Kid    set frm=userforms.add(sform)
    for each ctl in frm.controls 'pakai s karena butuh koleksi object        debug.print ctl..name,typename(ctl)        'ganti dengan proses yang dibutuhkan
   next ctlKid:   err.clear   on error goto 0
end sub

Regards,Kid

On Wed, Sep 5, 2018 at 11:53 AM Tio Adi Bayu Adjie tio.adjie@ptssb.co.id [belajar-excel] <belajar-excel@yahoogroups.com> wrote:

 

Salam B-Exceller,

Mau tanya.

Saya mau cari tahu nama control di masing-masing userform . Untuk itu saya mau memanggil sub procedure dengan variable nama userform. Permasalahannya saya tidak bisa memanggil berdasarkan nama userform.

Yang sudah saya lakukan adalah.

Contoh: ada 2 userform namanya formmaterial dan myform.

 

Private sub commandbutton1_click

Call listcontrol("formmaterial")

End sub

 

Private sub commandbutton2_click

Call listcontrol("myform")

End sub

 

Public sub listcontrol(strrform as string)

Dim c as controls

For each c in Me.controls 'èyang ini gagal, karena tidak boleh pakai Me.. Yang diinginkan adalah namauserform tergantung dari nama userform dari tiap prosedur yang memanggil.

                Msgbox c.name

Next c

 

End sub

 

 

Terima  kasih. Semoga Allah membalas kebaikannya. Amiin...

 

Best Regards,

Tio

 

#yiv5987878057 #yiv5987878057 -- #yiv5987878057ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5987878057 #yiv5987878057ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5987878057 #yiv5987878057ygrp-mkp #yiv5987878057hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv5987878057 #yiv5987878057ygrp-mkp #yiv5987878057ads {margin-bottom:10px;}#yiv5987878057 #yiv5987878057ygrp-mkp .yiv5987878057ad {padding:0 0;}#yiv5987878057 #yiv5987878057ygrp-mkp .yiv5987878057ad p {margin:0;}#yiv5987878057 #yiv5987878057ygrp-mkp .yiv5987878057ad a {color:#0000ff;text-decoration:none;}#yiv5987878057 #yiv5987878057ygrp-sponsor #yiv5987878057ygrp-lc {font-family:Arial;}#yiv5987878057 #yiv5987878057ygrp-sponsor #yiv5987878057ygrp-lc #yiv5987878057hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5987878057 #yiv5987878057ygrp-sponsor #yiv5987878057ygrp-lc .yiv5987878057ad {margin-bottom:10px;padding:0 0;}#yiv5987878057 #yiv5987878057actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5987878057 #yiv5987878057activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5987878057 #yiv5987878057activity span {font-weight:700;}#yiv5987878057 #yiv5987878057activity span:first-child {text-transform:uppercase;}#yiv5987878057 #yiv5987878057activity span a {color:#5085b6;text-decoration:none;}#yiv5987878057 #yiv5987878057activity span span {color:#ff7900;}#yiv5987878057 #yiv5987878057activity span .yiv5987878057underline {text-decoration:underline;}#yiv5987878057 .yiv5987878057attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv5987878057 .yiv5987878057attach div a {text-decoration:none;}#yiv5987878057 .yiv5987878057attach img {border:none;padding-right:5px;}#yiv5987878057 .yiv5987878057attach label {display:block;margin-bottom:5px;}#yiv5987878057 .yiv5987878057attach label a {text-decoration:none;}#yiv5987878057 blockquote {margin:0 0 0 4px;}#yiv5987878057 .yiv5987878057bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv5987878057 .yiv5987878057bold a {text-decoration:none;}#yiv5987878057 dd.yiv5987878057last p a {font-family:Verdana;font-weight:700;}#yiv5987878057 dd.yiv5987878057last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5987878057 dd.yiv5987878057last p span.yiv5987878057yshortcuts {margin-right:0;}#yiv5987878057 div.yiv5987878057attach-table div div a {text-decoration:none;}#yiv5987878057 div.yiv5987878057attach-table {width:400px;}#yiv5987878057 div.yiv5987878057file-title a, #yiv5987878057 div.yiv5987878057file-title a:active, #yiv5987878057 div.yiv5987878057file-title a:hover, #yiv5987878057 div.yiv5987878057file-title a:visited {text-decoration:none;}#yiv5987878057 div.yiv5987878057photo-title a, #yiv5987878057 div.yiv5987878057photo-title a:active, #yiv5987878057 div.yiv5987878057photo-title a:hover, #yiv5987878057 div.yiv5987878057photo-title a:visited {text-decoration:none;}#yiv5987878057 div#yiv5987878057ygrp-mlmsg #yiv5987878057ygrp-msg p a span.yiv5987878057yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5987878057 ..yiv5987878057green {color:#628c2a;}#yiv5987878057 .yiv5987878057MsoNormal {margin:0 0 0 0;}#yiv5987878057 o {font-size:0;}#yiv5987878057 #yiv5987878057photos div {float:left;width:72px;}#yiv5987878057 #yiv5987878057photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv5987878057 #yiv5987878057photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5987878057 #yiv5987878057reco-category {font-size:77%;}#yiv5987878057 #yiv5987878057reco-desc {font-size:77%;}#yiv5987878057 .yiv5987878057replbq {margin:4px;}#yiv5987878057 #yiv5987878057ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv5987878057 #yiv5987878057ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5987878057 #yiv5987878057ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5987878057 #yiv5987878057ygrp-mlmsg select, #yiv5987878057 input, #yiv5987878057 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv5987878057 #yiv5987878057ygrp-mlmsg pre, #yiv5987878057 code {font:115% monospace;}#yiv5987878057 #yiv5987878057ygrp-mlmsg * {line-height:1.22em;}#yiv5987878057 #yiv5987878057ygrp-mlmsg #yiv5987878057logo {padding-bottom:10px;}#yiv5987878057 #yiv5987878057ygrp-msg p a {font-family:Verdana;}#yiv5987878057 #yiv5987878057ygrp-msg p#yiv5987878057attach-count span {color:#1E66AE;font-weight:700;}#yiv5987878057 #yiv5987878057ygrp-reco #yiv5987878057reco-head {color:#ff7900;font-weight:700;}#yiv5987878057 #yiv5987878057ygrp-reco {margin-bottom:20px;padding:0px;}#yiv5987878057 #yiv5987878057ygrp-sponsor #yiv5987878057ov li a {font-size:130%;text-decoration:none;}#yiv5987878057 #yiv5987878057ygrp-sponsor #yiv5987878057ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv5987878057 #yiv5987878057ygrp-sponsor #yiv5987878057ov ul {margin:0;padding:0 0 0 8px;}#yiv5987878057 #yiv5987878057ygrp-text {font-family:Georgia;}#yiv5987878057 #yiv5987878057ygrp-text p {margin:0 0 1em 0;}#yiv5987878057 #yiv5987878057ygrp-text tt {font-size:120%;}#yiv5987878057 #yiv5987878057ygrp-vital ul li:last-child {border-right:none !important;}#yiv5987878057

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

3

Kelompok Tiket Manjadi Tiket Berurutan

Thu Sep 6, 2018 8:02 pm (PDT) . Posted by:

"Nunuk Y Saptaningtyas"

Selamat pagi semuanya,

Mohon bantuannya, saya harus memakai rumus apa untuk mengurai kelompok
tiket menjadi tiket berurutan (data terlampir)

Atas bantuannya, saya ucapkan terimakasih.

--
Regards,

Nunuk Yuliani Saptaningtyas

www.enyees.com
www.bunbunenyees.blogspot.com

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . 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

• Privacy • Unsubscribe • Terms of Use