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

rouber590324

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

joshzhong

­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

rouber590324

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