The code for translating Decimal to Binary:
Code:
Function Bin2Dec(strBinary As String) As Long
Dim Ret_Val As Long, intBinLen As Integer
Dim i As Integer
intBinLen = Len(strBinary)
For i = intBinLen To 1 Step (-1)
If Mid$(strBinary, i, 1) = "1" Then
Ret_Val = Ret_Val + (2 ^ (intBinLen - i))
End If
Next i
Xit_Bin2Dec:
Bin2Dec = Ret_Val
End Function
Translating Decimal to Binary
Code:
Function Dec2Bin(lngDecimal As Long) As String
Dim Ret_Val As String, dbl_Temp0 As Double
Dim str_Temp0 As String
lng_Temp0 = lngDecimal
Ret_Val = ""
While lng_Temp0 > 0
str_Temp0 = "0"
lng_Temp0 = lng_Temp0 / 2
If lng_Temp0 > Int(lng_Temp0) Then str_Temp0 = "1"
Ret_Val = str_Temp0 & Ret_Val
lng_Temp0 = Int(lng_Temp0)
Wend
Xit_Dec2Bin:
Dec2Bin = Ret_Val
End Function