Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionDim i As Integer Dim Num As Integer For i = 0 To Me.Controls.Count - 1 If TypeOf Me.Controls(i) Is ComboBox Then Num = CInt(Mid(Me.Controls(i).Name, Len(Me.Controls(i).Name), 1)) Me.Controls(i).AddItem Num End If Next
Dim i As Integer Dim Num As Integer For i = 0 To Me.Controls.Count - 1 If TypeOf Me.Controls(i) Is ComboBox Then Num = CInt(Mid(Me.Controls(i).Name, Len(Me.Controls(i).Name), 1)) msgbox "ComboBox NUmero " & NUm & " Valeur " & Me.Controls(i).Value (ou text je sais plus.) End If Next
Num = CInt(Mid(Me.Controls(i).Name, Len(Me.Controls(i).Name), 1))
Num = CInt(Mid(Me.Controls(i).Name, Len(Me.Controls(i).Name), IIF((i<9), 1, 2)))
Num = CInt(Mid(Me.Controls(i).Name, IIF((i<9), Len(Me.Controls(i).Name), Len(Me.Controls(i).Name) - 1)), IIF((i<9), 1, 2)))
Private sub Valeur(bo as boolean) msgbox "i = 0? " & bo end sub Private sub Form_load() dim i as integer i = 0 'i = 8 call Valeur(IIF((i = 0), True, False)) end sub
Dim i As Integer Dim Num As Integer Dim StrName as string For i = 0 To Me.Controls.Count - 1 If TypeOf Me.Controls(i) Is ComboBox Then StrName = Me.Controls(i).Name C(CInt(Right(StrName, Len(StrName) - 5))) = Me.Controls(i).Text Next
Dim i As Integer Dim StrName As String Dim C(1 To 20) For i = 0 To Interface.Controls.Count - 1 If TypeOf Interface.Controls(i) Is ComboBox Then StrName = Interface.Controls(i).Name Num = CInt(Right(StrName, Len(StrName) - 8)) C(Num) = Interface.Controls(i).text MSG = MsgBox(Interface.Controls(i).Name & " - Valeur : " & C(Num)) End If Next