specific cell
Hi all
I am currently building an Excel sheet by using VBA. I want to add some
messages when a user has not entered some values. Those messages must only
appear when a user changes a value of a specific cell. To make that happen I
use the code below. This code works fine when a user enters a value to the
specific cell, but when a user uses the Goalseek function to change the value
the message will not appear.
Can anybody please help me out.
Best regards,
Chris
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$N$5" Then
|