Function hextoBin(X As String) As String
Const Bins = "0000000100100011010001010110011110001001101010111100110111101111"
Dim i As Integer, s As String
s = ""
For i = 1 To Len(X)
s = s + Mid(Bins, (Val("&h" + Mid(X, i, 1)) * 4 + 1), 4)
Next
hextoBin = Format(s, "0")
End Function
Private Sub Command1_Click()
MsgBox hextoBin("A4")
End Sub
Private Sub Command1_Click()
Dim i As Long
i = 1234
Dim j As Long
Dim s As String
Dim binstr As String
Do While 2 ^ j <= i
If (i And 2 ^ j) = 2 ^ j Then
s = "1"
Else
s = "0"
End If
binstr = s + binstr
Debug.Print CStr(i) + "的右数第" + CStr(j + 1) + "位为:" + s
j = j + 1
Loop
MsgBox CStr(i) + "的2进制表示为:" + binstr
End Sub