'dans la premiere forme frmMsFlexGrid Private Sub Command1_Click() 'Me.Hide frmReception.Show 1 End Sub Private Sub Form_Load() MSFlexGrid1.AddItem ("Bonjour"), 1 MSFlexGrid1.AddItem ("WolfKiller"), 2 End Sub 'dans la deuxieme frmReception Private Sub Form_Load() Label1.Caption = frmMsFlexGrid.MSFlexGrid1.TextMatrix(1, 0) Label2.Caption = frmMsFlexGrid.MSFlexGrid1.TextMatrix(2, 0) End Sub
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionPrivate Sub MSFlexGrid1_Click() MsgBox ("Click :" + Format(MSFlexGrid1.Row) + " " + Format(MSFlexGrid1.Col)), vbOKOnly, "Test sur la FlexGrid" sText = MSFlexGrid1.TextMatrix(MSFlexGrid1.Row, 0) End Sub Private Sub MSFlexGrid1_RowColChange() MsgBox ("RowColChange :" + Format(MSFlexGrid1.Row) + " " + Format(MSFlexGrid1.Col)), vbOKOnly, "Test sur la FlexGrid" sText = MSFlexGrid1.TextMatrix(MSFlexGrid1.Row, 0) End Sub Private Sub MSFlexGrid1_SelChange() MsgBox ("SelChange :" + Format(MSFlexGrid1.Row) + " " + Format(MSFlexGrid1.Col)), vbOKOnly, "Test sur la FlexGrid" sText = MSFlexGrid1.TextMatrix(MSFlexGrid1.Row, 0) End Sub 'dans la deuxieme forme Private Sub Form_Load() Dim i As Integer Label1.Caption = sText Label2.Caption = frmMsFlexGrid.MSFlexGrid1.TextMatrix(2, 0) End Sub
Option Explicit 'Choisir qqch dans la combo et cliquer sur la grille pour la valider Private Sub Combo1_Validate(Cancel As Boolean) Dim tempo As String MSFlexGrid1.AddItem (Combo1.Text), 3 Debug.Print Combo1.ListIndex tempo = Combo1.List(Combo1.ListIndex) MSFlexGrid1.AddItem (tempo), 4 End Sub Private Sub Form_Load() sText = "Rien" MSFlexGrid1.AddItem ("Bonjour" + vbTab + "ReBonjour"), 1 MSFlexGrid1.AddItem ("WolfKiller"), 2 Combo1.List(0) = "Hello" Combo1.List(1) = "CrazyBlinkGirl" End Sub