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

[µo°Ý] InputBox°ÝÃD´M°Ý

[µo°Ý] InputBox°ÝÃD´M°Ý

DEAR  ALL ¤j¤j
1.¦p¹Ï¤@ ¬°¦ó X1 X2 X3 X4 §Ú³£¿é¤J1 Range("I7") = Y·|¨q¥X 1111 ¦Ó¤£¬O4
2.·Ð¤£§[½ç±Ð  THANKS    ROBERT 08/25

¹Ï¤@
Sub «ö¶s6_Click()
   X1 = InputBox("X1", "«ö¶s6")
   X2 = InputBox("X2", "«ö¶s6")
   X3 = InputBox("X3", "«ö¶s6")
   X4 = InputBox("X4", "«ö¶s6")
   Y = X1 + X2 + X3 + X4
   Range("I7") = Y
End Sub
ù

­n¥ý©w¸qÅܼƫ¬ºA, §_«hvba¹w³]¬°variant:
E.g.
   Dim X1 As Double
   Dim X2 As Double
   Dim X3 As Double
   Dim X4 As Double
   Dim Y As Double

TOP

DEAR  joshzhong  ¤j¤j
·PÁ«ü¾É  THANKS*10000   ROBERT 08/25
ù

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD