[belajar-excel] kalender macro [1 Attachment]

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[belajar-excel] kalender macro [1 Attachment]

Milis Belajar Excel mailing list
Dear para Expert

 Saya dapat form kalender yang sudah saya pakai namun ada yang saya minta bantuan agar tanggal yang tampil bisa dipilh dengan "ENTER" kalau bawaannya dengan double click agar bisa menggunakan keyboard saja untuk mempercepat pekerjaan
 

 Terima kasih







 
 
 




Afe_Kalender With UserForm.xlsm (26K) Download Attachment
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Bls: [belajar-excel] kalender macro

Milis Belajar Excel mailing list
Dear Cahyo,
Sudah pernah menggunakan MonthView, coba menggunakan MonthView dengan Event DateClick.Dibanding menggunakan "Enter" untuk mencari tanggal yang dinginkan, akan lebih mudah dengan menggunakan mouse pointer untuk memilih tanggal, tinggal click aja..
TerimaKasih.

    Pada Selasa, 6 Desember 2016 17:10, "imam cahyo yuwono [hidden email] [belajar-excel]" <[hidden email]> menulis:
 

     Dear para Expert
Saya dapat form kalender yang sudah saya pakai namun ada yang saya minta bantuan agar tanggal yang tampil bisa dipilh dengan "ENTER" kalau bawaannya dengan double click agar bisa menggunakan keyboard saja untuk mempercepat pekerjaan
Terima kasih


     #yiv0464001270 #yiv0464001270 -- #yiv0464001270ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0464001270 #yiv0464001270ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0464001270 #yiv0464001270ygrp-mkp #yiv0464001270hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0464001270 #yiv0464001270ygrp-mkp #yiv0464001270ads {margin-bottom:10px;}#yiv0464001270 #yiv0464001270ygrp-mkp .yiv0464001270ad {padding:0 0;}#yiv0464001270 #yiv0464001270ygrp-mkp .yiv0464001270ad p {margin:0;}#yiv0464001270 #yiv0464001270ygrp-mkp .yiv0464001270ad a {color:#0000ff;text-decoration:none;}#yiv0464001270 #yiv0464001270ygrp-sponsor #yiv0464001270ygrp-lc {font-family:Arial;}#yiv0464001270 #yiv0464001270ygrp-sponsor #yiv0464001270ygrp-lc #yiv0464001270hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0464001270 #yiv0464001270ygrp-sponsor #yiv0464001270ygrp-lc .yiv0464001270ad {margin-bottom:10px;padding:0 0;}#yiv0464001270 #yiv0464001270actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0464001270 #yiv0464001270activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0464001270 #yiv0464001270activity span {font-weight:700;}#yiv0464001270 #yiv0464001270activity span:first-child {text-transform:uppercase;}#yiv0464001270 #yiv0464001270activity span a {color:#5085b6;text-decoration:none;}#yiv0464001270 #yiv0464001270activity span span {color:#ff7900;}#yiv0464001270 #yiv0464001270activity span .yiv0464001270underline {text-decoration:underline;}#yiv0464001270 .yiv0464001270attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0464001270 .yiv0464001270attach div a {text-decoration:none;}#yiv0464001270 .yiv0464001270attach img {border:none;padding-right:5px;}#yiv0464001270 .yiv0464001270attach label {display:block;margin-bottom:5px;}#yiv0464001270 .yiv0464001270attach label a {text-decoration:none;}#yiv0464001270 blockquote {margin:0 0 0 4px;}#yiv0464001270 .yiv0464001270bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0464001270 .yiv0464001270bold a {text-decoration:none;}#yiv0464001270 dd.yiv0464001270last p a {font-family:Verdana;font-weight:700;}#yiv0464001270 dd.yiv0464001270last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0464001270 dd.yiv0464001270last p span.yiv0464001270yshortcuts {margin-right:0;}#yiv0464001270 div.yiv0464001270attach-table div div a {text-decoration:none;}#yiv0464001270 div.yiv0464001270attach-table {width:400px;}#yiv0464001270 div.yiv0464001270file-title a, #yiv0464001270 div.yiv0464001270file-title a:active, #yiv0464001270 div.yiv0464001270file-title a:hover, #yiv0464001270 div.yiv0464001270file-title a:visited {text-decoration:none;}#yiv0464001270 div.yiv0464001270photo-title a, #yiv0464001270 div.yiv0464001270photo-title a:active, #yiv0464001270 div.yiv0464001270photo-title a:hover, #yiv0464001270 div.yiv0464001270photo-title a:visited {text-decoration:none;}#yiv0464001270 div#yiv0464001270ygrp-mlmsg #yiv0464001270ygrp-msg p a span.yiv0464001270yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0464001270 .yiv0464001270green {color:#628c2a;}#yiv0464001270 .yiv0464001270MsoNormal {margin:0 0 0 0;}#yiv0464001270 o {font-size:0;}#yiv0464001270 #yiv0464001270photos div {float:left;width:72px;}#yiv0464001270 #yiv0464001270photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv0464001270 #yiv0464001270photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0464001270 #yiv0464001270reco-category {font-size:77%;}#yiv0464001270 #yiv0464001270reco-desc {font-size:77%;}#yiv0464001270 .yiv0464001270replbq {margin:4px;}#yiv0464001270 #yiv0464001270ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0464001270 #yiv0464001270ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0464001270 #yiv0464001270ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0464001270 #yiv0464001270ygrp-mlmsg select, #yiv0464001270 input, #yiv0464001270 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0464001270 #yiv0464001270ygrp-mlmsg pre, #yiv0464001270 code {font:115% monospace;}#yiv0464001270 #yiv0464001270ygrp-mlmsg * {line-height:1.22em;}#yiv0464001270 #yiv0464001270ygrp-mlmsg #yiv0464001270logo {padding-bottom:10px;}#yiv0464001270 #yiv0464001270ygrp-msg p a {font-family:Verdana;}#yiv0464001270 #yiv0464001270ygrp-msg p#yiv0464001270attach-count span {color:#1E66AE;font-weight:700;}#yiv0464001270 #yiv0464001270ygrp-reco #yiv0464001270reco-head {color:#ff7900;font-weight:700;}#yiv0464001270 #yiv0464001270ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0464001270 #yiv0464001270ygrp-sponsor #yiv0464001270ov li a {font-size:130%;text-decoration:none;}#yiv0464001270 #yiv0464001270ygrp-sponsor #yiv0464001270ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0464001270 #yiv0464001270ygrp-sponsor #yiv0464001270ov ul {margin:0;padding:0 0 0 8px;}#yiv0464001270 #yiv0464001270ygrp-text {font-family:Georgia;}#yiv0464001270 #yiv0464001270ygrp-text p {margin:0 0 1em 0;}#yiv0464001270 #yiv0464001270ygrp-text tt {font-size:120%;}#yiv0464001270 #yiv0464001270ygrp-vital ul li:last-child {border-right:none !important;}#yiv0464001270

   
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Bls: [belajar-excel] kalender macro

Milis Belajar Excel mailing list
terima kasih mr Toby,





    On Wednesday, December 7, 2016 9:19 AM, "Toby kenzo [hidden email] [belajar-excel]" <[hidden email]> wrote:



     Dear Cahyo,
Sudah pernah menggunakan MonthView, coba menggunakan MonthView dengan Event DateClick.Dibanding menggunakan "Enter" untuk mencari tanggal yang dinginkan, akan lebih mudah dengan menggunakan mouse pointer untuk memilih tanggal, tinggal click aja..
TerimaKasih.


    Pada Selasa, 6 Desember 2016 17:10, "imam cahyo yuwono [hidden email] [belajar-excel]" <[hidden email]> menulis:



     Dear para Expert
Saya dapat form kalender yang sudah saya pakai namun ada yang saya minta bantuan agar tanggal yang tampil bisa dipilh dengan "ENTER" kalau bawaannya dengan double click agar bisa menggunakan keyboard saja untuk mempercepat pekerjaan
Terima kasih







     #yiv1426456440 #yiv1426456440 -- #yiv1426456440ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1426456440 #yiv1426456440ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1426456440 #yiv1426456440ygrp-mkp #yiv1426456440hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1426456440 #yiv1426456440ygrp-mkp #yiv1426456440ads {margin-bottom:10px;}#yiv1426456440 #yiv1426456440ygrp-mkp .yiv1426456440ad {padding:0 0;}#yiv1426456440 #yiv1426456440ygrp-mkp .yiv1426456440ad p {margin:0;}#yiv1426456440 #yiv1426456440ygrp-mkp .yiv1426456440ad a {color:#0000ff;text-decoration:none;}#yiv1426456440 #yiv1426456440ygrp-sponsor #yiv1426456440ygrp-lc {font-family:Arial;}#yiv1426456440 #yiv1426456440ygrp-sponsor #yiv1426456440ygrp-lc #yiv1426456440hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1426456440 #yiv1426456440ygrp-sponsor #yiv1426456440ygrp-lc .yiv1426456440ad {margin-bottom:10px;padding:0 0;}#yiv1426456440 #yiv1426456440actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1426456440 #yiv1426456440activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1426456440 #yiv1426456440activity span {font-weight:700;}#yiv1426456440 #yiv1426456440activity span:first-child {text-transform:uppercase;}#yiv1426456440 #yiv1426456440activity span a {color:#5085b6;text-decoration:none;}#yiv1426456440 #yiv1426456440activity span span {color:#ff7900;}#yiv1426456440 #yiv1426456440activity span .yiv1426456440underline {text-decoration:underline;}#yiv1426456440 .yiv1426456440attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1426456440 .yiv1426456440attach div a {text-decoration:none;}#yiv1426456440 .yiv1426456440attach img {border:none;padding-right:5px;}#yiv1426456440 .yiv1426456440attach label {display:block;margin-bottom:5px;}#yiv1426456440 .yiv1426456440attach label a {text-decoration:none;}#yiv1426456440 blockquote {margin:0 0 0 4px;}#yiv1426456440 .yiv1426456440bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1426456440 .yiv1426456440bold a {text-decoration:none;}#yiv1426456440 dd.yiv1426456440last p a {font-family:Verdana;font-weight:700;}#yiv1426456440 dd.yiv1426456440last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1426456440 dd.yiv1426456440last p span.yiv1426456440yshortcuts {margin-right:0;}#yiv1426456440 div.yiv1426456440attach-table div div a {text-decoration:none;}#yiv1426456440 div.yiv1426456440attach-table {width:400px;}#yiv1426456440 div.yiv1426456440file-title a, #yiv1426456440 div.yiv1426456440file-title a:active, #yiv1426456440 div.yiv1426456440file-title a:hover, #yiv1426456440 div.yiv1426456440file-title a:visited {text-decoration:none;}#yiv1426456440 div.yiv1426456440photo-title a, #yiv1426456440 div.yiv1426456440photo-title a:active, #yiv1426456440 div.yiv1426456440photo-title a:hover, #yiv1426456440 div.yiv1426456440photo-title a:visited {text-decoration:none;}#yiv1426456440 div#yiv1426456440ygrp-mlmsg #yiv1426456440ygrp-msg p a span.yiv1426456440yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1426456440 .yiv1426456440green {color:#628c2a;}#yiv1426456440 .yiv1426456440MsoNormal {margin:0 0 0 0;}#yiv1426456440 o {font-size:0;}#yiv1426456440 #yiv1426456440photos div {float:left;width:72px;}#yiv1426456440 #yiv1426456440photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv1426456440 #yiv1426456440photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1426456440 #yiv1426456440reco-category {font-size:77%;}#yiv1426456440 #yiv1426456440reco-desc {font-size:77%;}#yiv1426456440 .yiv1426456440replbq {margin:4px;}#yiv1426456440 #yiv1426456440ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1426456440 #yiv1426456440ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1426456440 #yiv1426456440ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1426456440 #yiv1426456440ygrp-mlmsg select, #yiv1426456440 input, #yiv1426456440 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1426456440 #yiv1426456440ygrp-mlmsg pre, #yiv1426456440 code {font:115% monospace;}#yiv1426456440 #yiv1426456440ygrp-mlmsg * {line-height:1.22em;}#yiv1426456440 #yiv1426456440ygrp-mlmsg #yiv1426456440logo {padding-bottom:10px;}#yiv1426456440 #yiv1426456440ygrp-msg p a {font-family:Verdana;}#yiv1426456440 #yiv1426456440ygrp-msg p#yiv1426456440attach-count span {color:#1E66AE;font-weight:700;}#yiv1426456440 #yiv1426456440ygrp-reco #yiv1426456440reco-head {color:#ff7900;font-weight:700;}#yiv1426456440 #yiv1426456440ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1426456440 #yiv1426456440ygrp-sponsor #yiv1426456440ov li a {font-size:130%;text-decoration:none;}#yiv1426456440 #yiv1426456440ygrp-sponsor #yiv1426456440ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1426456440 #yiv1426456440ygrp-sponsor #yiv1426456440ov ul {margin:0;padding:0 0 0 8px;}#yiv1426456440 #yiv1426456440ygrp-text {font-family:Georgia;}#yiv1426456440 #yiv1426456440ygrp-text p {margin:0 0 1em 0;}#yiv1426456440 #yiv1426456440ygrp-text tt {font-size:120%;}#yiv1426456440 #yiv1426456440ygrp-vital ul li:last-child {border-right:none !important;}#yiv1426456440


Loading...