Bonjour a tous, j'ai une fonction dans laquel je dois mettre la valeur a chercher entre guillemet.
ex.:
HexToBin ("A5")
j'aimerais pouvoir ecrire:
valeur= A5
HexToBin (valeur)
Peut-on modifier la ligne suivant pour ca?
Function HexToBin(NombreHex As String) As String
Dim tHex, tBin
Dim i As Integer, j As Integer
Dim Binaire As String
Dim Trouve As Boolean
Binaire = ""
NombreHex = UCase(NombreHex)
tHex = Array("0", "1", "2", "3", "4", "5", "6", "7", "8", "9", "A", "B", "C", "D", "E", "F")
tBin = Array("0000", "0001", "0010", "0011", "0100", "0101", "0110", _
"0111", "1000", "1001", "1010", "1011", "1100", "1101", "1110", "1111")
For i = 1 To Len(NombreHex)
Trouve = False
For j = 0 To 15
If tHex(j) = Mid(NombreHex, i, 1) Then
Binaire = Binaire & tBin(j)
Trouve = True
Exit For
End If
Next j
If Not Trouve Then HexToBin = "": Exit Function
Next i
HexToBin = Binaire
End Function