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: [email protected] 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: [email protected] >> 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. ____________ _________ _________ _________ _________ _________ _________
