Restrict the edit option for a blank column

**arindamsenaxa** · 06-23-2021, 12:01 AM

Hi All
Just wanted to know how I can restrict the edit option for a blank column once I entered something.

As an example in the attached excel
1) Under request ID if I put numeric data then I should not have access to edit the same field for the 2nd time
2) Once I update something in the "Request" column the "Date" and "Time" column should get the update automatically and capture the entry date and time
If anyone suggests me some code it will be very helpful.

help.xlsx

Regards
Arindam

**FDibbins** · 06-23-2021, 12:06 AM

This is not possible with formulas, it will require VBA

**kvsrinivasamurthy** · 06-23-2021, 12:53 AM

Here is the worksheet event code

Please Login or Register  to view this content.

Worksheet event

To paste the code
Right click on Sheet tab --> view code
Visual Basic (VB) window opens.
Paste the code
Close the VB window.
Save the file