Text2.Text = Mid(Text1.Text, 1, 1) * (16 * 16 * 16 * 16) + Mid(Text1.Text, 2, 1) * (16 * 16 * 16) + Mid(Text1.Text, 3, 1) * (16 * 16) + Mid(Text1.Text, 4, 1) * 16 + Mid(Text1.Text, 5, 1)
这个溢出 怎么解决??谢谢
这个溢出 怎么解决??谢谢
Mid(Text1.Text, 1, 1) * (16 * 16 * 16 * 16)
+ Mid(Text1.Text, 2, 1) * (16 * 16 * 16)
+ Mid(Text1.Text, 3, 1) * (16 * 16)
+ Mid(Text1.Text, 4, 1) * 16
+ Mid(Text1.Text, 5, 1)这好像是一个十进制转16进制吧。可以用循环的。
Dim t As Currency
Dim s As String
Randomize Timer
s = CStr(CLng(Rnd * 10000000))
Debug.Print s
Dim i As Long
Dim l As Long
l = Len(s)
For i = 1 To l
t = t * 16
t = t + Val("&h" & Mid(s, i, 1))
Next i
Debug.Print t & " " & Hex$(t)
End Sub
Text2.Text = Mid(Text1.Text, 1, 1) * 16^4 + Mid(Text1.Text, 2, 1) * 16^3 + Mid(Text1.Text, 3, 1) * 16^2 + Mid(Text1.Text, 4, 1) * 16^1 + Mid(Text1.Text, 5, 1)