Mr Toby
Terima kasih sebelumnya, file yang lampirkan hasil akal-akalan saya
karena ingin membuat search engine jadi saya buat begitu, karena saya belum
tahu bagaimana agar combobox dapat lookup kekiri.
File yang dilampirkan untuk entry data baru untuk search engine nya
tidak dilampirkan mohon maaf.
Mohon Masukannya
Terima kasih
On Wednesday, February 24, 2016 4:16 PM, "Toby kenzo [email protected]
[belajar-excel]" <[email protected]> wrote:
Dear Imam,
Perhatikan pembuatan Name Manager, coba di check lagi Name yang ada di Name
Manager (di lihat refrence Row dan cell nya)
Jika mau membuat data validation pada combobox, tempatkan di tempat yang tepat.
TerimaKasih.
Pada Rab, 24/2/16, imam cahyo yuwono [email protected] [belajar-excel]
<[email protected]> menulis:
Judul: [belajar-excel] mencegah input data ganda [1 Attachment]
Kepada: [email protected]
Tanggal: Rabu, 24 Februari, 2016, 10:19 AM
dear para
master
1. saya
membuat form input data untuk mencegah data ganda script nya
bagaimana
2. saya
membuat lookup combo box yang berhubungan dengan textbox
kalo supaya bisa membaca ke kiri bagaimana caranya
terima
kasih
#yiv3674497179 #yiv3674497179 --
#yiv3674497179ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}
#yiv3674497179 #yiv3674497179ygrp-mkp hr {
border:1px solid #d8d8d8;}
#yiv3674497179 #yiv3674497179ygrp-mkp #yiv3674497179hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}
#yiv3674497179 #yiv3674497179ygrp-mkp #yiv3674497179ads {
margin-bottom:10px;}
#yiv3674497179 #yiv3674497179ygrp-mkp .yiv3674497179ad {
padding:0 0;}
#yiv3674497179 #yiv3674497179ygrp-mkp .yiv3674497179ad p {
margin:0;}
#yiv3674497179 #yiv3674497179ygrp-mkp .yiv3674497179ad a {
color:#0000ff;text-decoration:none;}
#yiv3674497179 #yiv3674497179ygrp-sponsor
#yiv3674497179ygrp-lc {
font-family:Arial;}
#yiv3674497179 #yiv3674497179ygrp-sponsor
#yiv3674497179ygrp-lc #yiv3674497179hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}
#yiv3674497179 #yiv3674497179ygrp-sponsor
#yiv3674497179ygrp-lc .yiv3674497179ad {
margin-bottom:10px;padding:0 0;}
#yiv3674497179 #yiv3674497179actions {
font-family:Verdana;font-size:11px;padding:10px 0;}
#yiv3674497179 #yiv3674497179activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
#yiv3674497179 #yiv3674497179activity span {
font-weight:700;}
#yiv3674497179 #yiv3674497179activity span:first-child {
text-transform:uppercase;}
#yiv3674497179 #yiv3674497179activity span a {
color:#5085b6;text-decoration:none;}
#yiv3674497179 #yiv3674497179activity span span {
color:#ff7900;}
#yiv3674497179 #yiv3674497179activity span
.yiv3674497179underline {
text-decoration:underline;}
#yiv3674497179 .yiv3674497179attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}
#yiv3674497179 .yiv3674497179attach div a {
text-decoration:none;}
#yiv3674497179 .yiv3674497179attach img {
border:none;padding-right:5px;}
#yiv3674497179 .yiv3674497179attach label {
display:block;margin-bottom:5px;}
#yiv3674497179 .yiv3674497179attach label a {
text-decoration:none;}
#yiv3674497179 blockquote {
margin:0 0 0 4px;}
#yiv3674497179 .yiv3674497179bold {
font-family:Arial;font-size:13px;font-weight:700;}
#yiv3674497179 .yiv3674497179bold a {
text-decoration:none;}
#yiv3674497179 dd.yiv3674497179last p a {
font-family:Verdana;font-weight:700;}
#yiv3674497179 dd.yiv3674497179last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}
#yiv3674497179 dd.yiv3674497179last p
span.yiv3674497179yshortcuts {
margin-right:0;}
#yiv3674497179 div.yiv3674497179attach-table div div a {
text-decoration:none;}
#yiv3674497179 div.yiv3674497179attach-table {
width:400px;}
#yiv3674497179 div.yiv3674497179file-title a, #yiv3674497179
div.yiv3674497179file-title a:active, #yiv3674497179
div.yiv3674497179file-title a:hover, #yiv3674497179
div.yiv3674497179file-title a:visited {
text-decoration:none;}
#yiv3674497179 div.yiv3674497179photo-title a,
#yiv3674497179 div.yiv3674497179photo-title a:active,
#yiv3674497179 div.yiv3674497179photo-title a:hover,
#yiv3674497179 div.yiv3674497179photo-title a:visited {
text-decoration:none;}
#yiv3674497179 div#yiv3674497179ygrp-mlmsg
#yiv3674497179ygrp-msg p a span.yiv3674497179yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}
#yiv3674497179 .yiv3674497179green {
color:#628c2a;}
#yiv3674497179 .yiv3674497179MsoNormal {
margin:0 0 0 0;}
#yiv3674497179 o {
font-size:0;}
#yiv3674497179 #yiv3674497179photos div {
float:left;width:72px;}
#yiv3674497179 #yiv3674497179photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}
#yiv3674497179 #yiv3674497179photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
#yiv3674497179 #yiv3674497179reco-category {
font-size:77%;}
#yiv3674497179 #yiv3674497179reco-desc {
font-size:77%;}
#yiv3674497179 .yiv3674497179replbq {
margin:4px;}
#yiv3674497179 #yiv3674497179ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}
#yiv3674497179 #yiv3674497179ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}
#yiv3674497179 #yiv3674497179ygrp-mlmsg table {
font-size:inherit;font:100%;}
#yiv3674497179 #yiv3674497179ygrp-mlmsg select,
#yiv3674497179 input, #yiv3674497179 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}
#yiv3674497179 #yiv3674497179ygrp-mlmsg pre, #yiv3674497179
code {
font:115% monospace;}
#yiv3674497179 #yiv3674497179ygrp-mlmsg * {
line-height:1.22em;}
#yiv3674497179 #yiv3674497179ygrp-mlmsg #yiv3674497179logo {
padding-bottom:10px;}
#yiv3674497179 #yiv3674497179ygrp-msg p a {
font-family:Verdana;}
#yiv3674497179 #yiv3674497179ygrp-msg
p#yiv3674497179attach-count span {
color:#1E66AE;font-weight:700;}
#yiv3674497179 #yiv3674497179ygrp-reco
#yiv3674497179reco-head {
color:#ff7900;font-weight:700;}
#yiv3674497179 #yiv3674497179ygrp-reco {
margin-bottom:20px;padding:0px;}
#yiv3674497179 #yiv3674497179ygrp-sponsor #yiv3674497179ov
li a {
font-size:130%;text-decoration:none;}
#yiv3674497179 #yiv3674497179ygrp-sponsor #yiv3674497179ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}
#yiv3674497179 #yiv3674497179ygrp-sponsor #yiv3674497179ov
ul {
margin:0;padding:0 0 0 8px;}
#yiv3674497179 #yiv3674497179ygrp-text {
font-family:Georgia;}
#yiv3674497179 #yiv3674497179ygrp-text p {
margin:0 0 1em 0;}
#yiv3674497179 #yiv3674497179ygrp-text tt {
font-size:120%;}
#yiv3674497179 #yiv3674497179ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv3674497179
#yiv9357036955 #yiv9357036955 -- #yiv9357036955ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9357036955
#yiv9357036955ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9357036955
#yiv9357036955ygrp-mkp #yiv9357036955hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9357036955 #yiv9357036955ygrp-mkp #yiv9357036955ads
{margin-bottom:10px;}#yiv9357036955 #yiv9357036955ygrp-mkp .yiv9357036955ad
{padding:0 0;}#yiv9357036955 #yiv9357036955ygrp-mkp .yiv9357036955ad p
{margin:0;}#yiv9357036955 #yiv9357036955ygrp-mkp .yiv9357036955ad a
{color:#0000ff;text-decoration:none;}#yiv9357036955 #yiv9357036955ygrp-sponsor
#yiv9357036955ygrp-lc {font-family:Arial;}#yiv9357036955
#yiv9357036955ygrp-sponsor #yiv9357036955ygrp-lc #yiv9357036955hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9357036955
#yiv9357036955ygrp-sponsor #yiv9357036955ygrp-lc .yiv9357036955ad
{margin-bottom:10px;padding:0 0;}#yiv9357036955 #yiv9357036955actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9357036955
#yiv9357036955activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9357036955
#yiv9357036955activity span {font-weight:700;}#yiv9357036955
#yiv9357036955activity span:first-child
{text-transform:uppercase;}#yiv9357036955 #yiv9357036955activity span a
{color:#5085b6;text-decoration:none;}#yiv9357036955 #yiv9357036955activity span
span {color:#ff7900;}#yiv9357036955 #yiv9357036955activity span
.yiv9357036955underline {text-decoration:underline;}#yiv9357036955
.yiv9357036955attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9357036955 .yiv9357036955attach div a
{text-decoration:none;}#yiv9357036955 .yiv9357036955attach img
{border:none;padding-right:5px;}#yiv9357036955 .yiv9357036955attach label
{display:block;margin-bottom:5px;}#yiv9357036955 .yiv9357036955attach label a
{text-decoration:none;}#yiv9357036955 blockquote {margin:0 0 0
4px;}#yiv9357036955 .yiv9357036955bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9357036955
.yiv9357036955bold a {text-decoration:none;}#yiv9357036955 dd.yiv9357036955last
p a {font-family:Verdana;font-weight:700;}#yiv9357036955 dd.yiv9357036955last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9357036955
dd.yiv9357036955last p span.yiv9357036955yshortcuts
{margin-right:0;}#yiv9357036955 div.yiv9357036955attach-table div div a
{text-decoration:none;}#yiv9357036955 div.yiv9357036955attach-table
{width:400px;}#yiv9357036955 div.yiv9357036955file-title a, #yiv9357036955
div.yiv9357036955file-title a:active, #yiv9357036955
div.yiv9357036955file-title a:hover, #yiv9357036955 div.yiv9357036955file-title
a:visited {text-decoration:none;}#yiv9357036955 div.yiv9357036955photo-title a,
#yiv9357036955 div.yiv9357036955photo-title a:active, #yiv9357036955
div.yiv9357036955photo-title a:hover, #yiv9357036955
div.yiv9357036955photo-title a:visited {text-decoration:none;}#yiv9357036955
div#yiv9357036955ygrp-mlmsg #yiv9357036955ygrp-msg p a
span.yiv9357036955yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9357036955
.yiv9357036955green {color:#628c2a;}#yiv9357036955 .yiv9357036955MsoNormal
{margin:0 0 0 0;}#yiv9357036955 o {font-size:0;}#yiv9357036955
#yiv9357036955photos div {float:left;width:72px;}#yiv9357036955
#yiv9357036955photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv9357036955
#yiv9357036955photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9357036955
#yiv9357036955reco-category {font-size:77%;}#yiv9357036955
#yiv9357036955reco-desc {font-size:77%;}#yiv9357036955 .yiv9357036955replbq
{margin:4px;}#yiv9357036955 #yiv9357036955ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9357036955 #yiv9357036955ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9357036955
#yiv9357036955ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9357036955
#yiv9357036955ygrp-mlmsg select, #yiv9357036955 input, #yiv9357036955 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9357036955
#yiv9357036955ygrp-mlmsg pre, #yiv9357036955 code {font:115%
monospace;}#yiv9357036955 #yiv9357036955ygrp-mlmsg *
{line-height:1.22em;}#yiv9357036955 #yiv9357036955ygrp-mlmsg #yiv9357036955logo
{padding-bottom:10px;}#yiv9357036955 #yiv9357036955ygrp-msg p a
{font-family:Verdana;}#yiv9357036955 #yiv9357036955ygrp-msg
p#yiv9357036955attach-count span {color:#1E66AE;font-weight:700;}#yiv9357036955
#yiv9357036955ygrp-reco #yiv9357036955reco-head
{color:#ff7900;font-weight:700;}#yiv9357036955 #yiv9357036955ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9357036955 #yiv9357036955ygrp-sponsor
#yiv9357036955ov li a {font-size:130%;text-decoration:none;}#yiv9357036955
#yiv9357036955ygrp-sponsor #yiv9357036955ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9357036955
#yiv9357036955ygrp-sponsor #yiv9357036955ov ul {margin:0;padding:0 0 0
8px;}#yiv9357036955 #yiv9357036955ygrp-text
{font-family:Georgia;}#yiv9357036955 #yiv9357036955ygrp-text p {margin:0 0 1em
0;}#yiv9357036955 #yiv9357036955ygrp-text tt {font-size:120%;}#yiv9357036955
#yiv9357036955ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9357036955
