Change value of a cell by forming a button

[mshahbaz]

Hi,

[TABLE="width: 500"]
<tbody>[TR]
[TD]Material 01[/TD]
[TD]Step 1[/TD]
[TD]NEXT Button[/TD]
[TD]Other[/TD]
[TD]Other[/TD]
[/TR]
[TR]
[TD]Material 02[/TD]
[TD]Step 3[/TD]
[TD]NEXT Button[/TD]
[TD]Other[/TD]
[TD]Other[/TD]
[/TR]
[TR]
[TD]Material 03[/TD]
[TD]Step 7[/TD]
[TD]NEST Button[/TD]
[TD]Other[/TD]
[TD]Other[/TD]
[/TR]
</tbody>[/TABLE]

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.