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: 274
  • Last Modified:

how to get highest number of listbox ?

I have a listbox and i have numbers added into it (only numbers) ... how can i determine highest number in that list containing numbers?
0
BILAL69
Asked:
BILAL69
1 Solution
 
Adel87Commented:
Hi,

The attached code should do the trick.

Please reply if you need further assistance.

Regards,
Dim max As Double
For x = 0 To List1.ListCount - 1
If List1.List(x) > max Then
max = List1.List(x)
End If
Next
MsgBox "The highist number is : " & max

Open in new window

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!

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