Modify VBA COde

[peanutme]

[URL unfurl="true"]https://res.cloudinary.com/engineering-com/raw/upload/v1646207268/tips/My_Doubt-VBA_kehgme.txt[/url]

Hi All,

Please find the attached link.

Helpful if some one could answer my Query.

Thanks in advance

 

[SkipVought]

Hi, and welcome to Eng-Tips

It customary to post your question directly in your original post and when appropriate, upload supporting documents like a workbook in this instance.

I have questions.

Following code is applied in Sheet2.

Private Sub Worksheet_Change(ByVal Target As Range)
  If Intersect(Target, Columns("B")) Is Nothing Then Exit Sub
  [s]Set Target = Target.Cells(1)[/s]
  Application.EnableEvents = False
  If Target = "" Then
    Target.Offset(, 5) = ""
  End If
  Application.EnableEvents = True
End Sub

The strike through statement is needless and confusing.

Now as per the code in Sheet 1 : If I revert the entry from Alphabet to Number…

Huh? You never post code for Sheet1, but you refer to that code as if you had. Are we to assume that it is identical code to Sheet2? Such assuming is not a very good idea. But it cannot be the same code because of, "revert the entry from Alphabet to Number" which bears no resemblance to the code you posted.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}