+ Reply to Thread
Results 1 to 3 of 3

randomize and find the max number in the list

  1. #1
    Registered User
    Join Date
    10-15-2013
    Location
    united states
    MS-Off Ver
    Excel 2010
    Posts
    64

    randomize and find the max number in the list

    In visual basic 2005 I want to generate a list of random number from 0 to 100 and show 10 number at each time in a listbox and in the separate label outputs the maximum number. I wrote this code which I think most of it correct but don’t know where I went wrong?! Someone can show me my mistakes and tell me how to get this program run

    Please Login or Register  to view this content.
    Last edited by 1Melina; 03-24-2016 at 07:42 AM.

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: randomize and find the max number in the list

    Where is your list box to be located? Sheet or userform.

    Where in your code do you mention the listbox?

    In your Fill Array you are creating 100 random numbers but are not using them to fill your array.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    10-15-2013
    Location
    united states
    MS-Off Ver
    Excel 2010
    Posts
    64

    Re: randomize and find the max number in the list

    the list box call lstRandom - and it is on the form
    The output for the Max number is lblMax which should be figured from the function procedure

    Thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Randomize number and text
    By Domino, S.Kom in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 04-16-2014, 02:40 AM
  2. How to Randomize a list
    By isameer in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 01-06-2014, 02:17 AM
  3. Randomize a list into two columns
    By pfly in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-29-2012, 01:28 PM
  4. Randomize From A List Of Different Macro's
    By markswan20 in forum Excel General
    Replies: 3
    Last Post: 06-25-2010, 10:50 PM
  5. Randomize a List
    By Niester Rabbit in forum Excel General
    Replies: 5
    Last Post: 06-07-2009, 02:19 PM
  6. [SOLVED] How do I randomize a list of 20 people?
    By Ken P in forum Excel General
    Replies: 2
    Last Post: 08-08-2006, 05:45 PM
  7. [SOLVED] How do I randomize a list without repeats
    By K9CE in forum Excel General
    Replies: 2
    Last Post: 10-13-2005, 02:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1