7,763
社区成员
发帖
与我相关
我的任务
分享
Option Explicit
Private Sub Text1_GotFocus()
'去除 % 进行输入'
Text1 = Trim$(Replace(Text1, "%", vbNullString))
Text1.SelStart = 0
Text1.SelLength = &HFFFF&
End Sub
Private Sub Text1_LostFocus()
'无论用户是否输入了 %,一律当作百分数处理'
Dim sText As String
sText = Trim$(Replace(Text1, "%", vbNullString))
Text1 = FormatPercent(Val(sText) / 100, 2, vbTrue)
End Sub