How to do a few numerical mutexes, cell below

CodePudding user response:

Should the VB programming

CodePudding user response:

Private Sub Worksheet_Change (ByVal Target As Range)
'judge by the address change is one of the four cells, and then branch
'four cells, respectively, to write clear the other three cells program
End Sub

CodePudding user response:

reference 1st floor wxf54318 response:

it should use the VB programming implementation

Using VB to me know whether can realize, excel's built-in functions

CodePudding user response:

reference zhui__ reply: 3/f

Private Sub Worksheet_Change (ByVal Target As Range)
'judge by the address change is one of the four cells, and then branch
'four cells, respectively, to write clear the other three cells program
End Sub

Using VB to me know whether can realize, excel's built-in functions

CodePudding user response:

Function, formula, not probably, enter the numerical formula is destroyed

CodePudding user response:

Formula can't do that, your request is random change, several cell formula will be destroyed, after the change to automatic recovery in use VBA, and direct writing process is similar in the VBA