specific cell
- From: "chris" <chris@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 31 Aug 2005 03:45:06 -0700
Hi all
I am currently building an Excel *** 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
.
- Prev by Date: Re: Keeping The Focus From Changing. How?
- Next by Date: where on earth is the macro?
- Previous by thread: Re: Specific cell
- Next by thread: How active the tab's color menu ?
- Index(es):
