VB

[sullyman4]

Slow day today so I was looking at old "you know your and excel guru..................

and I came across this.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target = 7 Then Target = 4
End Sub


What is it and how do i use it??

 

[Lewiy]

It is a VBA event code. When a 7 is entered into a cell, it will automatically change it to a 4.
To use it, right click on the worksheet tab and select "View Code". Paste the code into the screen which pops up.

 

[Greg Truby]

What is it and how do i use it??

That'd be mischief code. We've got a whole thread on the subject. Been floatin' around here for bit under five years.