- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 244
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-11-10
|
¦^´_ 1# metrostar - Private Sub Worksheet_Change(ByVal Target As Range)
- If Intersect(Target, [D3:D8]) Is Nothing Or Target.Count <> 1 Then Exit Sub
- If Application.Sum([D3:D8]) < 510 Then msg = "¼ÆÈÁ`©M®t " & 510 - Application.Sum([D3:D8])
- If Target Mod 1 <> 0 Then msg = "¥u¯à¿é¤J¾ã¼Æ": fs = True
- If Application.Sum([D3:D8]) > 510 Then msg = "¼Æȳ̤j¥u¯à¿é¤J " & 510 - Application.Sum([D3:D8]) + Target: fs = True
- If Target < 0 Or Target > 255 Then msg = "¼ÆÈ¥u¯à¤¶©ó0~255": fs = True
- If msg <> "" Then MsgBox msg
- If fs = True Then Target.Select
- End Sub
½Æ»s¥N½X |
|