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 |
All times are GMT +1. The time now is 06:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com