[µo°Ý] ¦b¦P¤@®æinput©Moutput

lightshadow

¦U¦ì«e½ú

¦pªG§Ú·Q¦b¾ã­Ócolumn A ¥Î¤@­Óvba¥¨¶°

§Ú¦bA1¿é¤J"1",µM«áA1·|ÅÜ"¤@"
¦bA2¿é¤J"2",µM«áA2·|ÅÜ"¤G"
....
...
¦Ü¨ì"5" > "¤­"

À³¸Ó«ç¼Ë¼g?
ÁÂÁÂÀ°§U

owen06

¦^´_ 1# lightshadow


    ¸Õ¸Õ¬Ý

1. Private Sub Worksheet_Change(ByVal Target As Range)
   
2. With Target
   
3.     If .Column = 1 And .Row >= 1 Then
   
4.        .NumberFormatLocal = "[DBNum1][$-404]G/³q¥Î®æ¦¡"
   
5.     End If
   
6. End With
   
7. End Sub

½Æ»s¥N½X

ashan0418

¦^´_ 2# owen06


¤j¤j: ¯à§_½Ð±Ð¡y[DBNum1][$-404]G/³q¥Î®æ¦¡¡z¬O¦p¦ó¸ÑÄÀ??

owen06

¦^´_ 3# ashan0418

´N¥u¬O¤@­Ó¥L¤º«Øªºµ{¦¡½X¡AµL±q¸ÑÄÀ@@
±Ð§A¤@­Ó¤èªk¡A§A¦b¥ô¤@Àx¦s®æ¿é¤J¼Æ¦r1¤§«á¡A«ö¥kÁä¿ï¡yÀx¦s®æ®æ¦¡¡z¡AµM«á¿ï¡y¯S®í¡z¦A¿ï¡y¤@¸U¤G¤d¤T¦Ê¥|¤Q¤­¡z¨º­Ó¡A«ö½T©w¡AµM«á¦A«×¶i¤JÀx¦s®æ®æ¦¡¸Ì¡A³o¦¸¿ï¡y¦Û­q¡z¡A§A´N·|¬Ý¨ì³Ì¤U­±¦³¤@­Ó[DBNum1][$-404]G/³q¥Î®æ¦¡¡A³o®É­Ô´N§ä¨ì§A­nªº¸Ñµª°Õ¡C

[DBNum1]¡GÅã¥Ü¤@¡B¤G¡B¤T¡B¥| ¡K

[DBNum2]¡GÅã¥Ü³ü¡B¶L¡B参¡B¸v ¡K

[DBNum3]¡GÅã¥Ü¢°¡B¢±¡B¢²¡B¢³ ¡K(¥þ«¬)

[DBNum4]¡GÅã¥Ü1¡B2¡B3¡B4 ¡K(¥b«¬)

ashan0418

¦^´_ 4# owen06


­ì¨Ó¬O¦b¡y¯S®í¡z¤¤¿ïªº¡AÃø©Ç§Ú¤@ª½§ä¤£¨ì!!

ÁÂÁ¤j¤jªº»¡©ú!!

Hsieh

¦Û­qÀx¦s®æ¼Æ­È®æ¦¡
[<1]G/³q¥Î®æ¦¡;[<6][DBNum1]G/³q¥Î®æ¦¡;0