| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Not allowing to continu unless a specific cell has specific answer | Excel Discussion (Misc queries) | |||
| Link to specific cell in specific Excel file | Excel Discussion (Misc queries) | |||
| Link from a specific Cell in Excel to a specific para. in Word | Excel Worksheet Functions | |||
| Highlight a row if a specific cell is specific numbers/words | Excel Worksheet Functions | |||
| How do I make a cell date specific to input a value on a specific. | Excel Discussion (Misc queries) | |||
Linear Mode
