Dear Tobi,
Terima kasih atas bantuannya untuk kode VBA yang anda berikan. Saya ingin
menanyakan satu hal lagi mengenai kode VBA tersebut jika seandainya listnya
berada di lain sheet, bagaimana dengan kode VBA-nya?
Terima kasih
Edo
On Tuesday, June 14, 2016 9:33 PM, "Toby kenzo [email protected]
[belajar-excel]" <[email protected]> wrote:
Hai Edo,
Coba gunakan code VBA ini pada Event Worksheet_Activate()
Sheet1.Range("D2").Value = Sheet1.Cells(Cells(1, 1).End(xlDown).Row, 1).Value
TerimaKasih
Pada Selasa, 14 Juni 2016 16:54, "[email protected] [belajar-excel]"
<[email protected]> menulis:
Dear Master,
Bagaimana caranya agar setiap kita membuka "Sheet1" (file terlampir) maka pada
data validation di sel "D2" akan selalu merujuk pada item terakhir pada list
data validation ?
Terima kasih
Edo
#yiv2561252765 #yiv2561252765 -- #yiv2561252765ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2561252765
#yiv2561252765ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2561252765
#yiv2561252765ygrp-mkp #yiv2561252765hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2561252765 #yiv2561252765ygrp-mkp #yiv2561252765ads
{margin-bottom:10px;}#yiv2561252765 #yiv2561252765ygrp-mkp .yiv2561252765ad
{padding:0 0;}#yiv2561252765 #yiv2561252765ygrp-mkp .yiv2561252765ad p
{margin:0;}#yiv2561252765 #yiv2561252765ygrp-mkp .yiv2561252765ad a
{color:#0000ff;text-decoration:none;}#yiv2561252765 #yiv2561252765ygrp-sponsor
#yiv2561252765ygrp-lc {font-family:Arial;}#yiv2561252765
#yiv2561252765ygrp-sponsor #yiv2561252765ygrp-lc #yiv2561252765hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2561252765
#yiv2561252765ygrp-sponsor #yiv2561252765ygrp-lc .yiv2561252765ad
{margin-bottom:10px;padding:0 0;}#yiv2561252765 #yiv2561252765actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2561252765
#yiv2561252765activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2561252765
#yiv2561252765activity span {font-weight:700;}#yiv2561252765
#yiv2561252765activity span:first-child
{text-transform:uppercase;}#yiv2561252765 #yiv2561252765activity span a
{color:#5085b6;text-decoration:none;}#yiv2561252765 #yiv2561252765activity span
span {color:#ff7900;}#yiv2561252765 #yiv2561252765activity span
.yiv2561252765underline {text-decoration:underline;}#yiv2561252765
.yiv2561252765attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2561252765 .yiv2561252765attach div a
{text-decoration:none;}#yiv2561252765 .yiv2561252765attach img
{border:none;padding-right:5px;}#yiv2561252765 .yiv2561252765attach label
{display:block;margin-bottom:5px;}#yiv2561252765 .yiv2561252765attach label a
{text-decoration:none;}#yiv2561252765 blockquote {margin:0 0 0
4px;}#yiv2561252765 .yiv2561252765bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2561252765
.yiv2561252765bold a {text-decoration:none;}#yiv2561252765 dd.yiv2561252765last
p a {font-family:Verdana;font-weight:700;}#yiv2561252765 dd.yiv2561252765last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2561252765
dd.yiv2561252765last p span.yiv2561252765yshortcuts
{margin-right:0;}#yiv2561252765 div.yiv2561252765attach-table div div a
{text-decoration:none;}#yiv2561252765 div.yiv2561252765attach-table
{width:400px;}#yiv2561252765 div.yiv2561252765file-title a, #yiv2561252765
div.yiv2561252765file-title a:active, #yiv2561252765
div.yiv2561252765file-title a:hover, #yiv2561252765 div.yiv2561252765file-title
a:visited {text-decoration:none;}#yiv2561252765 div.yiv2561252765photo-title a,
#yiv2561252765 div.yiv2561252765photo-title a:active, #yiv2561252765
div.yiv2561252765photo-title a:hover, #yiv2561252765
div.yiv2561252765photo-title a:visited {text-decoration:none;}#yiv2561252765
div#yiv2561252765ygrp-mlmsg #yiv2561252765ygrp-msg p a
span.yiv2561252765yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2561252765
.yiv2561252765green {color:#628c2a;}#yiv2561252765 .yiv2561252765MsoNormal
{margin:0 0 0 0;}#yiv2561252765 o {font-size:0;}#yiv2561252765
#yiv2561252765photos div {float:left;width:72px;}#yiv2561252765
#yiv2561252765photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv2561252765
#yiv2561252765photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2561252765
#yiv2561252765reco-category {font-size:77%;}#yiv2561252765
#yiv2561252765reco-desc {font-size:77%;}#yiv2561252765 .yiv2561252765replbq
{margin:4px;}#yiv2561252765 #yiv2561252765ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2561252765 #yiv2561252765ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2561252765
#yiv2561252765ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2561252765
#yiv2561252765ygrp-mlmsg select, #yiv2561252765 input, #yiv2561252765 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2561252765
#yiv2561252765ygrp-mlmsg pre, #yiv2561252765 code {font:115%
monospace;}#yiv2561252765 #yiv2561252765ygrp-mlmsg *
{line-height:1.22em;}#yiv2561252765 #yiv2561252765ygrp-mlmsg #yiv2561252765logo
{padding-bottom:10px;}#yiv2561252765 #yiv2561252765ygrp-msg p a
{font-family:Verdana;}#yiv2561252765 #yiv2561252765ygrp-msg
p#yiv2561252765attach-count span {color:#1E66AE;font-weight:700;}#yiv2561252765
#yiv2561252765ygrp-reco #yiv2561252765reco-head
{color:#ff7900;font-weight:700;}#yiv2561252765 #yiv2561252765ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv2561252765 #yiv2561252765ygrp-sponsor
#yiv2561252765ov li a {font-size:130%;text-decoration:none;}#yiv2561252765
#yiv2561252765ygrp-sponsor #yiv2561252765ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv2561252765
#yiv2561252765ygrp-sponsor #yiv2561252765ov ul {margin:0;padding:0 0 0
8px;}#yiv2561252765 #yiv2561252765ygrp-text
{font-family:Georgia;}#yiv2561252765 #yiv2561252765ygrp-text p {margin:0 0 1em
0;}#yiv2561252765 #yiv2561252765ygrp-text tt {font-size:120%;}#yiv2561252765
#yiv2561252765ygrp-vital ul li:last-child {border-right:none
!important;}#yiv2561252765
