Disable/enable spin button, hide and unhide button based on a cell value

**Rocky2013** · 05-12-2022, 02:07 PM

Hi,
I make two examples for help.

1. Disable and enable form control spinner button based on a cell value to lock
spin button and it's link cell.

2. Hide and unhide form control spinner button based on a cell value.

I would like the change is real time without hitting a return key.

Thank you

**Arkadi** · 05-12-2022, 02:26 PM

Try this:

Please Login or Register  to view this content.

You can't just "lock E16". You could lock the cell and protect the sheet, but it would need just as much code. However, by undoing the change it is basically the same as locking it if B16 = 2

**Rocky2013** · 05-12-2022, 07:30 PM

Hello,
It works, but I have to press a return key. the value in B16, is not a hand type number but rather come from the result of another cell. This code is good. I am creating another example similar to this, should I create a new thread or upload the file?

Thanks

**Arkadi** · 05-13-2022, 07:58 AM

Hi Rocky2013,

Yes you do have to press a return key, because until you do, the cell hasn't changed. Also, if the change is the result of a formula, it won't trigger the macro, but... you COULD make a change event for the source cell instead. Since it is a continuation of the same issue/question, there is no need to start a new thread for this, just go ahead and upload a file.