Jumat, 31 Maret 2017

[ExcelVBA] File - GroupInfo.txt

 


This automatic email is posted to this group each month for the benefit of new members and as a reminder to current members.

NOTICE VERSION: January, 2012

* This group is monitored by several moderators. In an effort to help weed out spammers, most posts are manually verified before they are released

to the group. Therefore, if you are new to the group or do not regularly participate, it may take a bit longer for your post to show up in the

group. This is normal. We do try to keep watch and release valid posts ASAP. Once you become a recognized/active member of the group, we try to

make sure your membership is validated so that your posts can slide through without monitoring delays.

* Although we do try to keep posts on topic, we also like to be a friendly, community group here, so the occasional chatter between members is not

a problem. If you have something important to post that is "off topic"...please start the subject with OT-, as in "Off Topic" so that it can be

filtered out by those not wishing to be bothered by off topic posts.

* PLAY NICE! Verbal bashing of any kind will NOT be tolerated! If you have a problem with someone in this group...take it outside. If a complaint

is reported about your behavior, you'll be banned from the group...NO questions asked!

* This group has a web site. To locate the URL to the group's web page, see the bottom of any post where additional information is listed. Within

the group's web site, you'll find additional information. Depending on the activity/participation of the group, you may find additional help files

and/or tutorials, as well as other helpful links.

* Sadly, due to spammers, only moderators can post files and links within our group's site. However, if you have something you'd like to

contribute, contact one of the moderators...whose names are listed on the home page of our group's web page.

* Additionally, you cannot attach files to posts...again due to spammers. But if you have a file that you'd like others to see in an attempt to

help you solve a problem, contact a moderator to post the file for you. If you have any trouble contacting a moderator, feel free to request help

by posting to the group with the subject NEED MODERATOR HELP. (By using that EXACT subject, moderators can set an alert to more quickly notice your

post.)

* To get the best help, fast, use a good subject line! Don't just post a subject saying HELP! Give a little detail about the type of help you need.

Also be sure to include some details, such as the content of any error messages, as well as the software version you are using. For more specific

info on how to get the most from your posts, see this link: http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=507#info

* With the help of several wonderful moderators and terrific group participants who regularly share their knowledge, I run a handful of free

support groups. To find our other groups, as well as other groups I recommend for free support, see this link:

http://www.mousetrax.com/resources.html

* And finally, know that you can find many free tutorials linked from my TechPage here: http://www.mousetrax.com/techpage.html and also directly

through TechTrax, my very popular, free ezine (online magazine) here: http://www.techtrax.us

Dian D. Chapman (Group Owner)
Technical Consultant, Microsoft MVP
MOS Certified Instructor, Editor/TechTrax Ezine
Tech Editor for Word & Office 2007 Bibles
https://mvp.support.microsoft.com/profile/Dian.Chapman

Dian's Soldier/K9 Site
http://www.mousetrax.com/dian/angels.html

Free Computer Tutorials: http://www.techtrax.us
Dian's Free User Support Groups: http://www.mousetrax.com/resources.html
Learn VBA the easy way: http://www.mousetrax.com/techcourses.html

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (125)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

.

__,_._,___
READ MORE....

[smf_addin] Digest Number 3952

3 Messages

Digest #3952
1a
Earnings calendar by DefelRadar
1b
Re: Earnings calendar by "Randy Harmelink" rharmelink
1c

Messages

Fri Mar 31, 2017 10:30 am (PDT) . Posted by:

DefelRadar

Hi all,


I have two issues. The first is I used to have a web data query in excel 2010 that I would feed it a date and it would perform a web query to download a list of companies that had earnings for that date from Yahoo's earnings calendar. This has worked for years for me with minor adjustments when Yahoo changed things around. Well Yahoo finally made a major change and my once reliable web query will no longer work and the antiquated web browser in excel throws up so many errors when just loading a page from Yahoo it is laughable.


Does anyone know of another way to accomplish what I was previously doing with the earnings calendar?


Second issue is with excel 2010 where when I open it and try to use my SMF add-in I get an error that the functions are not available. I go to look at my add-ins and SMF is there, checked and happy. The work around I have been doing is uncheck the SMF add-in. Close excel. Open excel. Go to add-ins. Check SMF. Now SMF functions are ready to use again. This is an annoyance that I have tried to figure out and didn't know if others are having the same issue? I also have the ValuSoft add-in for excel and excel seems to be fine with it and does not "forget" the functions used in that add-in.


Thanks!

Fri Mar 31, 2017 11:31 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sorry, but I can't get the add-in to return any data from the Yahoo
earnings calendar pages.

As far as the other problem, that may be the issue that occurred in July of
last year because MicroSoft issued some security updates. It's not letting
EXCEL load the add-in when EXCEL starts up. As a result, you are getting
link errors, because EXCEL can't resolve the links to the add-in.

For a workaround suggested by Microsoft, until they fix the issue, see:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568

On Fri, Mar 31, 2017 at 10:30 AM, defelradar@
​...wrote:

>
>
> Hi all,
>
>
> I have two issues. The first is I used to have a web data query in excel
> 2010 that I would feed it a date and it would perform a web query to
> download a list of companies that had earnings for that date from Yahoo's
> earnings calendar. This has worked for years for me with minor adjustments
> when Yahoo changed things around. Well Yahoo finally made a major change
> and my once reliable web query will no longer work and the antiquated web
> browser in excel throws up so many errors when just loading a page from
> Yahoo it is laughable.
>
>
> Does anyone know of another way to accomplish what I was previously doing
> with the earnings calendar?
>
>
> Second issue is with excel 2010 where when I open it and try to use my SMF
> add-in I get an error that the functions are not available. I go to look
> at my add-ins and SMF is there, checked and happy. The work around I have
> been doing is uncheck the SMF add-in. Close excel. Open excel. Go to
> add-ins. Check SMF. Now SMF functions are ready to use again. This is an
> annoyance that I have tried to figure out and didn't know if others are
> having the same issue? I also have the ValuSoft add-in for excel and excel
> seems to be fine with it and does not "forget" the functions used in that
> add-in.
>
>
>
>

Fri Mar 31, 2017 11:48 am (PDT) . Posted by:

DefelRadar

Thanks Randy,

As far as the earnings calendar I kinda figured you could not get the add-in to return the companies reporting earnings on a particular date. That's why I had a web query doing it for me. I was just wondering if there was anyone else out there doing the same thing I was so I could try using their source/method.


Thanks for the help on the excel security issue. I'm trying the options out and it seemed to break more (some custom functions I wrote will not work now).


I'll keep hacking at it.


Thanks!


Aaron
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
READ MORE....

[belajar-excel] Digest Number 4144

4 Messages

Digest #4144

Messages

Fri Mar 31, 2017 5:26 pm (PDT) . Posted by:


"PERATURAN MILIS belajar-excel"
-------------------------------

Milis belajar-excel dibuat agar menjadi komunitas / tempat berkumpulnya
para pemakai software microsoft excel, untuk saling berbagi pengetahuan
(sharing), diskusi dan tanya-jawab hal-hal yg menyangkut MS Excel.

Setting untuk posting di milis ini masih dipertahankan = "UnModerated"
(member dapat mengirim posting, tanpa melalui moderasi dan langsung
masuk ke message-list di milis).
Posting pertama & kedua dari member yg baru bergabung harus menunggu
approval dari moderators. Jika dinilai wajar, posting selanjutnya tidak
perlu approval lagi.

Hal ini adalah demi menjadikan milis lebih dinamis, posting tidak
tertunda, diskusi lebih hidup.

Tetapi konsekwensinya, kita sebagai members harus punya niat untuk
menjaga milis ini tetap bersih, enak diikuti, yaitu dengan TIDAK
mengirim posting berisi hal yg mubazir, yg di luar topik, yg "nyampah";
apalagi yg memicu timbulnya pertengkaran yg tidak perlu.

Setiap saat para Moderators akan melihat-lihat lagi msg list, dan akan
membersihkan message list dari posting sampah yg tidak perlu.

Untuk itu kita perlu kesepakatan sebagai berikut:

A. SANGAT DIHARAPKAN:
==================

(1)
Posting dari member berupa: share pengetahuan, pertanyaan, jawaban dan/
atau komentar dan tanggapan yg masih relevan dengan pertanyaan/posting;
semuanya harus sekitar atau ada hubungannya dengan Microsoft Excel.

(2)
Size Lampiran dlm rangka memperjelas kasus/penjelasan, agar diupayakan
tidak lebih dari 250KB, jika perlu dicompressed dulu.

(3)
Posting pertanyaan dialamatkan hanya kepada alamat milis, (jangan ke
alamat owner)

(4)
Semua mail dikemukakan secara santun, ceria, menyenangkan, boleh lucu,
saling menghormati, menjauhkan dari masalah SARA.

B. SANGAT TIDAK DIHARAPKAN:
========================

(1)
Mail yg isinya melecehkan, menghina fihak lain, berbahasa kasar, memicu
pertengkaran dsb.

(2)
Posting "too good to be true" misalnya "jualan" (MLM), spam, money game,
hoax, mail berantai dan iklan (tanpa lebihdulu mendapat ijin dari owner).

(3)
Cross-posting (mengirim 1 mail sekaligus kepada lebih dari satu milis /
address tujuan).

(4)
Mail yg ditulis dengan ukuran, bentuk/warna font dan cara yg di luar
kewajaran, sehingga menyulitkan pembacaan.

(5)
Mail tanpa judul/subject dan/atau tanpa isi, walaupun melampirkan penjelasan.

(6)
Menyertakan link yang merujuk kepada halaman yang berisi iklan produk /
informasi yang tidak berhubungan dengan Excel / pertanyaan.

C. LAIN LAIN:
========

Saran & Tips menulis mail / posting ke milis:
---------------------------------------------

(a)
Berikan subject yg isinya mewakili kasus yg akan ditulis.
Hindari subject yg tidak jelas dan terlalu general (misal "tolong",
"help", "tanya" "mohon pencerahan", dsb)

(b)
Ikuti Subject yg telah ada, (dengan meReply), hanya jika masalah yg akan
ditulis masih berkaitan.
Mengubah Subject (misal dgn menambah kata "Balasan" / "Solusi" /
"Tanggapan" dsb, hanya akan merusak 'Thread' (korelasi/kesinambungan)
suatu topik, oleh karena itu jangan dilakukan.

Jika anda akan mengajukan topik/kasus baru yg tidak berkaitan dengan
topik yg telah ada, buatlah Subject baru, dengan Compose / New Mail.
JANGAN dengan cara mereply subject yg ada lalu mengganti subjecnya.

(c)
Terutama pada posting pertanyaan/request, tuliskan masalah dengan jelas
di badan email. Penjelasan lebih rinci dapat ditulis pada lampiran.
Lampiran sedapat mungkin berupa workbook (file *.xls), dengan nama-file
yang spesifik.

(d)
Posting tanggapan/jawaban hendaknya ditulis secara 'top-posting' (di
ATAS "quoted mail" yg ditanggapi, demi mempermudah pembacaan.

'Quoted mail' tidak harus disertakan semua, cukup 1 atau maximal 2 mail
terdahulu.

(e)
Footer yg tidak perlu hendaknya dihapus dulu sebelum mail Anda kirimkan.

Mengenai OOT dan VOOT
---------------------
Di luar 3 jenis posting di atas, yi: DISKUSI yg berisi sharing,
pertanyaan, tanggapan) akan dianggap Out of Topic (OOT) atau bahkan
VOOT (very out of topic).

Kategory OOT akan dipertimbangkan kasus-demi-kasus dengan kriteria
"manfaat positif bagi komunitas kita".

Kategory OOT atas pertimbangan khusus, misalnya demi kepentingan yg
mendesak dan penting, atau demi "kemanusiaan", tidak didelete.
Jika tidak memenuhi kriteria akan didelete dengan atau tanpa pemberi-
tahuan kpd member.

Kategory VOOT, posting akan langsung didelete, pengirim akan diberi
teguran.

VOOT kedua dari pengirim yg sama akan menyebabkan member ybs didisabled
sementara kemampuan postingnya.

Kelanjutan dari suatu diskusi tanya-jawab, masih layak diposted ke milis,
misal hanya ucapan terima kasih atau pun sejenis konfirmasi bahwa suatu
solusi sudah diterima dan dapat dipakai dsb, ini dapat golongkan sbg OOT
yg masih layak tayang.

Kelanjutan pembicaraan yg sudah tidak relevan lagi bagi member lain,
dapat anda teruskan melalui 'japri' (jalur pribadi).

Kritik dan saran kepada milis 'belajar-excel'
--------------------------------------------
Kritik dan saran diluar masalah excel demi perbaikan milis ini dapat
disampaikan ke owner / moderators

Hak dan wewenang Moderators
---------------------------
Moderators berhak setelah mempertimbangkan hal-hal diatas untuk
memberikan kartu kuning atau langsung kartu merah dan/atau
mem-banned members yang melakukan pelanggaran rules milis ini.

Himbauan dari milis 'belajar excel' kpd members
-----------------------------------------------

Diharapkan para members terus meningkatkan pengetahuannya mengenai
kelaziman cara bermilis & ber-net-ria secara umum.

Perlu selalu disadari bahwa di dunia internet, sama dengan dunia kita
sehari hari.
Jika di dunia nyata kita mengenal "etika / ettiquettes", maka di net
ada semacam etika umum yg lazim disebut "nettiquette".

Kalau anda sering tidak mengindahkan "nettiquettes", tidak akan polisi
yg menangkap anda; tetapi lama-lama anda akan dijauhi banyak rekan,
karena mereka tentu merasa tidak nyaman ber-korespondensi dengan anda.

Sebagai Members of "milis belajar-excel" dan sebagai 'netter sejati',
anda tentu tidak suka kalau harus dicap sebagai "tidak nettis" yang
artinya setara dgn "tidak etis".

--------------------------------------------[rev: 13mar2010 / ctv]-----

revisi 2: tgl 02Des2013 / dwint
# penambahan point B.6.

Fri Mar 31, 2017 6:42 pm (PDT) . Posted by:

"Tio Ali" tioali2011

Terima kasih Mr. Kid penjelasannya. Nanti saya coba dulu ya...

Dikirim dari Yahoo Mail di Android

Pada Jum, 31 Mar 2017 pada 17:22, 'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]<belajar-excel@yahoogroups.com> menulis:  

Hai Tio,

Interpolasi maupun ekstrapolasi pada dasarnya adalah mencari persamaan matematika yang mendekati pola yang dibentuk oleh nilai-nilai data.
Persamaan matematika tersebut bisa berpangkat 1 (linear yang berarti berupa persamaan linear dan membentuk garis linear), berpangkat 2 (kuadrat), berpangkat 3 dan sebagainya.

Formula umumnya begini : (semakin banyak record data yang bersih akan semakin baik)
=SumProduct( Linest( data_nilai_y , data_nilai_x^{array pangkat dari 1 sampai tertinggi} ,TRUE,FALSE) * nilai_x_diketahui^{ array pangkat dari tertinggi sampai 0 } )

Contoh : data_nilai_y di B1:B5, data_nilai_x di A1:A5, data di A1:B5 jika dibuat xy scatter chart menampilkan pola kuadrat,
               mencari interpolasi atau ekstrapolasi dari nilai x sebesar 7
*** karena pola kuadrat, maka pangkatnya adalah 2.
      {array pangkat dari 1 sampai tertinggi}  akan berbentuk { 1 , 2 }
      { array pangkat dari tertinggi sampai 0 }  akan berbentuk { 2 , 1 , 0 }
*** nilai_x_diketahui adalah 7

*** Formula : (misal hasilnya di letakkan di cells C9)
      =SumProduct( Linest( B1:B5 , A1:A5 ^ { 1 , 2 } , TRUE , FALSE ) * 7 ^ { 2 , 1 , 0 } )

*** Penjelasan lebih detil bisa dilihat dalam file yang ada disini.

Regards,
Kid

2017-03-31 15:06 GMT+07:00 Tio Adi Bayu Adjie tio.adjie@ptssb.co.id [belajar-excel] <belajar-excel@yahoogroups.com >:

 

Salam BeExceller,

Saya sudah punya formula untuk melihat forecast kedepan dengan melihat 2 nilai yang ada.


Permasalahannya, diluar dari nilai sumber yang ada, ternyata hasilnya error.

Adakah formula untuk melihat forecast kedepan ?

Saya buat dengan formula Lagrange, ternyata sangat sulit (complicated).

File terlampir untuk lebih jelasnya.

 

Mohon pencerahannya.

 

Terima kasih.

 

--- Mod ---

File lampiran yang melebihi 250KB dilepas dari email. Silakan melampirkan ulang file yang lebih sesuai peraturan milis, yaitu maksimal 250KB dengan cara me-reply email ini.

-------------

#yiv4422291693 #yiv4422291693 -- #yiv4422291693ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4422291693 #yiv4422291693ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4422291693 #yiv4422291693ygrp-mkp #yiv4422291693hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4422291693 #yiv4422291693ygrp-mkp #yiv4422291693ads {margin-bottom:10px;}#yiv4422291693 #yiv4422291693ygrp-mkp .yiv4422291693ad {padding:0 0;}#yiv4422291693 #yiv4422291693ygrp-mkp .yiv4422291693ad p {margin:0;}#yiv4422291693 #yiv4422291693ygrp-mkp .yiv4422291693ad a {color:#0000ff;text-decoration:none;}#yiv4422291693 #yiv4422291693ygrp-sponsor #yiv4422291693ygrp-lc {font-family:Arial;}#yiv4422291693 #yiv4422291693ygrp-sponsor #yiv4422291693ygrp-lc #yiv4422291693hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4422291693 #yiv4422291693ygrp-sponsor #yiv4422291693ygrp-lc .yiv4422291693ad {margin-bottom:10px;padding:0 0;}#yiv4422291693 #yiv4422291693actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4422291693 #yiv4422291693activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4422291693 #yiv4422291693activity span {font-weight:700;}#yiv4422291693 #yiv4422291693activity span:first-child {text-transform:uppercase;}#yiv4422291693 #yiv4422291693activity span a {color:#5085b6;text-decoration:none;}#yiv4422291693 #yiv4422291693activity span span {color:#ff7900;}#yiv4422291693 #yiv4422291693activity span .yiv4422291693underline {text-decoration:underline;}#yiv4422291693 .yiv4422291693attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4422291693 .yiv4422291693attach div a {text-decoration:none;}#yiv4422291693 .yiv4422291693attach img {border:none;padding-right:5px;}#yiv4422291693 .yiv4422291693attach label {display:block;margin-bottom:5px;}#yiv4422291693 .yiv4422291693attach label a {text-decoration:none;}#yiv4422291693 blockquote {margin:0 0 0 4px;}#yiv4422291693 .yiv4422291693bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4422291693 .yiv4422291693bold a {text-decoration:none;}#yiv4422291693 dd.yiv4422291693last p a {font-family:Verdana;font-weight:700;}#yiv4422291693 dd.yiv4422291693last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4422291693 dd.yiv4422291693last p span.yiv4422291693yshortcuts {margin-right:0;}#yiv4422291693 div.yiv4422291693attach-table div div a {text-decoration:none;}#yiv4422291693 div.yiv4422291693attach-table {width:400px;}#yiv4422291693 div.yiv4422291693file-title a, #yiv4422291693 div.yiv4422291693file-title a:active, #yiv4422291693 div.yiv4422291693file-title a:hover, #yiv4422291693 div.yiv4422291693file-title a:visited {text-decoration:none;}#yiv4422291693 div.yiv4422291693photo-title a, #yiv4422291693 div.yiv4422291693photo-title a:active, #yiv4422291693 div.yiv4422291693photo-title a:hover, #yiv4422291693 div.yiv4422291693photo-title a:visited {text-decoration:none;}#yiv4422291693 div#yiv4422291693ygrp-mlmsg #yiv4422291693ygrp-msg p a span.yiv4422291693yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4422291693 .yiv4422291693green {color:#628c2a;}#yiv4422291693 .yiv4422291693MsoNormal {margin:0 0 0 0;}#yiv4422291693 o {font-size:0;}#yiv4422291693 #yiv4422291693photos div {float:left;width:72px;}#yiv4422291693 #yiv4422291693photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv4422291693 #yiv4422291693photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4422291693 #yiv4422291693reco-category {font-size:77%;}#yiv4422291693 #yiv4422291693reco-desc {font-size:77%;}#yiv4422291693 .yiv4422291693replbq {margin:4px;}#yiv4422291693 #yiv4422291693ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4422291693 #yiv4422291693ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4422291693 #yiv4422291693ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4422291693 #yiv4422291693ygrp-mlmsg select, #yiv4422291693 input, #yiv4422291693 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4422291693 #yiv4422291693ygrp-mlmsg pre, #yiv4422291693 code {font:115% monospace;}#yiv4422291693 #yiv4422291693ygrp-mlmsg * {line-height:1.22em;}#yiv4422291693 #yiv4422291693ygrp-mlmsg #yiv4422291693logo {padding-bottom:10px;}#yiv4422291693 #yiv4422291693ygrp-msg p a {font-family:Verdana;}#yiv4422291693 #yiv4422291693ygrp-msg p#yiv4422291693attach-count span {color:#1E66AE;font-weight:700;}#yiv4422291693 #yiv4422291693ygrp-reco #yiv4422291693reco-head {color:#ff7900;font-weight:700;}#yiv4422291693 #yiv4422291693ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4422291693 #yiv4422291693ygrp-sponsor #yiv4422291693ov li a {font-size:130%;text-decoration:none;}#yiv4422291693 #yiv4422291693ygrp-sponsor #yiv4422291693ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4422291693 #yiv4422291693ygrp-sponsor #yiv4422291693ov ul {margin:0;padding:0 0 0 8px;}#yiv4422291693 #yiv4422291693ygrp-text {font-family:Georgia;}#yiv4422291693 #yiv4422291693ygrp-text p {margin:0 0 1em 0;}#yiv4422291693 #yiv4422291693ygrp-text tt {font-size:120%;}#yiv4422291693 #yiv4422291693ygrp-vital ul li:last-child {border-right:none !important;}#yiv4422291693

Fri Mar 31, 2017 6:42 pm (PDT) . Posted by:

"Tio Ali" tioali2011

Terima kasih Mr. Kid atas penjelasannya yang panjang lebar. Semoga Allah SWT membalasnya. Amiin

Dikirim dari Yahoo Mail di Android

Pada Jum, 31 Mar 2017 pada 18:35, 'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]<belajar-excel@yahoogroups.com> menulis:  

Hai Tio,

Pada sebuah cells, contoh 2 tidak bisa karena sifat properti Text pada sebuah cells adalah read only.

Secara umum, jika mengambil nilai properti :
a. Text : yang diambil adalah yang tampak dan nilainya bertipe text.
b. Value : yang diambil adalah nilai yang sesuai datatype nya
c. Value2 (khusus untuk cells) : yang diambil adalah nilai aslilnya.

Contoh :
Jika di cells A1 diketik 2017-03-31 lalu menekan Enter
Kemudian di A1 di custom format dengan cara di klik kanan A1 -> format cells -> tab Number -> pilih Custom -> textbox format diisi :
        [$-421]dd-yyyy
lalu tekan OK
maka di cells A1 :
a. akan tampak dihadapan user berisi bunyi  31-2017
    properti Text menghasilkan teks berbunyi 31-2017
b. walau di A1 sudah di Custom format, sejatinya di A1 ada nilai bertipe datetime yang bernilai 2017-03-31 (atau dengan format regional setting komputer setempat)
    properti value akan menghasilkan datetime bernilai 2017-03-31
c. data bertipe datetime sejatinya adalah sebuah bilangan serial date. 2017-03-31 memiliki serial date senilai 42825
    properti Value2 akan menghasilkan nilai bertipe double bernilai 42825

Pada sebuah activex controls, maka yang ada adalah properti text atau value bila controls tersebut memilikinya dan tidak ada properti Value2. Sifatnya read/write.
a. Pada textbox, kedua properti ini akan menyimpan nilai yang sama, yaitu bertipe text
b. Pada listbox atau combobox, properti value dan text bisa berbeda isinya karena tergantung properti BoundColumn dan TextColumn.
    Jika properti ini bernilai sama, maka properti text dan value akan menyimpan nilai yang sama.

Contoh :
Listbox atau combobox berisi 3 kolom, kolom ke-1 adalah Nama, kolom ke-2 adalah berat badan, kolom ke-3 Jenis kelamin
Jika boundcolumn di set bernilai 2 dan textcolumn diset bernilai 3,
maka properti value akan menghasilkan nilai dari kolom ke-2 yaitu nilai berat badan
dan properti text akan menghasilkan nilai dari kolom ke-3 yaitu jenis kelamin.

Regards,
Kid

2017-03-31 13:51 GMT+07:00 Tio Adi Bayu Adjie tio.adjie@ptssb.co.id [belajar-excel] <belajar-excel@yahoogroups.com>:

 

Salam Be-Exceller,

Mau Tanya, sintax .value dengan .text apa bedanya ?

 

Contoh :

1.      Cells(1,1).value="bla-bla-bla"

2.      Cells(1,1).text="ba-bi-bu"

 

Kedua sintax diatas, apa bedanya ? Biasanya saya selalu pakai .value , tidak pernah pakai .text sekalipun itu format text dan tidak pernah ada masalah. Kalau pemakaiannya beda, apa masalahnya ?

 

Mohon pencerahannya.

 

Wassalamu alaikum Wr. Wb.

 

 

#yiv8893623354 #yiv8893623354 -- #yiv8893623354ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8893623354 #yiv8893623354ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8893623354 #yiv8893623354ygrp-mkp #yiv8893623354hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8893623354 #yiv8893623354ygrp-mkp #yiv8893623354ads {margin-bottom:10px;}#yiv8893623354 #yiv8893623354ygrp-mkp .yiv8893623354ad {padding:0 0;}#yiv8893623354 #yiv8893623354ygrp-mkp .yiv8893623354ad p {margin:0;}#yiv8893623354 #yiv8893623354ygrp-mkp .yiv8893623354ad a {color:#0000ff;text-decoration:none;}#yiv8893623354 #yiv8893623354ygrp-sponsor #yiv8893623354ygrp-lc {font-family:Arial;}#yiv8893623354 #yiv8893623354ygrp-sponsor #yiv8893623354ygrp-lc #yiv8893623354hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8893623354 #yiv8893623354ygrp-sponsor #yiv8893623354ygrp-lc .yiv8893623354ad {margin-bottom:10px;padding:0 0;}#yiv8893623354 #yiv8893623354actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8893623354 #yiv8893623354activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8893623354 #yiv8893623354activity span {font-weight:700;}#yiv8893623354 #yiv8893623354activity span:first-child {text-transform:uppercase;}#yiv8893623354 #yiv8893623354activity span a {color:#5085b6;text-decoration:none;}#yiv8893623354 #yiv8893623354activity span span {color:#ff7900;}#yiv8893623354 #yiv8893623354activity span .yiv8893623354underline {text-decoration:underline;}#yiv8893623354 .yiv8893623354attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8893623354 .yiv8893623354attach div a {text-decoration:none;}#yiv8893623354 .yiv8893623354attach img {border:none;padding-right:5px;}#yiv8893623354 .yiv8893623354attach label {display:block;margin-bottom:5px;}#yiv8893623354 .yiv8893623354attach label a {text-decoration:none;}#yiv8893623354 blockquote {margin:0 0 0 4px;}#yiv8893623354 .yiv8893623354bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8893623354 .yiv8893623354bold a {text-decoration:none;}#yiv8893623354 dd.yiv8893623354last p a {font-family:Verdana;font-weight:700;}#yiv8893623354 dd.yiv8893623354last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8893623354 dd.yiv8893623354last p span.yiv8893623354yshortcuts {margin-right:0;}#yiv8893623354 div.yiv8893623354attach-table div div a {text-decoration:none;}#yiv8893623354 div.yiv8893623354attach-table {width:400px;}#yiv8893623354 div.yiv8893623354file-title a, #yiv8893623354 div.yiv8893623354file-title a:active, #yiv8893623354 div.yiv8893623354file-title a:hover, #yiv8893623354 div.yiv8893623354file-title a:visited {text-decoration:none;}#yiv8893623354 div.yiv8893623354photo-title a, #yiv8893623354 div.yiv8893623354photo-title a:active, #yiv8893623354 div.yiv8893623354photo-title a:hover, #yiv8893623354 div.yiv8893623354photo-title a:visited {text-decoration:none;}#yiv8893623354 div#yiv8893623354ygrp-mlmsg #yiv8893623354ygrp-msg p a span.yiv8893623354yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8893623354 .yiv8893623354green {color:#628c2a;}#yiv8893623354 .yiv8893623354MsoNormal {margin:0 0 0 0;}#yiv8893623354 o {font-size:0;}#yiv8893623354 #yiv8893623354photos div {float:left;width:72px;}#yiv8893623354 #yiv8893623354photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv8893623354 #yiv8893623354photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8893623354 #yiv8893623354reco-category {font-size:77%;}#yiv8893623354 #yiv8893623354reco-desc {font-size:77%;}#yiv8893623354 .yiv8893623354replbq {margin:4px;}#yiv8893623354 #yiv8893623354ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8893623354 #yiv8893623354ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8893623354 #yiv8893623354ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8893623354 #yiv8893623354ygrp-mlmsg select, #yiv8893623354 input, #yiv8893623354 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8893623354 #yiv8893623354ygrp-mlmsg pre, #yiv8893623354 code {font:115% monospace;}#yiv8893623354 #yiv8893623354ygrp-mlmsg * {line-height:1.22em;}#yiv8893623354 #yiv8893623354ygrp-mlmsg #yiv8893623354logo {padding-bottom:10px;}#yiv8893623354 #yiv8893623354ygrp-msg p a {font-family:Verdana;}#yiv8893623354 #yiv8893623354ygrp-msg p#yiv8893623354attach-count span {color:#1E66AE;font-weight:700;}#yiv8893623354 #yiv8893623354ygrp-reco #yiv8893623354reco-head {color:#ff7900;font-weight:700;}#yiv8893623354 #yiv8893623354ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8893623354 #yiv8893623354ygrp-sponsor #yiv8893623354ov li a {font-size:130%;text-decoration:none;}#yiv8893623354 #yiv8893623354ygrp-sponsor #yiv8893623354ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8893623354 #yiv8893623354ygrp-sponsor #yiv8893623354ov ul {margin:0;padding:0 0 0 8px;}#yiv8893623354 #yiv8893623354ygrp-text {font-family:Georgia;}#yiv8893623354 #yiv8893623354ygrp-text p {margin:0 0 1em 0;}#yiv8893623354 #yiv8893623354ygrp-text tt {font-size:120%;}#yiv8893623354 #yiv8893623354ygrp-vital ul li:last-child {border-right:none !important;}#yiv8893623354

Fri Mar 31, 2017 6:42 pm (PDT) . Posted by:

"Tio Ali" tioali2011

Terima kasih Mr. Kid penjelasannya. Semoga Allah SWT membalasnya. Amiin.

Dikirim dari Yahoo Mail di Android

Pada Kam, 30 Mar 2017 pada 18:12, 'Mr. Kid' mr.nmkid@gmail.com [belajar-excel]<belajar-excel@yahoogroups.com> menulis:  

Hai Tio,

Touch screen itu kan karakteristik layar. Layar yang merespon sentuhan (touch) dinamakan touch screen. Jadi bukan karena aplikasi tertentu.
Touch screen di Excel 2013 ke atas sekadar memfasilitasi user yang sudah menggunakan monitor touch screen (monitornya memang touch screen). Fasilitas touch screen xl2013 ke atas sekadar membuat item-item ribbon menjadi lebih besar dan renggang agar touch yang dilakukan user tidak kena ke item yang lain.

Simpelnya, sudah punya monitor yang touch screen, lalu jari jemarinya segede gaban (kaya jari saya misalnya), biar ngekliknya gak nyangkut-ngakut dibarang lainnya, maka si touch mode diaktifkan. Begitu si touch mode diaktifkan, maka ribbon akan jadi renggang dan gambar aikonnya juga jadi gede. Nah jari gaban tadi bisa pas deh ngkliknya.

;)

2017-03-30 17:28 GMT+07:00 Tio Adi Bayu Adjie tio.adjie@ptssb.co.id [belajar-excel] <belajar-excel@yahoogroups.com>:

 

Mr. Kid.

Sebelumnya saya pernah berkunjung di perusahaan listrik dan ketika masuk pertama kali, ada dashboard perusahaan yang tombolnya di click pakai tangan (bukan mouse).

Saya cari di internet, ternyata ada fitur di excel 2013. Terlampir tampilannya. Saya jadi bertanya-tanya, apakah di fitur 2010 ada/tidak? Ternyata tidak ada fitur di ribbon modenya.

Pertanyaannya, bagaimana alternative lain kalau tidak tersedia fiturnya ? Begitu ceritanya, Mr. Kid.

 

Terima kasih sebelumya.

Regards,

Tio

 

From: belajar-excel@yahoogroups.com [mailto:belajar-excel@ yahoogroups.com]
Sent: Thursday, March 30, 2017 3:35 PM
To: BeExcel
Subject: Re: [belajar-excel] Touch Screen di Excel

 

 

Hai Tio,

Fitur Touch Screen itu yang seperti apa to ?

Gunanya fitur Touch Screen itu buat apa ya ?

 

 

2017-03-30 15:24 GMT+07:00 Tio Adi Bayu Adjie tio.adjie@ptssb.co.id [belajar-excel] <belajar-excel@yahoogroups.com >:

 

Dear para BeExceller,

 

Mau Tanya. Adakah fitur touch screen untuk Ms. Excel khusunya 2003-2010 ? Kalau tidak ada, bagaimana menggunakan vb untuk menggunakan touch screen ?

 

 

Terima Kasih.

Regards,

Tio

 

 

 

.

 

#yiv6812372618 #yiv6812372618 -- #yiv6812372618ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6812372618 #yiv6812372618ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6812372618 #yiv6812372618ygrp-mkp #yiv6812372618hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv6812372618 #yiv6812372618ygrp-mkp #yiv6812372618ads {margin-bottom:10px;}#yiv6812372618 #yiv6812372618ygrp-mkp .yiv6812372618ad {padding:0 0;}#yiv6812372618 #yiv6812372618ygrp-mkp .yiv6812372618ad p {margin:0;}#yiv6812372618 #yiv6812372618ygrp-mkp .yiv6812372618ad a {color:#0000ff;text-decoration:none;}#yiv6812372618 #yiv6812372618ygrp-sponsor #yiv6812372618ygrp-lc {font-family:Arial;}#yiv6812372618 #yiv6812372618ygrp-sponsor #yiv6812372618ygrp-lc #yiv6812372618hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6812372618 #yiv6812372618ygrp-sponsor #yiv6812372618ygrp-lc .yiv6812372618ad {margin-bottom:10px;padding:0 0;}#yiv6812372618 #yiv6812372618actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6812372618 #yiv6812372618activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6812372618 #yiv6812372618activity span {font-weight:700;}#yiv6812372618 #yiv6812372618activity span:first-child {text-transform:uppercase;}#yiv6812372618 #yiv6812372618activity span a {color:#5085b6;text-decoration:none;}#yiv6812372618 #yiv6812372618activity span span {color:#ff7900;}#yiv6812372618 #yiv6812372618activity span .yiv6812372618underline {text-decoration:underline;}#yiv6812372618 .yiv6812372618attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv6812372618 .yiv6812372618attach div a {text-decoration:none;}#yiv6812372618 .yiv6812372618attach img {border:none;padding-right:5px;}#yiv6812372618 .yiv6812372618attach label {display:block;margin-bottom:5px;}#yiv6812372618 .yiv6812372618attach label a {text-decoration:none;}#yiv6812372618 blockquote {margin:0 0 0 4px;}#yiv6812372618 .yiv6812372618bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv6812372618 .yiv6812372618bold a {text-decoration:none;}#yiv6812372618 dd.yiv6812372618last p a {font-family:Verdana;font-weight:700;}#yiv6812372618 dd.yiv6812372618last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6812372618 dd.yiv6812372618last p span.yiv6812372618yshortcuts {margin-right:0;}#yiv6812372618 div.yiv6812372618attach-table div div a {text-decoration:none;}#yiv6812372618 div.yiv6812372618attach-table {width:400px;}#yiv6812372618 div.yiv6812372618file-title a, #yiv6812372618 div.yiv6812372618file-title a:active, #yiv6812372618 div.yiv6812372618file-title a:hover, #yiv6812372618 div.yiv6812372618file-title a:visited {text-decoration:none;}#yiv6812372618 div.yiv6812372618photo-title a, #yiv6812372618 div.yiv6812372618photo-title a:active, #yiv6812372618 div.yiv6812372618photo-title a:hover, #yiv6812372618 div.yiv6812372618photo-title a:visited {text-decoration:none;}#yiv6812372618 div#yiv6812372618ygrp-mlmsg #yiv6812372618ygrp-msg p a span.yiv6812372618yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6812372618 .yiv6812372618green {color:#628c2a;}#yiv6812372618 .yiv6812372618MsoNormal {margin:0 0 0 0;}#yiv6812372618 o {font-size:0;}#yiv6812372618 #yiv6812372618photos div {float:left;width:72px;}#yiv6812372618 #yiv6812372618photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv6812372618 #yiv6812372618photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6812372618 #yiv6812372618reco-category {font-size:77%;}#yiv6812372618 #yiv6812372618reco-desc {font-size:77%;}#yiv6812372618 .yiv6812372618replbq {margin:4px;}#yiv6812372618 #yiv6812372618ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv6812372618 #yiv6812372618ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6812372618 #yiv6812372618ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6812372618 #yiv6812372618ygrp-mlmsg select, #yiv6812372618 input, #yiv6812372618 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv6812372618 #yiv6812372618ygrp-mlmsg pre, #yiv6812372618 code {font:115% monospace;}#yiv6812372618 #yiv6812372618ygrp-mlmsg * {line-height:1.22em;}#yiv6812372618 #yiv6812372618ygrp-mlmsg #yiv6812372618logo {padding-bottom:10px;}#yiv6812372618 #yiv6812372618ygrp-msg p a {font-family:Verdana;}#yiv6812372618 #yiv6812372618ygrp-msg p#yiv6812372618attach-count span {color:#1E66AE;font-weight:700;}#yiv6812372618 #yiv6812372618ygrp-reco #yiv6812372618reco-head {color:#ff7900;font-weight:700;}#yiv6812372618 #yiv6812372618ygrp-reco {margin-bottom:20px;padding:0px;}#yiv6812372618 #yiv6812372618ygrp-sponsor #yiv6812372618ov li a {font-size:130%;text-decoration:none;}#yiv6812372618 #yiv6812372618ygrp-sponsor #yiv6812372618ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv6812372618 #yiv6812372618ygrp-sponsor #yiv6812372618ov ul {margin:0;padding:0 0 0 8px;}#yiv6812372618 #yiv6812372618ygrp-text {font-family:Georgia;}#yiv6812372618 #yiv6812372618ygrp-text p {margin:0 0 1em 0;}#yiv6812372618 #yiv6812372618ygrp-text tt {font-size:120%;}#yiv6812372618 #yiv6812372618ygrp-vital ul li:last-child {border-right:none !important;}#yiv6812372618
============================================================
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
---------------------------------------------------------------------
READ MORE....