Kamis, 08 Januari 2015

[belajar-excel] Digest Number 3254

3 Messages

Digest #3254
2a
Re: Converter excel VBA by "hendrik karnadi" hendrikkarnadi
3a
Fungsi IF by "Ahmad Syaifullah Lubis" syaifullah

Messages

Wed Jan 7, 2015 5:47 am (PST) . Posted by:

angan_lov3

permisi para master semua.. adakah yg sudah bertanya cara membuat excel dapat menerima dan mengirim SMS? bagaimana cara membuatnya? thanks!

Wed Jan 7, 2015 9:33 pm (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Hai Walsoyo,Kalau maksudnya Convert ke .exe file (sekaligus melindungi VBA nya) bisa dicari di internet.
Salam,HK

From: "Walsoyo soyomakmur@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Wednesday, 7 January 2015, 10:57
Subject: [belajar-excel] Converter excel VBA

  Mohon bantuannya yang punya Converter excel saya lagi membutuhkan.
atau ada yang tahu bagai mana melindungi kode vba hasil kerja kita!
Pleasa!!
#yiv3029426626 -- #yiv3029426626ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3029426626 #yiv3029426626ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3029426626 #yiv3029426626ygrp-mkp #yiv3029426626hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3029426626 #yiv3029426626ygrp-mkp #yiv3029426626ads {margin-bottom:10px;}#yiv3029426626 #yiv3029426626ygrp-mkp .yiv3029426626ad {padding:0 0;}#yiv3029426626 #yiv3029426626ygrp-mkp .yiv3029426626ad p {margin:0;}#yiv3029426626 #yiv3029426626ygrp-mkp .yiv3029426626ad a {color:#0000ff;text-decoration:none;}#yiv3029426626 #yiv3029426626ygrp-sponsor #yiv3029426626ygrp-lc {font-family:Arial;}#yiv3029426626 #yiv3029426626ygrp-sponsor #yiv3029426626ygrp-lc #yiv3029426626hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3029426626 #yiv3029426626ygrp-sponsor #yiv3029426626ygrp-lc .yiv3029426626ad {margin-bottom:10px;padding:0 0;}#yiv3029426626 #yiv3029426626actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3029426626 #yiv3029426626activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3029426626 #yiv3029426626activity span {font-weight:700;}#yiv3029426626 #yiv3029426626activity span:first-child {text-transform:uppercase;}#yiv3029426626 #yiv3029426626activity span a {color:#5085b6;text-decoration:none;}#yiv3029426626 #yiv3029426626activity span span {color:#ff7900;}#yiv3029426626 #yiv3029426626activity span .yiv3029426626underline {text-decoration:underline;}#yiv3029426626 .yiv3029426626attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3029426626 .yiv3029426626attach div a {text-decoration:none;}#yiv3029426626 .yiv3029426626attach img {border:none;padding-right:5px;}#yiv3029426626 .yiv3029426626attach label {display:block;margin-bottom:5px;}#yiv3029426626 .yiv3029426626attach label a {text-decoration:none;}#yiv3029426626 blockquote {margin:0 0 0 4px;}#yiv3029426626 .yiv3029426626bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3029426626 .yiv3029426626bold a {text-decoration:none;}#yiv3029426626 dd.yiv3029426626last p a {font-family:Verdana;font-weight:700;}#yiv3029426626 dd.yiv3029426626last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3029426626 dd.yiv3029426626last p span.yiv3029426626yshortcuts {margin-right:0;}#yiv3029426626 div.yiv3029426626attach-table div div a {text-decoration:none;}#yiv3029426626 div.yiv3029426626attach-table {width:400px;}#yiv3029426626 div.yiv3029426626file-title a, #yiv3029426626 div.yiv3029426626file-title a:active, #yiv3029426626 div.yiv3029426626file-title a:hover, #yiv3029426626 div.yiv3029426626file-title a:visited {text-decoration:none;}#yiv3029426626 div.yiv3029426626photo-title a, #yiv3029426626 div.yiv3029426626photo-title a:active, #yiv3029426626 div.yiv3029426626photo-title a:hover, #yiv3029426626 div.yiv3029426626photo-title a:visited {text-decoration:none;}#yiv3029426626 div#yiv3029426626ygrp-mlmsg #yiv3029426626ygrp-msg p a span.yiv3029426626yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3029426626 .yiv3029426626green {color:#628c2a;}#yiv3029426626 .yiv3029426626MsoNormal {margin:0 0 0 0;}#yiv3029426626 o {font-size:0;}#yiv3029426626 #yiv3029426626photos div {float:left;width:72px;}#yiv3029426626 #yiv3029426626photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3029426626 #yiv3029426626photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3029426626 #yiv3029426626reco-category {font-size:77%;}#yiv3029426626 #yiv3029426626reco-desc {font-size:77%;}#yiv3029426626 .yiv3029426626replbq {margin:4px;}#yiv3029426626 #yiv3029426626ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3029426626 #yiv3029426626ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3029426626 #yiv3029426626ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3029426626 #yiv3029426626ygrp-mlmsg select, #yiv3029426626 input, #yiv3029426626 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3029426626 #yiv3029426626ygrp-mlmsg pre, #yiv3029426626 code {font:115% monospace;}#yiv3029426626 #yiv3029426626ygrp-mlmsg * {line-height:1.22em;}#yiv3029426626 #yiv3029426626ygrp-mlmsg #yiv3029426626logo {padding-bottom:10px;}#yiv3029426626 #yiv3029426626ygrp-msg p a {font-family:Verdana;}#yiv3029426626 #yiv3029426626ygrp-msg p#yiv3029426626attach-count span {color:#1E66AE;font-weight:700;}#yiv3029426626 #yiv3029426626ygrp-reco #yiv3029426626reco-head {color:#ff7900;font-weight:700;}#yiv3029426626 #yiv3029426626ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3029426626 #yiv3029426626ygrp-sponsor #yiv3029426626ov li a {font-size:130%;text-decoration:none;}#yiv3029426626 #yiv3029426626ygrp-sponsor #yiv3029426626ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3029426626 #yiv3029426626ygrp-sponsor #yiv3029426626ov ul {margin:0;padding:0 0 0 8px;}#yiv3029426626 #yiv3029426626ygrp-text {font-family:Georgia;}#yiv3029426626 #yiv3029426626ygrp-text p {margin:0 0 1em 0;}#yiv3029426626 #yiv3029426626ygrp-text tt {font-size:120%;}#yiv3029426626 #yiv3029426626ygrp-vital ul li:last-child {border-right:none !important;}#yiv3029426626

Thu Jan 8, 2015 2:53 am (PST) . Posted by:

"Ahmad Syaifullah Lubis" syaifullah

.

Dear BeExceller,Mohon bantuannya bagaimana cara menggunakan fungsi "IF" untuk mengambil karakter yang sesuai.contoh saya ingin mendapatkan karakter "MNI", apabila data ada unsur "MNI" maka hasilnya adalah "MNI", namun bila tidak ada karakter "MNI" maka hasilnya dibuatkan "Salah".123/PRKM/MNI/X/2014 - OVB from MNI Jkt -> hasilnya "MNI"124/PR/MNI/X/2014 - OVB from MMP -> hasilnya "SALAH"125/PR/MNI/X/2014 - OVB from Achmad MNI -> hasilnya "MNI"126/PK/MNI/X/2014 - MNI advanced Jkt -> hasilnya "MNI"127/PK/MMP/X/2014 - Advanced MMP Bdg -> hasilnya "SALAH"
Data tsb saya letakkan di row A2 dan seterusnya.

kemudian di row B2 saya masukkan rumus if
=IF(A16="*MNI*";"MNI";"SALAH&quot;)tetapi hasilnya tidak akurat.
sekali lagi mohon dibantu.
Terima kasih,ASL
============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com

posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com

berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages

melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/

menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com

keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------

Tidak ada komentar:

Poskan Komentar