|
求助高手帮我看看下面的语句到底哪里出错了:
一共想执行三个假设:1,如果输入YES,自己输入alpha beta gamma值。2. 如果输入NO,从原始Sheet上直接复制粘贴到分页上。3.其他输入,弹出msgbox
Sub SmoothValueChoose()
Dim statement As String
statement = InputBox("Do you want input your own value? Please enter 'YES' or 'NO'")
If statement = "YES" Then
Sheets("Final Result").Activate
Range("SmoothValue").Select
ActiveCell.Offset(1, 1).Value = InputBox("Please enter the 'Alpha' value, 0<Alpha<1 ")
Range("Alpha").Select
Selection.Copy
Sheets("H-W Update Mul").Select
Range("Alpha1").Select
ActiveSheet.Paste
Sheets("H-W Update Addi").Select
Range("Alpha2").Select
ActiveSheet.Paste
Sheets("Final Result").Activate
Range("SmoothValue").Select
ActiveCell.Offset(1, 2).Value = InputBox("Please enter the 'Beta' value, 0<Beta<1")
Range("Beta").Select
Selection.Copy
Sheets("H-W Update Mul").Select
Range("Beta1").Select
ActiveSheet.Paste
Sheets("H-W Update Addi").Select
Range("Beta2").Select
ActiveSheet.Paste
Sheets("Final Result").Activate
Range("SmoothValue").Select
ActiveCell.Offset(1, 3).Value = InputBox("Please enter the 'Gamma' value, 0<Gamma<1")
Range("Gamma").Select
Selection.Copy
Sheets("H-W Update Mul").Select
Range("Gamma1").Select
ActiveSheet.Paste
Sheets("H-W Update Addi").Select
Range("Gamma2").Select
ActiveSheet.Paste
Else: If statement = "NO" Then Sheets("Final Result").Activate
Range("Alpha").Select
Selection.Copyvalue
Sheets("H-W Update Mul").Select
Range("Alpha1").Select
ActiveSheet.Paste
Sheets("H-W Update Addi").Select
Range("Alpha2").Select
ActiveSheet.Paste
Range("Beta").Select '一直提示这里出错
Selection.Copyvalue
Sheets("H-W Update Mul").Select
Range("Beta1").Select
ActiveSheet.Paste
Sheets("H-W Update Addi").Select
Range("Beta2").Select
ActiveSheet.Paste
Range("Gamma").Select
Selection.Copyvalue
Sheets("H-W Update Mul").Select
Range("Gamma1").Select
ActiveSheet.Paste
Sheets("H-W Update Addi").Select
Range("Gamma2").Select
ActiveSheet.Paste
Else: MsgBox "Please make your Choice"
End If
End Sub
直接赋值,那些select语句都是多余的. - Sub SmoothValueChoose()
- Dim statement As String
- Dim a, b, g
- Sheets("Final Result").Activate
- statement = InputBox("Do you want input your own prameters? Please enter 'YES' or 'NO'")
- Select Case statement
- Case "YES"
- a = InputBox("Please enter the 'Alpha' value, 0<Alpha<1 ")
- b = InputBox("Please enter the 'Beta' value, 0<Beta<1")
- g = InputBox("Please enter the 'Gamma' value, 0<Gamma<1")
- ValueInput a, b, g
- Case "NO"
- a = Range("Alpha").Value
- b = Range("Beta").Value
- g = Range("Gamma").Value
- ValueInput a, b, g
- Case Else
- MsgBox "Please make your Choice"
- End Select
- End Sub
- Sub ValueInput(a, b, g)
- Range("Alpha").Value = a
- Sheets("H-W Update Mul").Range("Alpha1").Value = a
- Sheets("H-W Update Addi").Range("Alpha2").Value = a
-
- Range("Beta").Value = b
- Sheets("H-W Update Mul").Range("Beta1").Value = b
- Sheets("H-W Update Addi").Range("Beta2").Value = b
-
- Range("Gamma").Value = g
- Sheets("H-W Update Mul").Range("Gamma1").Value = g
- Sheets("H-W Update Addi").Range("Gamma2").Value = g
- End Sub
复制代码
|
|