1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57
| Sub Table_Verite()
Dim valeur As Boolean
Dim x As Long
Dim p As Long
Dim k As Long
Dim m As Long
valeur = False
Cells.ClearContents
'=========================
'variable de l'utilisateur
x = 3
'=========================
'=========================
'nombre de ligne
k = 2 ^ x
'=========================
'=========================
'incrémentation
p = 2
'=========================
For i = 1 To x
k = k / 2
For j = 1 To p
For r = 1 To k
m = m + 1
If valeur = False Then
Cells(m, i) = 0
Else
Cells(m, i) = 1
End If
Next
If valeur = False Then
valeur = True
Else
valeur = False
End If
Next
m = 0
valeur = False
p = p * 2
Next
MsgBox "fin"
End Sub |