Problem with use of MOD

[exEExe]

Hi,

I have a cell "A1" where you are only allowed to type a number which can be divided by "1,5"

I am using a 'helping cell' A2 where I use the formula

Please Login or Register  to view this content.

This will give A2 the value 0 whenever A1 can be divided by 0.

So far, so good..

Then the problem starts:
A1 is being controlled by a UserForm TextInput.
I have set TextInput.ControlSource to A1

When the user is changing the value of TextInput, and A2 <> 0 then a loop is starting.
Cell A1 is supposed to decrease with 0,1 until A2 = 0

Here is the code:

Please Login or Register  to view this content.

I set a break point inside the loop to see what is going on:

A1 is set to for example 1,7
A2 become 0,2

A1 is then corrected to 1,6
A2 become 0,1

A1 is corrected to 1,5
Now A2 SHOULD become 0, and the loop should exit
A2 becomes -2,22E-16 (!!!)

I don't understand this!


Do you?
Help is very much appreciated

[royUK]

Using ControlSource means the cell reflects changes in the Userform textBox, and vice versa. Each change is probably triggering another change hence the loop

[exEExe]

Not sure I understand you, Roy..


My plan 'is' to reflect the changes.

I want the Text Input to change the value of A1.
But I also want the cell value to be written back to the Text Input.

How do you think I could do this another way?

[royUK]

As the TextBox changes, so the cell changes. This in turn will change the textbox, and so on