[belajar-excel] Digest Number 2054

Milis Belajar Microsoft Excel Group

8 New Messages

Digest #2054

1a

Re: date & time picker by "Mulki" mulki_akbar

1b

Re: date & time picker by "M. Ferdiansyah" muh_f3rdi4n5yah

1c

Re: date & time picker by "M. Ferdiansyah" muh_f3rdi4n5yah

1d

Re: date & time picker by "Mulki" mulki_akbar

1e

Re: date & time picker by "Mr. Kid" nmkid.family@ymail.com

2

materi freelance by "Adhimas Rizki" semutbalap13

3a

Re: Belajar bikin Drop Down by "Emohi Rino Lailatul Kodar" rino_rochman

3b

Re: Belajar bikin Drop Down by "Mr. Kid" nmkid.family@ymail.com

Messages

1a

Re: date & time picker

Thu Jan 31, 2013 6:10 pm (PST) . Posted by:

"Mulki" mulki_akbar

Dear Pak Ferdy,

ikut nimbrung boleh ya ...

Menu Develor itu ada dimana ya ? saya pake excel 2007 dan belum melihat menu tersbt ?

oia, sekalian saya juga blm tau cara memunculkan date pickernya :)

Mohon pencerahannya.

Wassalam,
mulki

----- Original Message -----
From: M. Ferdiansyah
To: belajar-excel@yahoogroups.com
Sent: Friday, February 01, 2013 8:48 AM
Subject: Re: [belajar-excel] date & time picker

Dear Pak Faisal,

Tahap"annya:
1. Pilih Menu Develor
2. Klik/Aktifkan Design Mode
3. Klik kanan Pada DTPicker --> Properties
4. Pada Windows Properties, LinkedCell tentukan cell yang akan dilinkkan
(Sebagai Contoh D5)
5. Enter
6. Tutup Windows Properties, Nonaktifkan/klik kembali Design Mode
7. Coba Ubah tanggal pada DTPickernya, alhasil pada cell D5 akan mengikuti
DTPickernya.

Semoga Berhasil,

wassalam,
Ferdy

> dear suhu excel
>
> satu lagi pertanyaan / kasus saya. bagaimana menampilkan
> hasil pemilihan di date & time picker
> ke cell yang diinginkan
> contoh terlampir
>
> salam
>
> faisal
>

____________ _________ _________ _________ _________ _________ _________
Notice : This e-mail (and any attachment) is strictly confidential and
is intended only for the addressee(s)above. Is strictly prohibited to
forward, print, copy, or otherwise reproduce this message that would
allow it to be viewed by any individual not originally listed as
a recipient(s). If you have received this e-mail in error, please
immediately notify the sender and delete this message. The opinions
expressed in this e-mail (and any attachment) are those of the individual
sender and may not necessarily reflect the views of PT Pusri.
____________ _________ _________ _________ _________ _________ _________

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

1b

Re: date & time picker

Thu Jan 31, 2013 6:34 pm (PST) . Posted by:

"M. Ferdiansyah" muh_f3rdi4n5yah

Dear pak Mulki,

Untuk menampilkan Menu Develor:
1. Pada Menu Start (sudut kiri atas) pilih Excel Option
2. Popular, Top options for working with excel
3. Contreng "Show Develor tab in the Ribbon"
4. Ok

Berhubung cuma user, jadi masih kurang tau jg pak tentang memunculkan date
pickernya, itu aja cuma copy paste dari file" sebelumnya..
Hehe :)

wassalam,
Ferdy

> Dear Pak Ferdy,
>
> ikut nimbrung boleh ya ...
>
> Menu Develor itu ada dimana ya ? saya pake excel 2007 dan belum melihat
> menu tersbt ?
>
> oia, sekalian saya juga blm tau cara memunculkan date pickernya :)
>
> Mohon pencerahannya.
>
>
> Wassalam,
> mulki
>
>
> ----- Original Message -----
> From: M. Ferdiansyah
> To: belajar-excel@yahoogroups.com
> Sent: Friday, February 01, 2013 8:48 AM
> Subject: Re: [belajar-excel] date & time picker
>
>
>
> Dear Pak Faisal,
>
> Tahap"annya:
> 1. Pilih Menu Develor
> 2. Klik/Aktifkan Design Mode
> 3. Klik kanan Pada DTPicker --> Properties
> 4. Pada Windows Properties, LinkedCell tentukan cell yang akan dilinkkan
> (Sebagai Contoh D5)
> 5. Enter
> 6. Tutup Windows Properties, Nonaktifkan/klik kembali Design Mode
> 7. Coba Ubah tanggal pada DTPickernya, alhasil pada cell D5 akan
> mengikuti
> DTPickernya.
>
> Semoga Berhasil,
>
> wassalam,
> Ferdy
>
> > dear suhu excel
> >
> > satu lagi pertanyaan / kasus saya. bagaimana menampilkan
> > hasil pemilihan di date & time picker
> > ke cell yang diinginkan
> > contoh terlampir
> >
> > salam
> >
> > faisal
> >
>
> ____________ _________ _________ _________ _________ _________ _________
> Notice : This e-mail (and any attachment) is strictly confidential and
> is intended only for the addressee(s)above. Is strictly prohibited to
> forward, print, copy, or otherwise reproduce this message that would
> allow it to be viewed by any individual not originally listed as
> a recipient(s). If you have received this e-mail in error, please
> immediately notify the sender and delete this message. The opinions
> expressed in this e-mail (and any attachment) are those of the
> individual
> sender and may not necessarily reflect the views of PT Pusri.
> ____________ _________ _________ _________ _________ _________ _________
>
>

____________ _________ _________ _________ _________ _________ _________
Notice : This e-mail (and any attachment) is strictly confidential and
is intended only for the addressee(s)above. Is strictly prohibited to
forward, print, copy, or otherwise reproduce this message that would
allow it to be viewed by any individual not originally listed as
a recipient(s). If you have received this e-mail in error, please
immediately notify the sender and delete this message. The opinions
expressed in this e-mail (and any attachment) are those of the individual
sender and may not necessarily reflect the views of PT Pusri.
____________ _________ _________ _________ _________ _________ _________

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

1c

Re: date & time picker

Thu Jan 31, 2013 6:40 pm (PST) . Posted by:

"M. Ferdiansyah" muh_f3rdi4n5yah

Eh, coba otak atik, ternyata masih banyak toolboxnya selain DTPicker..

Coba cek di :
1. Menu Develor
2. Insert
3. ActiveX Controls --> More Controls
4. untuk DTPicker pilih "Microsoft Date and Time Picker Control 6.0
(SP6)", Ok
alhasil tampil dah DTPicker.

Suatu pembelajaran baru.

Semoga bermanfaat,

wassalam,
Ferdy

> Dear pak Mulki,
>
> Untuk menampilkan Menu Develor:
> 1. Pada Menu Start (sudut kiri atas) pilih Excel Option
> 2. Popular, Top options for working with excel
> 3. Contreng "Show Develor tab in the Ribbon"
> 4. Ok
>
> Berhubung cuma user, jadi masih kurang tau jg pak tentang memunculkan date
> pickernya, itu aja cuma copy paste dari file" sebelumnya..
> Hehe :)
>
> wassalam,
> Ferdy
>
>
>> Dear Pak Ferdy,
>>
>> ikut nimbrung boleh ya ...
>>
>> Menu Develor itu ada dimana ya ? saya pake excel 2007 dan belum melihat
>> menu tersbt ?
>>
>> oia, sekalian saya juga blm tau cara memunculkan date pickernya :)
>>
>> Mohon pencerahannya.
>>
>>
>> Wassalam,
>> mulki
>>
>>
>> ----- Original Message -----
>> From: M. Ferdiansyah
>> To: belajar-excel@yahoogroups.com
>> Sent: Friday, February 01, 2013 8:48 AM
>> Subject: Re: [belajar-excel] date & time picker
>>
>>
>>
>> Dear Pak Faisal,
>>
>> Tahap"annya:
>> 1. Pilih Menu Develor
>> 2. Klik/Aktifkan Design Mode
>> 3. Klik kanan Pada DTPicker --> Properties
>> 4. Pada Windows Properties, LinkedCell tentukan cell yang akan
>> dilinkkan
>> (Sebagai Contoh D5)
>> 5. Enter
>> 6. Tutup Windows Properties, Nonaktifkan/klik kembali Design Mode
>> 7. Coba Ubah tanggal pada DTPickernya, alhasil pada cell D5 akan
>> mengikuti
>> DTPickernya.
>>
>> Semoga Berhasil,
>>
>> wassalam,
>> Ferdy
>>
>> > dear suhu excel
>> >
>> > satu lagi pertanyaan / kasus saya. bagaimana menampilkan
>> > hasil pemilihan di date & time picker
>> > ke cell yang diinginkan
>> > contoh terlampir
>> >
>> > salam
>> >
>> > faisal
>> >
>>
>> ____________ _________ _________ _________ _________ _________
>> _________
>> Notice : This e-mail (and any attachment) is strictly confidential and
>> is intended only for the addressee(s)above. Is strictly prohibited to
>> forward, print, copy, or otherwise reproduce this message that would
>> allow it to be viewed by any individual not originally listed as
>> a recipient(s). If you have received this e-mail in error, please
>> immediately notify the sender and delete this message. The opinions
>> expressed in this e-mail (and any attachment) are those of the
>> individual
>> sender and may not necessarily reflect the views of PT Pusri.
>> ____________ _________ _________ _________ _________ _________
>> _________
>>
>>
>
>
>
> ____________ _________ _________ _________ _________ _________ _________
> Notice : This e-mail (and any attachment) is strictly confidential and
> is intended only for the addressee(s)above. Is strictly prohibited to
> forward, print, copy, or otherwise reproduce this message that would
> allow it to be viewed by any individual not originally listed as
> a recipient(s). If you have received this e-mail in error, please
> immediately notify the sender and delete this message. The opinions
> expressed in this e-mail (and any attachment) are those of the individual
> sender and may not necessarily reflect the views of PT Pusri.
> ____________ _________ _________ _________ _________ _________ _________
>
>

____________ _________ _________ _________ _________ _________ _________
Notice : This e-mail (and any attachment) is strictly confidential and
is intended only for the addressee(s)above. Is strictly prohibited to
forward, print, copy, or otherwise reproduce this message that would
allow it to be viewed by any individual not originally listed as
a recipient(s). If you have received this e-mail in error, please
immediately notify the sender and delete this message. The opinions
expressed in this e-mail (and any attachment) are those of the individual
sender and may not necessarily reflect the views of PT Pusri.
____________ _________ _________ _________ _________ _________ _________

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

1d

Re: date & time picker

Thu Jan 31, 2013 7:12 pm (PST) . Posted by:

"Mulki" mulki_akbar

alhamdulillah bisa pak, terimakasih jg atas ilmu dan pencerahannya ..

Mengenai aplikasinya pada excel, saya tunggu jawaban dari kasus yg dilemparkan rekan2 disini aja :)

Wassalam,
mulki

----- Original Message -----
From: M. Ferdiansyah
To: belajar-excel@yahoogroups.com
Sent: Friday, February 01, 2013 9:40 AM
Subject: Re: [belajar-excel] date & time picker

Eh, coba otak atik, ternyata masih banyak toolboxnya selain DTPicker..

Coba cek di :
1. Menu Develor
2. Insert
3. ActiveX Controls --> More Controls
4. untuk DTPicker pilih "Microsoft Date and Time Picker Control 6.0
(SP6)", Ok
alhasil tampil dah DTPicker.

Suatu pembelajaran baru.

Semoga bermanfaat,

wassalam,
Ferdy

> Dear pak Mulki,
>
> Untuk menampilkan Menu Develor:
> 1. Pada Menu Start (sudut kiri atas) pilih Excel Option
> 2. Popular, Top options for working with excel
> 3. Contreng "Show Develor tab in the Ribbon"
> 4. Ok
>
> Berhubung cuma user, jadi masih kurang tau jg pak tentang memunculkan date
> pickernya, itu aja cuma copy paste dari file" sebelumnya..
> Hehe :)
>
> wassalam,
> Ferdy
>
>
>> Dear Pak Ferdy,
>>
>> ikut nimbrung boleh ya ...
>>
>> Menu Develor itu ada dimana ya ? saya pake excel 2007 dan belum melihat
>> menu tersbt ?
>>
>> oia, sekalian saya juga blm tau cara memunculkan date pickernya :)
>>
>> Mohon pencerahannya.
>>
>>
>> Wassalam,
>> mulki
>>
>>
>> ----- Original Message -----
>> From: M. Ferdiansyah
>> To: belajar-excel@yahoogroups.com
>> Sent: Friday, February 01, 2013 8:48 AM
>> Subject: Re: [belajar-excel] date & time picker
>>
>>
>>
>> Dear Pak Faisal,
>>
>> Tahap"annya:
>> 1. Pilih Menu Develor
>> 2. Klik/Aktifkan Design Mode
>> 3. Klik kanan Pada DTPicker --> Properties
>> 4. Pada Windows Properties, LinkedCell tentukan cell yang akan
>> dilinkkan
>> (Sebagai Contoh D5)
>> 5. Enter
>> 6. Tutup Windows Properties, Nonaktifkan/klik kembali Design Mode
>> 7. Coba Ubah tanggal pada DTPickernya, alhasil pada cell D5 akan
>> mengikuti
>> DTPickernya.
>>
>> Semoga Berhasil,
>>
>> wassalam,
>> Ferdy
>>
>> > dear suhu excel
>> >
>> > satu lagi pertanyaan / kasus saya. bagaimana menampilkan
>> > hasil pemilihan di date & time picker
>> > ke cell yang diinginkan
>> > contoh terlampir
>> >
>> > salam
>> >
>> > faisal
>> >
>>
>> ____________ _________ _________ _________ _________ _________
>> _________
>> Notice : This e-mail (and any attachment) is strictly confidential and
>> is intended only for the addressee(s)above. Is strictly prohibited to
>> forward, print, copy, or otherwise reproduce this message that would
>> allow it to be viewed by any individual not originally listed as
>> a recipient(s). If you have received this e-mail in error, please
>> immediately notify the sender and delete this message. The opinions
>> expressed in this e-mail (and any attachment) are those of the
>> individual
>> sender and may not necessarily reflect the views of PT Pusri.
>> ____________ _________ _________ _________ _________ _________
>> _________
>>
>>
>
>
>
> ____________ _________ _________ _________ _________ _________ _________
> Notice : This e-mail (and any attachment) is strictly confidential and
> is intended only for the addressee(s)above. Is strictly prohibited to
> forward, print, copy, or otherwise reproduce this message that would
> allow it to be viewed by any individual not originally listed as
> a recipient(s). If you have received this e-mail in error, please
> immediately notify the sender and delete this message. The opinions
> expressed in this e-mail (and any attachment) are those of the individual
> sender and may not necessarily reflect the views of PT Pusri.
> ____________ _________ _________ _________ _________ _________ _________
>
>

____________ _________ _________ _________ _________ _________ _________
Notice : This e-mail (and any attachment) is strictly confidential and
is intended only for the addressee(s)above. Is strictly prohibited to
forward, print, copy, or otherwise reproduce this message that would
allow it to be viewed by any individual not originally listed as
a recipient(s). If you have received this e-mail in error, please
immediately notify the sender and delete this message. The opinions
expressed in this e-mail (and any attachment) are those of the individual
sender and may not necessarily reflect the views of PT Pusri.
____________ _________ _________ _________ _________ _________ _________

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

1e

Re: date & time picker

Thu Jan 31, 2013 7:16 pm (PST) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

Hai Faisal,

File terlampir berisi cara mengatur properties LinkedCell datetime picker
control (bisa diterapkan untuk control lain yang memiliki properti ini).
Disertakan juga cara mengeluarkan ribbon Developer (untuk Excel 2007) dan
menambah control ke dalam sheet yang tidak ada dalam daftar control bawaan
Excel.

Wassalam,
Kid.

2013/2/1 Faisal Hasman revolter_ichal@yahoo.com>

> **
>
>
> dear suhu excel
>
> satu lagi pertanyaan / kasus saya. bagaimana menampilkan
> hasil pemilihan di date & time picker
> ke cell yang diinginkan
> contoh terlampir
>
> salam
>
> faisal
>
> _
>

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

2

materi freelance

Thu Jan 31, 2013 6:27 pm (PST) . Posted by:

"Adhimas Rizki" semutbalap13

salam kenal,
Saya baru join ke milis ini, saya juga masih newbie belajar excel, karena saya baru mempelajarinya, hehe
saya punya beberapa pertanyaan..
waktu itu saya tertarik dengan freelance, ada kerjaan yang tipe nya seperti entri data, online / offlline
nah, kebanyakan untuk bisa ikut freelance tsb, salah satu syaratnya harus bisa ms.excel
nah pertanyaannya, apa aja materi materi excel yang untuk bagian freelance tersebut?
terimakasih ^_^

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

3a

Re: Belajar bikin Drop Down

Thu Jan 31, 2013 6:28 pm (PST) . Posted by:

"Emohi Rino Lailatul Kodar" rino_rochman

Maaf... Saya gak mudeng dengan penjelasannya, Mr. Kid. Itu bikin name
rangenya di sheet "iface" atau di sheet "ref"?

*dasar otak dudul*

Pada 31 Januari 2013 15.49, Bledhuk bledhuk@yahoo.com> menulis:

> **
>
>
> ** Kalo masih dalam satu workbook bisa dibuat define name lalu scope nya
> pilih workbook
> Tab Formula > klik define name
> Powered by BlackBerry®
> ------------------------------
> *From: * Emohi Rino Lailatul Kodar bunda.azhima@gmail.com>
> *Sender: * belajar-excel@yahoogroups.com
> *Date: *Thu, 31 Jan 2013 15:11:24 +0700
> *To: *belajar-excel@yahoogroups.com>
> *ReplyTo: * belajar-excel@yahoogroups.com
> *Subject: *Re: [belajar-excel] Belajar bikin Drop Down
>
>
>
> Terima kasih, Mr. Kid... Sudah dicoba dan bisa...!
>
> Nah, bagaimana kalau membuat nama siswa terpisah sheet dari sheet drop
> downnya...
> On Jan 31, 2013 1:59 PM, "Mr. Kid" mr.nmkid@gmail.com> wrote:
>
>> **
>>
>>
>> Wa'alaikumussalam Wr. Wb.
>>
>> Coba file terlampir.
>> Syaratnya, data kelas dan nama terurut berdasar kolom kelas agar bisa
>> mendapatkan kelas yang berurutan dan bisa dirujuk sebagai sebuah area.
>>
>> Wassalamu'alaikum Wr. Wb.
>> Kid.
>>
>> 2013/1/31 Emohi Rino Lailatul Kodar bunda.azhima@gmail.com>
>>
>>> **
>>>
>>>
>>> Assalamu'alaikum wr wb
>>>
>>> Selamat siang Exceler semua. Saya udah bebrapa bulan ikut di milist ini,
>>> tapi baru ikutan nimbrung sekarang.
>>> Saya masih pemula niy, mohon bimbingannya ya....
>>>
>>> Saya ingin bikin drop down nama siswa berdasarkan kelas yang dipilih.
>>> gimana caranya, ya...? File terlampir. Mohon bimbingannya...
>>>
>>> Wassalaamu'alaikum wr wb
>>>
>>> --
>>> Salam,
>>>
>>> *Lailatul Qadr*
>>>
>>>
>>
>

--
Salam,

*Lailatul Qadr*

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

3b

Re: Belajar bikin Drop Down

Thu Jan 31, 2013 6:38 pm (PST) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

Nama range yang dijelaskan dalam contoh file tempo lalu, *bisa dibuat di
sheet manapun* selama scope adalah workbook.
Pada contoh tersebut, sudah dibuat nama range bernama _dtKelas_ dan
_dtSiswa_ yang digunakan oleh data validation di kolom X.
Jika akan mencoba sendiri, maka nama range harus berbeda (bukan _dtKelas_
dan _dtSiswa_)

Wassalam,
Kid.

2013/2/1 Emohi Rino Lailatul Kodar bunda.azhima@gmail.com>

> **
>
>
> Maaf... Saya gak mudeng dengan penjelasannya, Mr. Kid. Itu bikin name
> rangenya di sheet "iface" atau di sheet "ref"?
>
> *dasar otak dudul*
>
>
> Pada 31 Januari 2013 15.49, Bledhuk bledhuk@yahoo.com> menulis:
>
> **
>>
>>
>> ** Kalo masih dalam satu workbook bisa dibuat define name lalu scope nya
>> pilih workbook
>> Tab Formula > klik define name
>> Powered by BlackBerry®
>> ------------------------------
>> *From: * Emohi Rino Lailatul Kodar bunda.azhima@gmail.com>
>> *Sender: * belajar-excel@yahoogroups.com
>> *Date: *Thu, 31 Jan 2013 15:11:24 +0700
>> *To: *belajar-excel@yahoogroups.com>
>> *ReplyTo: * belajar-excel@yahoogroups.com
>> *Subject: *Re: [belajar-excel] Belajar bikin Drop Down
>>
>>
>>
>> Terima kasih, Mr. Kid... Sudah dicoba dan bisa...!
>>
>> Nah, bagaimana kalau membuat nama siswa terpisah sheet dari sheet drop
>> downnya...
>> On Jan 31, 2013 1:59 PM, "Mr. Kid" mr.nmkid@gmail.com> wrote:
>>
>>> **
>>>
>>>
>>> Wa'alaikumussalam Wr. Wb.
>>>
>>> Coba file terlampir.
>>> Syaratnya, data kelas dan nama terurut berdasar kolom kelas agar bisa
>>> mendapatkan kelas yang berurutan dan bisa dirujuk sebagai sebuah area.
>>>
>>> Wassalamu'alaikum Wr. Wb.
>>> Kid.
>>>
>>> 2013/1/31 Emohi Rino Lailatul Kodar bunda.azhima@gmail.com>
>>>
>>>> **
>>>>
>>>>
>>>> Assalamu'alaikum wr wb
>>>>
>>>> Selamat siang Exceler semua. Saya udah bebrapa bulan ikut di milist
>>>> ini, tapi baru ikutan nimbrung sekarang.
>>>> Saya masih pemula niy, mohon bimbingannya ya....
>>>>
>>>> Saya ingin bikin drop down nama siswa berdasarkan kelas yang dipilih.
>>>> gimana caranya, ya...? File terlampir. Mohon bimbingannya...
>>>>
>>>> Wassalaamu'alaikum wr wb
>>>>
>>>> --
>>>> Salam,
>>>>
>>>> *Lailatul Qadr*
>>>>
>>>>
>>>
>
>
> --
> Salam,
>
> *Lailatul Qadr*
>
>
>

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

Visit Your Group

>

View All Topics

>

Create New Topic

>

14 New Members

>

2 New Files

>

We are making changes based on your feedback, Thank you !

Submit Feedback

>

The Yahoo! Groups Product Blog

Check it out!

>

GROUP FOOTER MESSAGE

---------------------------------------------------------------------
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
---------------------------------------------------------------------

CHANGE SETTINGS

>

TERMS OF USE

>

UNSUBSCRIBE

>