- ©«¤l
- 58
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 117
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- 2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2017-12-2
- ³Ì«áµn¿ý
- 2021-12-16
|
¦^´_ 2# ã´£³¡ªL
¥i¥H¥¿±`¾Þ§@¤F¡A·PÁÂ
¥t¥~·Q°Ý¤@¤U
¬°¦ó±N
Dim x As Integer '«Å§i¬°¾ã¼Æ «h·|Åܦ¨¿ù»~
ÁÙ¦³Yx ¿é¤Jt¼Æ«h¤£°Ê§@
(µL½×x«Å§i¬°¦r¦ê©Î¾ã¼Æ³£¬O)
±NXÈ¿é¤Jt¼Æ
µ{¦¡½X¨«¨ì³o
Range("by" & row) = ³Ó³õ¼Æ + x
À³¸Ó¬O ³Ó³õ¼Æ + tÈ
¥X¨Óªº¼Æ¦rÀ³¸Ó¬On ³Ó³õ¼Æ - Ȥ~¹ï- Dim x As Integer
- x = InputBox("²Ä" & row & "¦æ" & "³Ó³õ¡G" & ³Ó³õ¼Æ & "³õ" & vbCrLf & "¬O§_³Ó§Q¨Ã¥[Áä¤Jªº¼Æ¶q¤W¥h", "½T»{µ¡¤f", 1)
- '¦^¶ÇªºÈ¡A1=½T©w 2=¨ú®ø 3=²§±`²×¤î 4=«¸Õ 5=²¤¹L 6=¬O 7=§_
- MsgBox x
- If Val(x) > 0 Then '±N¤å¦rÂର¼ÆÈ
- Range("by" & row) = ³Ó³õ¼Æ + x
- ElseIf x = "" Then
- MsgBox "¤w¨ú®ø¾Þ§@"
- End If
- End Sub
½Æ»s¥N½X |
|