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

[µo°Ý] Excel ¦p¦ó¥¿¼Æ¦Û°ÊÅÜ­t¼Æ

[µo°Ý] Excel ¦p¦ó¥¿¼Æ¦Û°ÊÅÜ­t¼Æ

Excel ¦p¦ó¥¿¼Æ¦Û°ÊÅÜ­t¼Æ

Microsoft Office Excel 2003
½Ð°Ý¡G
¥\¯àªí¤W¦³¤°»ò¿ï¶µ
¯àÅý§Ú¦bÀx¦s®æ¶ñ¤Jªº¥¿¼Æ³£¦Û°ÊÅã¥Ü¬°­t¼Æ?
EX¡G
A1¶ñ¤J1¡A·|¦Û°ÊÅã¥Ü-1¡A¹ê»Ú¤Wªº­nªº­È¤]¬O-1
A2¶ñ¤J10¡A·|¦Û°ÊÅã¥Ü-10¡A¹ê»Ú¤Wªº­nªº­È¤]¬O-10

ÁÂÁ·P®¦!

Àx¦s®æ®æ¦¡-¦Û­q-Ãþ«¬¡÷-#¡C

TOP

¦^´_ 2# slamdum

³o¼Ë¥u¬OÅã¥Üµ²ªG±o¨ì»Ý¨D¡AÀx¦s®æ¹ê»Ú¤º®eÁÙ¬O­ì¿é¤Jªº¼Æ­È
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# slamdum


    ¶â §Ú¸Õ¬Ý¬Ý¡I

TOP

¥ÎVBA¥i¥H
  1. Private Sub Worksheet_Change(ByVal Target As Range)
  2. If Target.Column = 1 And Target.Row > 0 Then
  3. Target = Abs(Target) * -1
  4. End If
  5. End Sub
½Æ»s¥N½X
¦^´_ 1# la1975

TOP

        ÀR«ä¦Û¦b : ¤Hªº²´·úªø¦b«e­±¡A¥u¬Ý¨ì§O¤Hªº¯ÊÂI¡Aµ·²@¬Ý¤£¨ì¦Û¤vªº¯ÊÂI¡C
ªð¦^¦Cªí ¤W¤@¥DÃD