ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] Userform Listbox Search °ÝÃD1

[µo°Ý] Userform Listbox Search °ÝÃD1

¦U¦ì¤j¤j§A¦n,

§Ú·Q¦b¤@­Ó­¶­±¨½°µ¤@­Ó¿ï¶µ´M§ä¥\¯àªº, ·í§Ú¤@¶}©l°õ¦æµ{¦¡®É,±N©Ò¦³¼Æ¾Ú³£Åã¥Ü¥X¨Ó, ¦ý·í§Ú°µ´M§ä®É¥Î(Me.listbox.clear) ´N·|¥X垷error ½ÐÀ°¦£«üÂI§Úªº¿ù³B,

ÁÙ¦³¤@­Ó°ÝÃD´N¬O¦pªG§Ú·Q¤À¬q¿z¿ï©Î­«ÂI¿ï¶µ¿ï,§Ú¤v¸g¥Î¤Fsh.Range("A2:S" & ish).AutoFilter field:=3, Criteria1:="=*" & Me.TextBox1 & "*" ¦ý³£¤@¼Ë°µ­ø¨ìÀ³¦³

InkedLISTBOX_LI.jpg (164.08 KB)

InkedLISTBOX_LI.jpg

LISTBOX SEARCH.rar (23.94 KB)

¥»©«³Ì«á¥Ñ singo1232001 ©ó 2021-8-11 12:27 ½s¿è

¦^´_ 1# mdr0465


    °Ñ¦Ò¬Ý¬Ý LISTBOX SEARCH.zip (34.21 KB)
¤º¦³¤@±iÁôÂäu§@ªí ¦]¬°­n·f°tRowSource

TOP

¥»©«³Ì«á¥Ñ mdr0465 ©ó 2021-8-11 15:53 ½s¿è

¦^´_ 2# singo1232001

Singo®v¥S,

ÁÂÁ§AªºÀ°¦£, ¦ý·í¤¤¦³¤@¨Ç¨Æ±¡·Q³Â·Ð§AÀ°¦£­×§ï, ¦]¬°§Ú§Ú¦b¿z¿ï¹Lµ{¤¤, ©³³¡ªº¾î¦V±·¦b´X¦¸¿z¿ï¤¤( listbox ·|¦Û°Ê¦V¤U©ñ¤j) ¦Ó¥O¨ì横¦V®ø¥¢¤F,

ÁÙ¦³¤@¥ó¨Æ±¡, ¯à§_¶}³]¤@­Ó«ö¶s¬O"°£®ø"©Ò¦³ªº¿z¿ï©O ©M"¤£¥²­n"ªº¶ê¨÷¿ï¶µ¥i¥H§R°£¶Ü?? ¦³¿z¿ï¥X¨Óªº¶µ¥Ø¦³¶ê°é¿ï¶µ,¤§«á§Ú¬O¦³»Ý­n¥Î¨ìªº

bar.png (48.74 KB)

bar.png

bar2.png (49.34 KB)

bar2.png

TOP

LISTBOX SEARCH v1.zip (38.74 KB) ¦^´_ 3# mdr0465

LISTBOX SEARCH v1.zip (38.74 KB)

TOP

¦^´_ 4# singo1232001

singo¸U¤À·PÁ§Aªº¦^ÂÐ,¦ý¤p§Ì·M¬N, §Ú¬Ý¨ì·í¤¤ªº²Ä¤@¦æ¬O¨S¦³³Q¿ï¤¤©M¯à¤£¯à°÷¥i¥H¦b¨C¦¸¿z¿ï¤¤³£Åã¥Ü¥X©Ò¥H¦³ªº¶µ¥Ø¥X¨Ó©O?

¸U¤À·PÁÂ

Â^¨ú.PNG (15.89 KB)

Â^¨ú.PNG

Â^¨ú2.PNG (12.63 KB)

Â^¨ú2.PNG

TOP

LISTBOX SEARCH v1.zip (38.13 KB) ¦^´_ 5# mdr0465

TOP

¦^´_ 6# singo1232001

  Singo®v¥S

¦A¦¸¸U¤À·PÁ§AªºÀ°¦£.....
¦ý³Ì«á¤@ÃøÃD¬O·í§Ú¿z¿ï¨ä¤¤¤@­Ó¶µ¥Ø«á
A1 Àx¦s®æªº¤å¦r·|¸òAÄæ³Ì«á¤@­Ó¤å¦r­ËÂà½Ð°ÝÀ³¦p¦ó¸Ñ¨M,

ÁÂÁ§A

TOP

¥»©«³Ì«á¥Ñ singo1232001 ©ó 2021-8-12 23:34 ½s¿è

¦^´_ 7# mdr0465


    ¤£¤Ó²M·¡§Aªº·N«ä
     §Ú¥ý¶¶«K§â¨ú¸ê®Æ¤]°µ¤F LISTBOX SEARCH v2.zip (50.26 KB)

¥t¥~listboxªº¥Îªk¥i¥H°Ñ¦Ò¸Ó°Q½×¦êªº7¼Ó
http://forum.twbts.com/thread-23251-1-2.html

TOP

¦^´_ 8# singo1232001


    Sijgo¸U¤À·PÁ§A·PÁ§A

TOP

        ÀR«ä¦Û¦b : ¤H­n¦Û·R¡A¤~¯à·R´¶¤Ñ¤Uªº¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD