Dear Jajang,
Bisa mengguna VBA dengan memanfaatkan procedure "Worksheet_Activate()".Dengan
membandingkan tanggal yang sudah di state dengan tanggal hari saat ini, misal
kita sudah meng-state tanggal saat ini (18/2/2017) maka besok pada tanggal
19/2/2017 bisa di bandingkan dengan tanggal 18/2/2017, perbandingannya bisa
menggunakan, contoh:Jika hari ini lebih besar dari tanggal 18/2/2017, maka cell
A1 akan menjadi 0.Jadi jika ada membuka sheet pada hari dimana lebih besar dari
tanggal 18/2/2017, maka di Cell A1 akan menjadi 0 nilainya.
TerimaKasih.
Pada Sabtu, 18 Februari 2017 16:32, "jajang muhammad siddik
[email protected] [belajar-excel]" <[email protected]> menulis:
Selamat siang para master excel,
langsung saja ya, misal di cell A1 = "10", saya mau ketika file ini di buka di
esok hari (pergantian tanggal,) angka di cell tersebut berubah menjadi nol
("0"). pun begitu tanggal seterus nya, setiap buka file di tanggal baru,
otomatis reset ke angka nol
Terimakasih banyak.
Salam,
jajang
#yiv8250128421 #yiv8250128421 -- #yiv8250128421ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8250128421
#yiv8250128421ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8250128421
#yiv8250128421ygrp-mkp #yiv8250128421hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8250128421 #yiv8250128421ygrp-mkp #yiv8250128421ads
{margin-bottom:10px;}#yiv8250128421 #yiv8250128421ygrp-mkp .yiv8250128421ad
{padding:0 0;}#yiv8250128421 #yiv8250128421ygrp-mkp .yiv8250128421ad p
{margin:0;}#yiv8250128421 #yiv8250128421ygrp-mkp .yiv8250128421ad a
{color:#0000ff;text-decoration:none;}#yiv8250128421 #yiv8250128421ygrp-sponsor
#yiv8250128421ygrp-lc {font-family:Arial;}#yiv8250128421
#yiv8250128421ygrp-sponsor #yiv8250128421ygrp-lc #yiv8250128421hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8250128421
#yiv8250128421ygrp-sponsor #yiv8250128421ygrp-lc .yiv8250128421ad
{margin-bottom:10px;padding:0 0;}#yiv8250128421 #yiv8250128421actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8250128421
#yiv8250128421activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8250128421
#yiv8250128421activity span {font-weight:700;}#yiv8250128421
#yiv8250128421activity span:first-child
{text-transform:uppercase;}#yiv8250128421 #yiv8250128421activity span a
{color:#5085b6;text-decoration:none;}#yiv8250128421 #yiv8250128421activity span
span {color:#ff7900;}#yiv8250128421 #yiv8250128421activity span
.yiv8250128421underline {text-decoration:underline;}#yiv8250128421
.yiv8250128421attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8250128421 .yiv8250128421attach div a
{text-decoration:none;}#yiv8250128421 .yiv8250128421attach img
{border:none;padding-right:5px;}#yiv8250128421 .yiv8250128421attach label
{display:block;margin-bottom:5px;}#yiv8250128421 .yiv8250128421attach label a
{text-decoration:none;}#yiv8250128421 blockquote {margin:0 0 0
4px;}#yiv8250128421 .yiv8250128421bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8250128421
.yiv8250128421bold a {text-decoration:none;}#yiv8250128421 dd.yiv8250128421last
p a {font-family:Verdana;font-weight:700;}#yiv8250128421 dd.yiv8250128421last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8250128421
dd.yiv8250128421last p span.yiv8250128421yshortcuts
{margin-right:0;}#yiv8250128421 div.yiv8250128421attach-table div div a
{text-decoration:none;}#yiv8250128421 div.yiv8250128421attach-table
{width:400px;}#yiv8250128421 div.yiv8250128421file-title a, #yiv8250128421
div.yiv8250128421file-title a:active, #yiv8250128421
div.yiv8250128421file-title a:hover, #yiv8250128421 div.yiv8250128421file-title
a:visited {text-decoration:none;}#yiv8250128421 div.yiv8250128421photo-title a,
#yiv8250128421 div.yiv8250128421photo-title a:active, #yiv8250128421
div.yiv8250128421photo-title a:hover, #yiv8250128421
div.yiv8250128421photo-title a:visited {text-decoration:none;}#yiv8250128421
div#yiv8250128421ygrp-mlmsg #yiv8250128421ygrp-msg p a
span.yiv8250128421yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8250128421
.yiv8250128421green {color:#628c2a;}#yiv8250128421 .yiv8250128421MsoNormal
{margin:0 0 0 0;}#yiv8250128421 o {font-size:0;}#yiv8250128421
#yiv8250128421photos div {float:left;width:72px;}#yiv8250128421
#yiv8250128421photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv8250128421
#yiv8250128421photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8250128421
#yiv8250128421reco-category {font-size:77%;}#yiv8250128421
#yiv8250128421reco-desc {font-size:77%;}#yiv8250128421 .yiv8250128421replbq
{margin:4px;}#yiv8250128421 #yiv8250128421ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8250128421 #yiv8250128421ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8250128421
#yiv8250128421ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8250128421
#yiv8250128421ygrp-mlmsg select, #yiv8250128421 input, #yiv8250128421 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8250128421
#yiv8250128421ygrp-mlmsg pre, #yiv8250128421 code {font:115%
monospace;}#yiv8250128421 #yiv8250128421ygrp-mlmsg *
{line-height:1.22em;}#yiv8250128421 #yiv8250128421ygrp-mlmsg #yiv8250128421logo
{padding-bottom:10px;}#yiv8250128421 #yiv8250128421ygrp-msg p a
{font-family:Verdana;}#yiv8250128421 #yiv8250128421ygrp-msg
p#yiv8250128421attach-count span {color:#1E66AE;font-weight:700;}#yiv8250128421
#yiv8250128421ygrp-reco #yiv8250128421reco-head
{color:#ff7900;font-weight:700;}#yiv8250128421 #yiv8250128421ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8250128421 #yiv8250128421ygrp-sponsor
#yiv8250128421ov li a {font-size:130%;text-decoration:none;}#yiv8250128421
#yiv8250128421ygrp-sponsor #yiv8250128421ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8250128421
#yiv8250128421ygrp-sponsor #yiv8250128421ov ul {margin:0;padding:0 0 0
8px;}#yiv8250128421 #yiv8250128421ygrp-text
{font-family:Georgia;}#yiv8250128421 #yiv8250128421ygrp-text p {margin:0 0 1em
0;}#yiv8250128421 #yiv8250128421ygrp-text tt {font-size:120%;}#yiv8250128421
#yiv8250128421ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8250128421
