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
| Public selectedFund As String
Private Sub CommandButton1_Click()
If TextBox1.Value = "" Then
MsgBox "Devise non valide"
Exit Sub
End If
If selectedFund = "" Then 'ne devrait pas se produire
Exit Sub
End If
Dim rg As Range
Dim lastCol As Integer
Set rg = Sheets("ETAT NEWEDGE").Range("A:A").Find(selectedFund)
If rg Is Nothing Then 'ne devrait pas se produire
Exit Sub
End If
lastCol = rg.Offset(0, 200).End(xlToLeft).Column + 1
rg.Offset(0, lastCol - 1).Value = TextBox1.Value
ListBox1.AddItem TextBox1.Value
End Sub
Public Sub InitForm()
If selectedFund = "" Then 'ne devrait pas se produire
Unload Me
End If
Dim rg As Range
Dim i As Integer
Set rg = Sheets("ETAT NEWEDGE").Range("A:A").Find(selectedFund)
If rg Is Nothing Then 'ne devrait pas se produire
Unload Me
End If
i = 3
Do While rg.Offset(0, i).Value <> ""
ListBox1.AddItem rg.Offset(0, i).Value
i = i + 1
Loop
End Sub |
Partager