Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 125
  • Last Modified:

find if all values are filled in a column in msflexgrid

I am using a flexgrid in vb6 and I have a column named ProgressSetbacks.  How can I check to make sure everything in the current flexgrid column ProgressSetbacks has a value in it?
0
al4629740
Asked:
al4629740
  • 2
1 Solution
 
Martin LissRetired ProgrammerCommented:
Try this. Set the MyCol constant to the ProgressSetbacks column (the first column is 0).    

    Const MyCol = 1
    Dim lngRow As Long
    With MSFlexGrid1
        For lngRow = 0 To .Rows - 1
            If .TextMatrix(lngRow, MyCol) = "" Then
                MsgBox "Incomplete"
                Exit Sub
            End If
        Next
    End With

Open in new window

0
 
Martin LissRetired ProgrammerCommented:
I'm glad I was able to help.

In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now