Thread: specific cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Chris is offline
external usenet poster
 
Posts: 788
Default 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