Hai Eko,
1. Buat Formula Excel di Cell E1 : "=IFERROR(VLOOKUP(D1,$A$2:$B$4,2),"")"
2. Masukan formula di Sub cmdfind_Click() :
Dim a As String
a = Me.txtkode.Value
Sheet1.Range("D1").Value = a
Me.txtjenis.Value = Sheet1.Range("E1").Value
TerimaKasih.
--------------------------------------------
Pada Rab, 20/1/16, Septian Eko Saputro [email protected] [belajar-excel]
<[email protected]> menulis:
Judul: [belajar-excel] VBA find dibeda Sheet [1 Attachment]
Kepada: [email protected]
Tanggal: Rabu, 20 Januari, 2016, 10:42 PM
Dear Expert
Saya mempunyai kasus VBA
untuk sebuah form input data,
kesulitan saya berada ketika mecari data dari sheet1 yang
nantinya digunakan
untuk mencari jenis film sesuai gambar:
Tombol find adalah mencari
hasil jenis dari kriteria kode. Sehingga
jika kode diisi A1001 nantinya akan muncul hasil
“Drama”, tetapi saya mengalami
kesulitan untuk mengambil data tersebut. Apa yang salah
mengenai rumus VBA yang
saya buat, ataukah para master mempunyai solusi terkait case
tersebut?atau
adakah alternatif rumus lain? Mohon pencerahan
Salam,
monnalissa
#yiv6027948397 #yiv6027948397 --
#yiv6027948397ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}
#yiv6027948397 #yiv6027948397ygrp-mkp hr {
border:1px solid #d8d8d8;}
#yiv6027948397 #yiv6027948397ygrp-mkp #yiv6027948397hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}
#yiv6027948397 #yiv6027948397ygrp-mkp #yiv6027948397ads {
margin-bottom:10px;}
#yiv6027948397 #yiv6027948397ygrp-mkp .yiv6027948397ad {
padding:0 0;}
#yiv6027948397 #yiv6027948397ygrp-mkp .yiv6027948397ad p {
margin:0;}
#yiv6027948397 #yiv6027948397ygrp-mkp .yiv6027948397ad a {
color:#0000ff;text-decoration:none;}
#yiv6027948397 #yiv6027948397ygrp-sponsor
#yiv6027948397ygrp-lc {
font-family:Arial;}
#yiv6027948397 #yiv6027948397ygrp-sponsor
#yiv6027948397ygrp-lc #yiv6027948397hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}
#yiv6027948397 #yiv6027948397ygrp-sponsor
#yiv6027948397ygrp-lc .yiv6027948397ad {
margin-bottom:10px;padding:0 0;}
#yiv6027948397 #yiv6027948397actions {
font-family:Verdana;font-size:11px;padding:10px 0;}
#yiv6027948397 #yiv6027948397activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
#yiv6027948397 #yiv6027948397activity span {
font-weight:700;}
#yiv6027948397 #yiv6027948397activity span:first-child {
text-transform:uppercase;}
#yiv6027948397 #yiv6027948397activity span a {
color:#5085b6;text-decoration:none;}
#yiv6027948397 #yiv6027948397activity span span {
color:#ff7900;}
#yiv6027948397 #yiv6027948397activity span
.yiv6027948397underline {
text-decoration:underline;}
#yiv6027948397 .yiv6027948397attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}
#yiv6027948397 .yiv6027948397attach div a {
text-decoration:none;}
#yiv6027948397 .yiv6027948397attach img {
border:none;padding-right:5px;}
#yiv6027948397 .yiv6027948397attach label {
display:block;margin-bottom:5px;}
#yiv6027948397 .yiv6027948397attach label a {
text-decoration:none;}
#yiv6027948397 blockquote {
margin:0 0 0 4px;}
#yiv6027948397 .yiv6027948397bold {
font-family:Arial;font-size:13px;font-weight:700;}
#yiv6027948397 .yiv6027948397bold a {
text-decoration:none;}
#yiv6027948397 dd.yiv6027948397last p a {
font-family:Verdana;font-weight:700;}
#yiv6027948397 dd.yiv6027948397last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}
#yiv6027948397 dd.yiv6027948397last p
span.yiv6027948397yshortcuts {
margin-right:0;}
#yiv6027948397 div.yiv6027948397attach-table div div a {
text-decoration:none;}
#yiv6027948397 div.yiv6027948397attach-table {
width:400px;}
#yiv6027948397 div.yiv6027948397file-title a, #yiv6027948397
div.yiv6027948397file-title a:active, #yiv6027948397
div.yiv6027948397file-title a:hover, #yiv6027948397
div.yiv6027948397file-title a:visited {
text-decoration:none;}
#yiv6027948397 div.yiv6027948397photo-title a,
#yiv6027948397 div.yiv6027948397photo-title a:active,
#yiv6027948397 div.yiv6027948397photo-title a:hover,
#yiv6027948397 div.yiv6027948397photo-title a:visited {
text-decoration:none;}
#yiv6027948397 div#yiv6027948397ygrp-mlmsg
#yiv6027948397ygrp-msg p a span.yiv6027948397yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}
#yiv6027948397 .yiv6027948397green {
color:#628c2a;}
#yiv6027948397 .yiv6027948397MsoNormal {
margin:0 0 0 0;}
#yiv6027948397 o {
font-size:0;}
#yiv6027948397 #yiv6027948397photos div {
float:left;width:72px;}
#yiv6027948397 #yiv6027948397photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}
#yiv6027948397 #yiv6027948397photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
#yiv6027948397 #yiv6027948397reco-category {
font-size:77%;}
#yiv6027948397 #yiv6027948397reco-desc {
font-size:77%;}
#yiv6027948397 .yiv6027948397replbq {
margin:4px;}
#yiv6027948397 #yiv6027948397ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}
#yiv6027948397 #yiv6027948397ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}
#yiv6027948397 #yiv6027948397ygrp-mlmsg table {
font-size:inherit;font:100%;}
#yiv6027948397 #yiv6027948397ygrp-mlmsg select,
#yiv6027948397 input, #yiv6027948397 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}
#yiv6027948397 #yiv6027948397ygrp-mlmsg pre, #yiv6027948397
code {
font:115% monospace;}
#yiv6027948397 #yiv6027948397ygrp-mlmsg * {
line-height:1.22em;}
#yiv6027948397 #yiv6027948397ygrp-mlmsg #yiv6027948397logo {
padding-bottom:10px;}
#yiv6027948397 #yiv6027948397ygrp-msg p a {
font-family:Verdana;}
#yiv6027948397 #yiv6027948397ygrp-msg
p#yiv6027948397attach-count span {
color:#1E66AE;font-weight:700;}
#yiv6027948397 #yiv6027948397ygrp-reco
#yiv6027948397reco-head {
color:#ff7900;font-weight:700;}
#yiv6027948397 #yiv6027948397ygrp-reco {
margin-bottom:20px;padding:0px;}
#yiv6027948397 #yiv6027948397ygrp-sponsor #yiv6027948397ov
li a {
font-size:130%;text-decoration:none;}
#yiv6027948397 #yiv6027948397ygrp-sponsor #yiv6027948397ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}
#yiv6027948397 #yiv6027948397ygrp-sponsor #yiv6027948397ov
ul {
margin:0;padding:0 0 0 8px;}
#yiv6027948397 #yiv6027948397ygrp-text {
font-family:Georgia;}
#yiv6027948397 #yiv6027948397ygrp-text p {
margin:0 0 1em 0;}
#yiv6027948397 #yiv6027948397ygrp-text tt {
font-size:120%;}
#yiv6027948397 #yiv6027948397ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv6027948397
