Cell value change and another cell value will be changed too

[iqballud]

Hi Guys,

How to create the code which if the cell value (B11) changed then the cell value on the B14, B15,.., will be changed too?
Let's say the first change B11, then will be recorded to B14, and the second change B11, then will be recorded to B15, and so on.

This is the code under UserForm (UF1)...this code is not mentioned how to change on the cell B14, B15,...and I use the spinbutton to change the value

Please Login or Register  to view this content.

Thanks in advance for any helps.

Kind Regards,
Iqbal

[:) Sixthsense :)]

Copy the below code and do right click on sheet tab and select view code and paste it.

Close the VBA window (Alt+Q to close VBA window) and return to that sheet and check.

Please Login or Register  to view this content.

[iqballud]

I have been tried your code, but unfortunately the column being updated after the userform is closed.
That was not updated directly when the value have been changing.
Thank you so much for the quick reply.

[:) Sixthsense :)]

Change the Userform ShowModal property to False

[iqballud]

Hi Guru,

Work great..thanks a lot...you are the man.
May i ask another question, if i hold the "SpinButton" for sometimes and the value have been changed starting from 0 to 5.
What is the code to display only the last value changed(5) ? The value in between 1, 2, 3, and 4 will be not recorded, only the last number.
And this value will be display on the cell B14,...and so on for another changed, only the last value will be displayed on the next cells (B15, B16,...)
Again thank you so much for your helps.
I will add reputation to you, Guru.

Kind Regards,
Iqbal

[:) Sixthsense :)]

Check the attached file for solution

[iqballud]

Guru, Is it possible without clicking of commandbutton1 (Click to Update in Sheet), then the cell will be updated by itself?