Unlocking Cells Based Upon Value of Another Cell

Graviz · May 4th, 2012, 11:17 AM

I have two columns (J and K - rows 4 through 133) on a sheet called "SMATV". In J a user will input a channel number and in column K it will state a channel name via a vlookup on another sheet. All this is done but here's the issue......channels 2-99 don't have a name to lookup. It will be a user inputted name. I wanted to lock down column J since it's a formula but I need the user to be able to input a name if the value in column J is less than 99. Is there a way using vba to unlock the cell and clear the formula so the user can input a name if J is less than 99?

Shasur · May 7th, 2012, 11:58 AM

Hi

Here is a hint

Code:

Dim oRng As Range
Set oRng = ActiveSheet.Range("J3")
If oRng.Value < 99 Then
    oRng.ClearContents
    oRng.Locked = True
End If

Cheers
Shasur