How do I know the max date in the second column of the list box?

[saftawy1]

How do I know the max date in the second column of the list box?

 

[Anthony47]

For example:

Debug.Print Application.WorksheetFunction.Max(Application.Index(UserForm1.ListBox1.List, 0, 2))

 

[saftawy1]

For example:

Debug.Print Application.WorksheetFunction.Max(Application.Index(UserForm1.ListBox1.List, 0, 2))

not working

 

[Anthony47]

Working for me
How did you try it, what you got back, how do you load the Listbox, how the source data looks for?

 

[saftawy1]

i try it too but not working

hisham.TextBox9.Value = Application.WorksheetFunction.Max(userform1.ListBox1.List(i, 2))

 

[Anthony47]

See my questions in post #4

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: how can to extract the max and min date from listbox on userform1?
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[saftawy1]

How do I know the max date in the second column of the list box?

ty i found the solve

Textbox1= Me.ListBox2.List(i, 0)
With Me.ListBox1
        For i = 0 To .ListCount - 1
            If .Selected(i) = False Then
                If CLng(.List(i, 0)) > lngMyMaxValue Then
                    lngMyMaxValue = CLng(.List(i, 0))
                End If
            End If
        Next i
    End With
     Textbox2 = lngMyMaxValue

 

[smozgur]

Post #2 answers the initial question that was asked without any specific control name or condition. Therefore, the marked solution has been switched as it provides the correct solution to the question in the general form as it was asked.