Thanks Mr Kid atas pencerahannya muantafs abis...
-----Original Message-----
From: Kid Mr.
Sent: 07.10.2012, 03:21
To: [email protected]
Subject: Re: [belajar-excel] Filter item
Coba manfaatkan event keydown.
kira-kira :
private sub textbox_keydown( keycode as bla-bala gitu)
if keycode=13 then '13 = karakter enter
range("a1").currentregion.autofilter 1, "*" & textbox.text & "*"
endif
end sub
Wassalam,
Kid
2012/10/7 Sukardi <[email protected]>
> **
>
>
> Dear all master excel
> minta tolong kasih solusi,.aq kan punya data yg tak kasih autofilter,.kalo
> filter secara manual kan agak lama,.trs tak tambahin textbox,pd textbox tsb
> tak tulis code:
> private sub textbox_change()
> selection.autofilter field:=1,criteria1:="*"& textbox.text &"*"
> end sub
> cara ini kan menurut aq masih makan waktu soalnya tiap aq ngetik 1huruf
> sllu proses filter,.
> Nah yg aq inginkan saat aq tekan tombol enter proses filter bru
> dijalankan.. Mungkin ada yg tahu
> please help me...
>
> Salla,
> Soekardi
>
>
