load numbers

[giant]

Hello All,

In my workbook,i have 4 sets of numbers on sheet1.

what i want to do is on sheet2 B3 display the total number of first numbers.
and in F14 draw these numbers one by one only showing one number at a time until all the numbers in the first number column are drawn
each number drawn cell B3 will subtract one.
then when B3 is down to 0 then C3 will display completed and the program will start drawing the second numbers.

Please take a look at my workbook.

Thanks in advance for any advice.

[MickG]

Place this in the worksheet module of sheet 2.
Cell "E14" should be blank and then each click on it should result in numbers from sheet 1
It should work but could do with some refining.

Please Login or Register  to view this content.

Regards Mick

[giant]

Hello MickG,

Thank you for the time and effort to create this code.

I have been trying it and it works as i asked you.But now seeing it working i realise using it with worksheet change event
it is not what i had hoped to achieve.
the user that will be using this will not constantly click the worksheet to load the next number so can i ask
would it be very difficult to use this with a button on the sheet so when the person wants to see another number
they press the button.
Easier and less complicated for them to use.

Thanks Again.

[MickG]

Try this in "CommandButton1".

Please Login or Register  to view this content.

Regards Mick

[giant]

Hello MickG,

Thanks once again for your time.

The result is perfect.
Can i ask in your code.
This line

Please Login or Register  to view this content.

what does the -1 part do.

[MickG]

Thank you for your response.
Ref "-1".
The second column of the array "Ray" holds the Column number of the sets of numbers, "Ac" referenced in sheet 1. (Shown below)
This also refers by "Rw which is the Particular row in sheet2 where the related counts are reduced by one on each Click of the button.

Please Login or Register  to view this content.

Each time you click the button the column reference is added to column 2 of array "Ray".
When A new column is entered the previous entry will be different, the "-1" refers to the previous entry, and if that its different then that column of numbers has been finished and the word "Completed" can be added.

Regrds Mick