香港新浪網 MySinaBlog
« 上一篇 | 下一篇 »
Emily | 1st Jul 2006, 17:35 PM | API / Add-in | (2243 Reads)

Easy Filter Add-in

Filter Options are on separate tabbed User Interface and options available are:

Equal-Not Equal [Filters for up to five alternative = or <> criteria]
Blanks [Filters for Blanks or non Blanks or Formulas that evaluate to "" or not]
Greater-Less [Filters for >= OR > AND / OR <= OR <]
Begins-Contains-Ends [Ideal for filtering text fields]
Unique-Duplicate [At last an easy way to hunt out uniques and duplicates]
Special [Text searching with wild cards with up to 5 Or / And criteria]

Dates [Not enabled unless you are filtering a field containing dates]
Color [Fill/Font colors (Normal and Conditional Formatting colors) and Bold cells]

 

Details and download: http://www.rondebruin.nl/easyfilter.htm

 

 


[3]

THANKS FOR YOUR HELP!!
但會去試試看可不可以破解佢既保護,但我仍希望你能電郵告訴我你的E-MAIL ADDRESS. 我想SEND 個FILE 俾你睇下, 因為我是初學者=.=, 我想學習這個FILE 裡面的VBA CODE 來方便日常工作用的, thx!!


[引用] | 作者 Kathy123 | 3rd Jul 2006 02:22 AM | [舉報垃圾留言]

[2]

破解 VBA 保護有許多,
到內地找找 "工程不可查看"

Excel 問題, 請往
http://www.excelhelp.net/cgi-bin/forum/leoboard.cgi

http://www.officefans.net/cdb/index.php


[引用] | 作者 Emily | 2nd Jul 2006 12:08 PM | [舉報垃圾留言]

[1]

i have some question about a excel file. The File with some protect, so I cannot see the VBA CODE in the file. I want to send the file to you. 我是excel vba初學者, 咩都唔識, Would you pls. send your e-mail address to me?? THX!!


[引用] | 作者 Kathy123 | 2nd Jul 2006 02:54 AM | [舉報垃圾留言]