News:

GinGly.com - Used by 85,000 Members - SMS Backed up 7,35,000 - Contacts Stored  28,850 !!

Main Menu

Let the user check items in a grid in Excel VBA

Started by nandagopal, Nov 03, 2008, 08:00 PM

Previous topic - Next topic
Go Down Pages1

nandagopal

Nov 03, 2008, 08:00 PM
When the user clicks on a row, the program toggles whether the first column contains an X.

Code Select

' Toggle this row.
Private Sub flxAnimals_Click()
    If flxAnimals.TextMatrix(flxAnimals.Row, 0) = "X" Then
        flxAnimals.TextMatrix(flxAnimals.Row, 0) = ""
    Else
        flxAnimals.TextMatrix(flxAnimals.Row, 0) = "X"
    End If
End Sub


See the code for additional details.


Go Up Pages1