|
表單區//
Private Sub UserForm_Initialize()
系數 = Sheet17.[f1] * 100
End Sub
Private Sub 重置_Click()
系數 = 100: Pcnt = 100: xMode = 1: Call 系數更改
End Sub
Private Sub 确定_Click()
If IsNumeric(系數) Then Pcnt = 系數: xMode = 2: Call 系數更改
End Sub
'----------------------------------
模組區//
Public Pcnt, xMode%
Sub 系數表單()
UserForm1.Show 0
End Sub
Sub 系數更改()
Pcnt = Pcnt / 100
If xMode = 1 And Sheet17.[f1] = 1 Then Exit Sub
Sheet17.[f1] = Pcnt
With range(Sheet7.[g3], Sheet7.[h65536].End(3)(3, 0))
.formula = "=IF(N(H3)=0,"""",ROUND(H3*" & Pcnt & ",1))"
.Value = .Value
End With
End Sub
工作表名稱自行調適~~
|
|