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

[µo°Ý] ¦p¦ó»s§@¤@­Ó·|°Êªº¥\¯à°Ï¶ô? (¤w¸Ñ¨M)

[µo°Ý] ¦p¦ó»s§@¤@­Ó·|°Êªº¥\¯à°Ï¶ô? (¤w¸Ñ¨M)

¥»©«³Ì«á¥Ñ av8d ©ó 2011-11-14 09:44 ½s¿è

¦p¦ó»s§@¤@­Ó·|°Êªº¥\¯à°Ï¶ô?
·í¸ê®Æ¦hµ§®É¡A§Ú­Ì·|¹B¥Î¨ì·Æ¹«¥h©Ô°Ê¥k¤èªº´Î¤l¡A·í¦V¤U©Ô°Ê®É¡A©Ò»s§@ªº¥\¯à»Ý­n¥Î¨ìªº®É­Ô
¡A¥²¶·¦V¤W©Ô¤è¥i¨Ï¥Î¡A­Y¬O¥i¥H»s§@¤@­Ó·|°Êªº¥\¯à°Ï¶ôºò¶KµÛ³o­Ó´Î¤l¡A´N¥i¥H¤è«K¨Ï¥ÎªÌ¨Ï¥Î¡A
³o­Ó³¡¤À¦n¹³¥u¦³¦bºô­¶¬Ý¨ì¡A¤£ª¾¹DExcel¬O§_¦³³o­Ó¥\¯à©O?

¦^´_ 1# av8d
¾Ú§Ú©Òª¾À³¸Ó¨S¦³,
¦]¬°©Ô°Ê±²°Ê´Î³o­Ó°Ê§@¦b Excel ¦ü¥G¨Ã¨S¦³´£¨Ñ¹w³]ªºÄ²µo°Ê§@¨ç¦¡.

¤£¹L­Y§A¥i¥H§ï¥Î¥ýÂI¥ô¤@Àx¦s®æ,
«á¦A«ö¤W¤U¤è¦VÁä¨Ó²¾°Êªº¸Ü,
Excel ­Ë¬O¦³´£¨Ñ¤@­Ó Selection Change ¨ç¦¡¥i¥HIJµo.

¦Ü©ó²¾°ÊÀx¦s®æµJÂI®É¦P¨B²¾°Ê±±¨î¶µ«h¤£¬O°ÝÃD.
  1. Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  2.   cbBtn.Top = Selection.Top
  3. End Sub
½Æ»s¥N½X
²¾°ÊÀx¦s®æµJÂI®É¦P¨B²¾°Ê±±¨î¶µ.zip (7.58 KB)

©Ò¥H·Q­n¹F¨ì§Aªº»Ý¨D,
ÃöÁä¦b©ó¦p¦ó¹F¨ì©Ô°Ê±²°Ê´Î®É¥i¥HIJµo¬Y­Óµ{§Ç,
³o­Ó§Ú¤£·|.

TOP

­Y¯à©ú¥Õ»¡¥X"©Ò»s§@ªº¥\¯à"¡A°ÝÃD´N¦n³B²z
³o¼Ëªº´£°Ý¨S¤H¯à²q³z¤°»ò¬O"©Ò»s§@ªº¥\¯à"¡A³s­Ó¤è¦V³£¨S¦³¡C

TOP

¥»©«³Ì«á¥Ñ av8d ©ó 2011-11-14 09:43 ½s¿è

¦^´_ 2# luhpro


    ·PÁ¤j¤j©Ò´£¨Ñªº¤èªk¡A¯uªº¬O«Ü´Î«Ü¹ê¥Î¡C

·Q¸ß°Ý¤@¤U¤j¤j¡A¦pªG¦³¨â±Æ¥H¤Wªº¥\¯àªº¸Ü¡A§Ú«h§â¥¦¦P¨B¼W¥[§Y¥i¡A¦¹°µªk¬O§_¥¿½T©O?

TOP

¦^´_  luhpro
¦pªG¦³¨â±Æ¥H¤Wªº¥\¯àªº¸Ü¡A§Ú«h§â¥¦¦P¨B¼W¥[§Y¥i¡A¦¹°µªk¬O§_¥¿½T©O? ...
av8d µoªí©ó 2011-11-14 09:40

¦pªG­n¦P¨B²¾°Ê¨â­Ó¥H¤Wªºª«¥ó¦ì¸m,
«Øij±Ä¥Î ¼W´î¶q ªº¤è¦¡,
¤]´N¬O¥ýºâ¥X²Ä¤@­Ó(§Y¦ì²¾°ò·Ç)ª«¥ó¦ì¸m»Ý°¾²¾¦h¤Ö, (²¾°Ê«á¦ì¸mªºTop - ­ì¥ý¦ì¸mªºTop)
µM«á "¨C­Óª«¥ó" ³£°µ¦P¼Ëªº¼W´î¶q. (¨Ì§Ç±N»Ý²¾°Êªºª«¥óªº Top = ­ì¥ý¦ì¸mªº Top + ¤W­±­pºâ¥X¨Óªº¼W´î¶q)
¦ì²¾®ÄªG¥iµ¥¦P powerPoint ªº¸s²Õª«¥ó¦ì²¾.

TOP

­Y"¥\¯à°Ï¶ô"«üªº¬O«ö¶s
³Ì¦nªº¿ìªk¬O©Ô¥X¤@­Ó¦Û­q¤u¨ã¦C
¤£ºÞ´X­Ó«ö¶s³£©ñ¦b¸Ì­±
¥u­n¤£¬O¥Î·Æ¹«¥h©ì°Ê¡A¤£ºÞµøµ¡«ç»ò²¾°Ê¥Ã»·°±¦bµøµ¡©T©w¦ì¸m¡C
«ö¶s©ñ¦buserform¤¤¤]¦³¬Û¦P®ÄªG¡C

TOP

¦^´_ 6# oobird

userform¤º¤]¥i¥H? ½Ð°Ý¼gªk¬O§_¬Û¦P©O?

TOP

userformªºStarUpPositionÄݩʹw³]­È´N¬O¦bµøµ¡¤¤¥¡
¸ò¥»¤£¥Î¼g¥ô¦óµ{¦¡½X¥¦³£·|¦bµøµ¡¤¤¥¡¡A¤£ÀHÄæ¦Cªº±²¶b²¾°Ê


TOP

        ÀR«ä¦Û¦b : ªY½à§O¤H´N¬O²øÄY¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD