Change numbers

[mdshotgun]

Hello all,

Hope someone can help with this.

I have numbers in 5 columns B2 to F11 anything from 1 to 20.
What i am trying to do is when the button is pressed the numbers change.
ei- if B2 = 12 when i press button B2 either changes randomly to 11-13 or stays at 12.
if b2 was 10 then it changes to 9-11 or stays at 10.
The numbers in the other cells will be the same as B2.

Any help will be great.Thanks

[Blake 7]

in the cells with the numbers i entered =randbetween(1,19) > i then recorded a macro and added a button and associated the two.

Hope this helps with your lotto predictions! if you win remember me!!

dont forget, if this has helped please mark as solved!

[mdshotgun]

Thanks Blake 7 for the reply.

Yes i like your lotto predictions,but unfortunately it's not a lotto prediction we are doing.

The number in a cell can only go down/up by 1 or stay unchanged with each button click.

But thanks for trying anyway.

[Blake 7]

hiya - sorry i misread your post. Can you clarify what u mean by

"The numbers in the other cells will be the same as B2"

from you original post. I dont get this bit.

Cheers

[mdshotgun]

I was using cell B2 as an example.
and if you can get something working with example "B2"
then all the other numbers will do the same that is
ei-if i press button and B2 goes from 12 to 13 then B3 etc will either go up/down or stay the same just like B2.
Does this make it some bit clearer.Hopefully it does.

[mdshotgun]

Can anyone help with a solution for this problem.
Any help is very welcomed.

[Colin Legg]

If one cell (say B2) increases by 1 in value, should all of the other cells also increase by 1 in value, or is the change in each cell independent of the others?

[mdshotgun]

Thanks for replying.
The change in each cell should be independent of the others.

If for ex we take B2:F2.
B2=12 C2=8 D2=4 E2=9 F2=15

When the change numbers button is pressed.

B2 can go from 12 to 11 or 13 or stay at 12
C2 can go from 8 to 7 or 9 or stay at 8 etc.

If the button is pressed again and B2 went to 13 from prevoius button press
Then it now can go from 13 to 14 or back to 12 or just stay at 13 etc.

Thanks for replying and i hope you can help further.Thanks

[Colin Legg]

Hi,

So something like this:

Please Login or Register  to view this content.

I'll let you have a go at revising the code should you need to introduce a cap/floor (20/1) to the cell value.

[mdshotgun]

Hi Colin,

That is amazing,works a treat.

Thank you very much.I am totally gratefull.