

Private Sub ComboBox1_Change()
With ComboBox1
Select Case .Value
Case ""
TextBox1.Value = ""
Case "一"
TextBox1.Value = TextBox2.Value
Case "二"
TextBox2.Value = Val(TextBox1.Value) * 0.6
End Select
End With
End Sub
Private Sub ComboBox1_LostFocus()
ComboBox1.ListIndex = -1
End Sub
Private Sub Worksheet_Activate()
TextBox1.Value = "我是1"
TextBox2.Value = "100"
End Sub