lock cell1 if cell1 = cell2

[Ky1eb88]

To be more exact I have a formula set to auto populate cell A2 with data that is entered in cell B1, and cell A3 with cell B2 ect...


I want the cell in column A to lock any time its value is equal to the value in column b on the previous row.


I'm new to VBA and cant work my head around on how to get this to going. I was able to get it to work with single cells, but even replicate that anymore.


Thanks,
Kyle

 

[Ky1eb88]

By the way I'm using MS Excel 2010 and this is for a data entry form.

 

[JoeMo]

To be more exact I have a formula set to auto populate cell A2 with data that is entered in cell B1, and cell A3 with cell B2 ect...


I want the cell in column A to lock any time its value is equal to the value in column b on the previous row.


I'm new to VBA and cant work my head around on how to get this to going. I was able to get it to work with single cells, but even replicate that anymore.


Thanks,
Kyle

By "lock" do you mean the Excel protection lock or do you mean replace the formula with its immediate value so that future changes to the value owing to a change in data in the B cell that the formula references have no effect??

 

[Ky1eb88]

By "lock" do you mean the Excel protection lock or do you mean replace the formula with its immediate value so that future changes to the value owing to a change in data in the B cell that the formula references have no effect??

I mean cell protection. Cell.lock = true

 

[JoeMo]

I mean cell protection. Cell.lock = true

All cells are locked by default unless you specifically unlock them and locking provides no protection unless the worksheet the cells occupy is protected. Is the sheet you want to do this for protected?

 

[Ky1eb88]

All cells are locked by default unless you specifically unlock them and locking provides no protection unless the worksheet the cells occupy is protected. Is the sheet you want to do this for protected?

The sheet is protected I just don't want the cell to be editable when the2 cells equal each other. Sorry I guess I thought that's what.lock did

 

[JoeMo]

The sheet is protected I just don't want the cell to be editable when the2 cells equal each other. Sorry I guess I thought that's what.lock did

Unless you unlocked the cell, if the sheet is protected the cell(s) will not be editable by any user who doesn't know and can't guess the password.

 

[Ky1eb88]

Thing is I want the cell editable unless the above is true

 

[JoeMo]

Thing is I want the cell editable unless the above is true

That's different. Do you also want the B cells editable by all users when the sheet is protected?

 

[Ky1eb88]

That's different. Do you also want the B cells editable by all users when the sheet is protected?

No B would be editable