Volatile Functions needed for Roulette

[Nickmsi]

Hello . . .

I use Excel to power a Roulette Bot. Until today, I have been able to do everything using just the basic Excel Functions. However, I do not know how to handle volatile functions.

I have been told that I need some sort of UDF or VBA modules, which I have not used before, but am willing to learn.

What I need is some function that will make a volatile cell into a static cell. I have uploaded a Roulette Sample 6 x 6 matrix. Every time a number is entered into Column A, we get an updated Volatile result in Column H (Yellow).

I need to get a Static result in Column I for the 6 Volatile results in Column H.

Every time a number is entered in Column A, I should get a new volatile result in Column H and a corresponding new static results in Column I.

Any help is greatly appreciated.

Thanks

Nick

[Richard Buttrey]

Hi,

Can you give a specific example. Are you saying that before the volatile cell changes in response to a change in column A you want the current value in H to appear as a non volatile in column I?

If so try the attached

[Nickmsi]

Thanks Richard . . . .

Yes, when a number is entered in to Column A, we should get a result in Column H (Volatile) and a corresponding result in Column I (static). I would then use the static result in Column I to place a bet.

Your attached file is so close, so very close.

When I enter a number in Column A, we get a Volatile result in Column H but we do not get the static result in Column I until I enter the next number. We need the static result at the same time we get the volatile result.

Hope this makes sense and as always thanks for your help.

Nick

[Richard Buttrey]

Hi,

I did consider that, but doesn't that mean that column I will ALWAYS show the same as column H? And in which case what does having a static copy add to your knowledge?

At the moment before you enter a new number the existing column H is put into column I as a static value. I had assumed that you wanted to compare a before and after position.

[Nickmsi]

Yes, Sir . . .

The Volatile and the Static will always be the same.

However, I need a Static number to place a bet.

The bot will place a bet correctly using the Volatile results but the Excel sheet that powers the bot will not be in sync. Each new entry will change the previous entries in the Excel Sheet and we can't have that as we have to accumulate statistic as well.

I hope I am making sense but we do need a Static result to place the bet and the Static result has to be the same as the Volatile result.

If it would be helpful, I can code a sample sheet using just the Volatile functions so you can what is happening.

Thank you for your help.

Nick

[Richard Buttrey]

OK,

So does the attached, with a small variation give you what you want?

[Nickmsi]

Yes, that is exactly what it needs to do.

Thank you so much for your assistance.

I need to learn what you did for learning sake and for future projects. As I am a novice in using VBA or UDF or whatever you did, can you advise how I can access what you did? Where do I go to see what and how you did what you did?

Thanks again for your time and assistance.

Nick

[Richard Buttrey]

Hi,

The solution uses the Sheet Change event as a trigger. Right click the sheet tab name and choose 'View Code'.