Kayaknya musti pake VBA (dr mbak Siti)File Macronya diberi Short Cut (mis. Ctrl
Shift Z), kemudian disave sebagai Excel Addins dgn extension ".xla".Add Ins nya
diaktifkan dengan membrowsing lokasi file ".xla" tsb. Cara mengaktifkan Add Ins
nya pernah dibahas oleh Miss JanSelanjutnya bisa dijalankan dengan menekan
tombol Short Cut tanpa harus mengaktifkan macro
Salam,HK
From: "aRghifari [email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
Sent: Thursday, 18 February 2016, 13:01
Subject: [belajar-excel] Ketik huruf awal saja
Dear Suhu, Mohon bantu, saya ingin menampilkan data hanya dengan mengetik
huruf awal saja maka secara otomatis barang2 yg berawalan dgn huruf yg diketik
muncul seperti Data Validation tapi kalo bisa jgn pake VBA ya krn sy msh amatir
tks before
--- Mods ---
File lampiran yang melebihi 250KB dilepas dari email. Silakan posting ulang
dengan me-reply email ini. File lampiran diusahakan maksimal 250KB.
--------------- #yiv3205304697 -- #yiv3205304697ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3205304697
#yiv3205304697ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3205304697
#yiv3205304697ygrp-mkp #yiv3205304697hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv3205304697 #yiv3205304697ygrp-mkp #yiv3205304697ads
{margin-bottom:10px;}#yiv3205304697 #yiv3205304697ygrp-mkp .yiv3205304697ad
{padding:0 0;}#yiv3205304697 #yiv3205304697ygrp-mkp .yiv3205304697ad p
{margin:0;}#yiv3205304697 #yiv3205304697ygrp-mkp .yiv3205304697ad a
{color:#0000ff;text-decoration:none;}#yiv3205304697 #yiv3205304697ygrp-sponsor
#yiv3205304697ygrp-lc {font-family:Arial;}#yiv3205304697
#yiv3205304697ygrp-sponsor #yiv3205304697ygrp-lc #yiv3205304697hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3205304697
#yiv3205304697ygrp-sponsor #yiv3205304697ygrp-lc .yiv3205304697ad
{margin-bottom:10px;padding:0 0;}#yiv3205304697 #yiv3205304697actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3205304697
#yiv3205304697activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3205304697
#yiv3205304697activity span {font-weight:700;}#yiv3205304697
#yiv3205304697activity span:first-child
{text-transform:uppercase;}#yiv3205304697 #yiv3205304697activity span a
{color:#5085b6;text-decoration:none;}#yiv3205304697 #yiv3205304697activity span
span {color:#ff7900;}#yiv3205304697 #yiv3205304697activity span
.yiv3205304697underline {text-decoration:underline;}#yiv3205304697
.yiv3205304697attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv3205304697 .yiv3205304697attach div a
{text-decoration:none;}#yiv3205304697 .yiv3205304697attach img
{border:none;padding-right:5px;}#yiv3205304697 .yiv3205304697attach label
{display:block;margin-bottom:5px;}#yiv3205304697 .yiv3205304697attach label a
{text-decoration:none;}#yiv3205304697 blockquote {margin:0 0 0
4px;}#yiv3205304697 .yiv3205304697bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3205304697
.yiv3205304697bold a {text-decoration:none;}#yiv3205304697 dd.yiv3205304697last
p a {font-family:Verdana;font-weight:700;}#yiv3205304697 dd.yiv3205304697last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3205304697
dd.yiv3205304697last p span.yiv3205304697yshortcuts
{margin-right:0;}#yiv3205304697 div.yiv3205304697attach-table div div a
{text-decoration:none;}#yiv3205304697 div.yiv3205304697attach-table
{width:400px;}#yiv3205304697 div.yiv3205304697file-title a, #yiv3205304697
div.yiv3205304697file-title a:active, #yiv3205304697
div.yiv3205304697file-title a:hover, #yiv3205304697 div.yiv3205304697file-title
a:visited {text-decoration:none;}#yiv3205304697 div.yiv3205304697photo-title a,
#yiv3205304697 div.yiv3205304697photo-title a:active, #yiv3205304697
div.yiv3205304697photo-title a:hover, #yiv3205304697
div.yiv3205304697photo-title a:visited {text-decoration:none;}#yiv3205304697
div#yiv3205304697ygrp-mlmsg #yiv3205304697ygrp-msg p a
span.yiv3205304697yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3205304697
.yiv3205304697green {color:#628c2a;}#yiv3205304697 .yiv3205304697MsoNormal
{margin:0 0 0 0;}#yiv3205304697 o {font-size:0;}#yiv3205304697
#yiv3205304697photos div {float:left;width:72px;}#yiv3205304697
#yiv3205304697photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv3205304697
#yiv3205304697photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3205304697
#yiv3205304697reco-category {font-size:77%;}#yiv3205304697
#yiv3205304697reco-desc {font-size:77%;}#yiv3205304697 .yiv3205304697replbq
{margin:4px;}#yiv3205304697 #yiv3205304697ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv3205304697 #yiv3205304697ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3205304697
#yiv3205304697ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3205304697
#yiv3205304697ygrp-mlmsg select, #yiv3205304697 input, #yiv3205304697 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3205304697
#yiv3205304697ygrp-mlmsg pre, #yiv3205304697 code {font:115%
monospace;}#yiv3205304697 #yiv3205304697ygrp-mlmsg *
{line-height:1.22em;}#yiv3205304697 #yiv3205304697ygrp-mlmsg #yiv3205304697logo
{padding-bottom:10px;}#yiv3205304697 #yiv3205304697ygrp-msg p a
{font-family:Verdana;}#yiv3205304697 #yiv3205304697ygrp-msg
p#yiv3205304697attach-count span {color:#1E66AE;font-weight:700;}#yiv3205304697
#yiv3205304697ygrp-reco #yiv3205304697reco-head
{color:#ff7900;font-weight:700;}#yiv3205304697 #yiv3205304697ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv3205304697 #yiv3205304697ygrp-sponsor
#yiv3205304697ov li a {font-size:130%;text-decoration:none;}#yiv3205304697
#yiv3205304697ygrp-sponsor #yiv3205304697ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3205304697
#yiv3205304697ygrp-sponsor #yiv3205304697ov ul {margin:0;padding:0 0 0
8px;}#yiv3205304697 #yiv3205304697ygrp-text
{font-family:Georgia;}#yiv3205304697 #yiv3205304697ygrp-text p {margin:0 0 1em
0;}#yiv3205304697 #yiv3205304697ygrp-text tt {font-size:120%;}#yiv3205304697
#yiv3205304697ygrp-vital ul li:last-child {border-right:none
!important;}#yiv3205304697
