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

¦p¦ó§Ö³t¿é¤J¥H«e¥´¹Lªº¸ê®Æ

¦^´_ 10# arcthelad


¨ç¼Æ³¡¤À °Ñ¦Ò³o­Ó¡A¥ý¸Õ³o­Ó¬Ý¬Ý
https://trumpexcel.com/excel-drop-down-list-with-search-suggestions/


VBA code ³¡¤À¡A½Õ¾ãIJµo±ø¥ó¡A°õ¦æ¤W¤ñ¸û§Ö¡C¥i¥H¬Ý¸Ó«h¶K¤å©³¤U¯d¨¥¡C

Private Sub ComboBox1_Change()
ComboBox1.ListFillRange = "DropDownList"
Me.ComboBox1.DropDown
End Sub

½Õ¾ãIJµo±ø¥ó¬°

Private Sub ComboBox1_GotFocus()
ComboBox1.ListFillRange = "DropDownList"
Me.ComboBox1.DropDown
End Sub

TOP

§Úªº«Øij¬O¡A§â500­Ó¸ê®Æ®w¡A¥Î´¡¤J¦C¤è¦¡¡A
¥ý©ñ¨ì§A­n¿é¤J¸ê®ÆÄæ¦ì¡Aªº¥¿¤W¤è¡A·í§@«áÄò¦P£¸ÄæÀx¦s®æ¸ê®Æ®w

¦pÀx¦s®æA1-A500¬°¸ê®Æ®w¡AA501­n¿é¤J¸ê®Æ¡C
¦bA501¤W¿é¤J«e­Ó´X¦r(¦pCPU¡A¥u¿é¤JC¦r)¡AµM«á¡A«ö§ÖÁäALT+¡õ
§Y¥i³Ì¤è«K¿ï¾Ü§A­nªº²M³æ¡C
¥H¤W

TOP

¸ê®Æ®w1  ¤w¸g¦³¿é¤J¶W¹L500µ§¥H¤Wªº«~¦W.  ¦Ó¦b¸ê®Æ®w2 ·Q­n¿é¤J¸ê®Æ®w1 ¨ä¤¤ªº200µ§ªº«~¦W, ­n¦p¦ó§Ö³t¿é ...
arcthelad µoªí©ó 2017-10-28 23:04


¥Î¸ê®ÆÅçÃÒªº¤è¦¡´N¥i¥H§e²{¤U©Ô¦¡¥Üµ¡¡A
https://mrtang.tw/blog/post/38868721

¥Î¸ê®ÆÅçÃÒ.zip (7.13 KB)

TOP

        ÀR«ä¦Û¦b : ºÉ¦h¤Ö¥»¥÷¡A´N±o¦h¤Ö¥»¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD