Change value of a cell by forming a button

[mshahbaz]

Hi,

Material 01	Step 1	NEXT Button	Other	Other
Material 02	Step 3	NEXT Button	Other	Other
Material 03	Step 7	NEST Button	Other	Other

<tbody>
</tbody>

In column 2, there is always the status of ongoing material in production.

My question is, if there is a NEXT button in column 3, and when i press it
the step 1 should automatically changes to step 2 and so on.

Shahbaz

 

[mshahbaz]

OK

Is there any other way which can avoid inadvertent deletion?

There is no way I know of without Vba.

 

[My Aswer Is This]

When you say deletion I believe you mean clearing content.
So if you have "George" in Range("B1") and you want to make sure no one clears the values "George"

Then we use Vba that will give a warning, Or without Vba you can use cell protection.
Click the cell you want to protect. On the ribbon choose "Review" then choose "protect"

And look at the options.