ReDim Tbl2(0 To UBound(Tbl1), 0 To UBound(Tbl1(0))) For I = 0 To UBound(Tbl2) For J = 0 To UBound(Tbl2, 2) Tbl2(I, J) = Tbl1(I)(J) Next J Next I Erase Tbl1 UserForm1.ComboBox1.List = Tbl2 UserForm1.Show End Sub
AV qui s'évacue....
Sub zzz_Combo()
Dim Tbl1, Tbl2() As String
Dim I As Integer, J As Integer
ReDim Tbl2(0 To UBound(Tbl1), 0 To UBound(Tbl1(0)))
For I = 0 To UBound(Tbl2)
For J = 0 To UBound(Tbl2, 2)
Tbl2(I, J) = Tbl1(I)(J)
Next J
Next I
Erase Tbl1
UserForm1.ComboBox1.List = Tbl2
UserForm1.Show
End Sub
ReDim Tbl2(0 To UBound(Tbl1), 0 To UBound(Tbl1(0))) For I = 0 To UBound(Tbl2) For J = 0 To UBound(Tbl2, 2) Tbl2(I, J) = Tbl1(I)(J) Next J Next I Erase Tbl1 UserForm1.ComboBox1.List = Tbl2 UserForm1.Show End Sub
AV qui s'évacue....
Polemos
Merci AV pour le temps que tu prends pour nous répondre !
Cordialement, Polemos
On Sat, 4 Dec 2004 11:58:33 +0100, "AV" wrote:
Sub zzz_Combo() Dim Tbl1, Tbl2() As String Dim I As Integer, J As Integer
ReDim Tbl2(0 To UBound(Tbl1), 0 To UBound(Tbl1(0))) For I = 0 To UBound(Tbl2) For J = 0 To UBound(Tbl2, 2) Tbl2(I, J) = Tbl1(I)(J) Next J Next I Erase Tbl1 UserForm1.ComboBox1.List = Tbl2 UserForm1.Show End Sub
AV qui s'évacue....
Merci AV pour le temps que tu prends pour nous répondre !
Cordialement,
Polemos
On Sat, 4 Dec 2004 11:58:33 +0100, "AV" <alainPFFFvallon@wanadoo.fr> wrote:
Sub zzz_Combo()
Dim Tbl1, Tbl2() As String
Dim I As Integer, J As Integer
ReDim Tbl2(0 To UBound(Tbl1), 0 To UBound(Tbl1(0)))
For I = 0 To UBound(Tbl2)
For J = 0 To UBound(Tbl2, 2)
Tbl2(I, J) = Tbl1(I)(J)
Next J
Next I
Erase Tbl1
UserForm1.ComboBox1.List = Tbl2
UserForm1.Show
End Sub
ReDim Tbl2(0 To UBound(Tbl1), 0 To UBound(Tbl1(0))) For I = 0 To UBound(Tbl2) For J = 0 To UBound(Tbl2, 2) Tbl2(I, J) = Tbl1(I)(J) Next J Next I Erase Tbl1 UserForm1.ComboBox1.List = Tbl2 UserForm1.Show End Sub