Test all cells in a column

[jamesd0142]

I have a datagrid (view diagram).

I want to write a procedure that picks out all cells in column 3 (third from the right - column 2, tecnically) and tests each to make sure they are less than 255 characters. If not, msgbox("length too large").

Is this possible and could any point me in the right direction?

I don't even know where to start!

Thanks James

[kadghar]

I have a datagrid (view diagram)...

Try checking cell by cell, something like this should help:

Dim i As Integer
For i = 0 To 2
    If Len(DataGrid1.Rows(i).Cells(2).Value) >= 255 Then
        MsgBox("length too large")
        Exit Sub
    End If
Next