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

¤@­Óªí³æ°ÝÃD

¤@­Óªí³æ°ÝÃD

½Ð±Ð¤j¤j­Ì,
¤p§Ì¦³¤@°ÝÃD½Ð±Ð,  ¤p§Ì§â°ÝÃD¼g©óªþÀɤº, ¤p§Ì¥ý¦æÁ¹L..
¬¡­¶Ã¯1.rar (48.38 KB)
hong912

¦^´_ 1# hong912
ªí³æ¼Ò²Õ
  1. Private Sub CommandButton1_Click()
  2. Range("C:C").Find("*", , , , , xlPrevious).Offset(, 10) = TextBox1
  3. Unload Me
  4. End Sub
½Æ»s¥N½X
¤u§@ªí¼Ò²Õ
  1. Private Sub Worksheet_Change(ByVal Target As Range)
  2. If Target.Column = 3 And InStr("a1,a5,b1,b5", Target) > 0 Then UserForm1.show
  3. End Sub
½Æ»s¥N½X
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh

ÁÂÁª©¤j¦^À³. °J¤ß·PÁÂ!!
hong912

TOP

¦^´_ 2# Hsieh
hsiehª©¤j, ¦w¦n
¤p§Ì´¿¸Õ¹L§â¤j¤j©Ò¼gªºµ{¦¡©ñ¤J¤p§Ìªu¥Î¶}ªº­Ü®wµ{¦¡¤¤, ¦ý¤£¦¨¥\,
²{¤W¶ÇÀÉ®×, ¤º¦³»¡©ú,Àµ½Ðª©¤j¨ó§U­×§ï, °J¤ß·PÁÂ!!
µ{¦¡.rar (13.15 KB)

TOP

,

¥»©«³Ì«á¥Ñ ©P¤j°¶ ©ó 2014-4-5 11:28 ½s¿è

¦^´_ 2# Hsieh
ª©¤jØB,
¤é«e©ó¦¹µo¤å, ±o¤£¨ì¦^À³, ¨ä¹ê¬O¤p§Ì¨S¦³°µ¦n¤Îªí¹F©Ò»Ý­nªº, ²{¦A«×¾ã²z, §â²{®É¤p§Ì¨Ï¥Î¶}ªºÀɮפW¶Ç, §Æ±æ¯à±o¨ì¦^À³..¦Ó2­ÓÀÉ®×¥²¶·¦P®É¶}±Ò,
¦Ó´£¨ú³æÀɮפº¦³©ú²Ó»¡©ú, ÁÂÁÂ!!
´£¨ú³æ.rar (63.09 KB)
abc­Ü®w¸ê®Æ.rar (16.61 KB)

TOP

¦^´_ 2# Hsieh
ª©¤j¦n,
ª©¤j¦­«e§U¤p§Ì¸Ñ¨M¤F¤@­Óªí³æ°ÝÃD, ¤p§Ì¨ü¥Î¦Ü¤µ, ¦ý²{®É¤p§Ì·Q§@¤p³\变°Ê, ¦]¥\¤O²L, ¨Sªk½s¼g, ½Ð¨ó§U,
¤p§Ì·QÅܧ󪺬O, ­ìªí³æ¤¤ªºTextBox1§ï¬°ComboBox1, ¤U©Ô¦¡¿ï¾Ü, ¦Ó¿ï¾Ü°Ñ·Ó¦ì¸m¬O¤u§@ªí2, aÄæ©Î§ó¦n¤è¦¡,
ªþÀÉ, ¥ý¦æÁ¹L, ÁÂÁÂ!!
¬¡­¶Ã¯1.rar (16.81 KB)
hong912

TOP

¦^´_ 6# hong912
¸Õ¸Õ¬Ý
  1. Private Sub UserForm_Initialize()
  2.     ComboBox1.List = ¤u§@ªí2.UsedRange.Columns(1).Value
  3. End Sub

  4. Private Sub CommandButton1_Click()
  5.     Range("C:C").Find("*", , , , , xlPrevious).Offset(, 10) = Me.ComboBox1
  6.     Unload Me
  7. End Sub
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 7# GBKEE
·PÁª©¤j, ¤µ±ß­n¥[¯Z, «Ý©ñ¤u¦^®a¤~¥i¸Õ¥Î, ¦ý°J¤ß·PÁÂ,
­Y¹J¤W¶¡ÃD·|¦A«×´£°Ý, ·Ð½Ð¤j¤j«ü¾É, ÁÂÁÂ!
hong912

TOP

¦^´_ 5# ©P¤j°¶
Ãþ¦ü³o¼Ëªº¶Ü?

Ex.rar (22.77 KB)
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¥»©«³Ì«á¥Ñ hong912 ©ó 2015-5-20 19:23 ½s¿è

¦^´_ 9# GBKEE
·PÁ¤j¤j±Ð¾É
¤p§Ì¥¿¤F¸Ñ¨Ï¥Î, Àɮפ¤µ{¦¡¨ì¤Fª©¤j³o¯Å¼Æ¤~¯à¼g¥X, ¤p§Ì°J¤ß·PÁÂ, µL¨p«ü¾É,
¦P®É¯¬Ä@°·±d, §Ö¼Ö, ÁÂÁÂ!!
hong912

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¯Ê¤fªºªM¤l¡A¦pªG´«¤@­Ó¨¤«×¬Ý¥¦¡A¥¦¤´µM¬O¶êªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD