Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Specific cell
Hello,
I am currently building an Excel sheet that need to show a message if a user changes the value of a specific cell. For example the message needs to appear if the value of the cell A1 is below ten, but I only want to show the message when the user changes the value. So if the user changes cell B1 and the value of A1 is below ten I dont want the message to appear. Can anybody help me out? Best regards, Chris |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Specific cell
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ws_exit: Application.EnableEvents = False If Target.Address = "$A$1" Then If Target.Value < 10 Then MsgBox "A1 changed" End If End If ws_exit: Application.EnableEvents = True End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH Bob Phillips "chris" wrote in message ... Hello, I am currently building an Excel sheet that need to show a message if a user changes the value of a specific cell. For example the message needs to appear if the value of the cell A1 is below ten, but I only want to show the message when the user changes the value. So if the user changes cell B1 and the value of A1 is below ten I don't want the message to appear. Can anybody help me out? Best regards, Chris |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Specific cell
Bob,
Thanks for you help it works. Best regards, Chris "Bob Phillips" wrote: Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ws_exit: Application.EnableEvents = False If Target.Address = "$A$1" Then If Target.Value < 10 Then MsgBox "A1 changed" End If End If ws_exit: Application.EnableEvents = True End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH Bob Phillips "chris" wrote in message ... Hello, I am currently building an Excel sheet that need to show a message if a user changes the value of a specific cell. For example the message needs to appear if the value of the cell A1 is below ten, but I only want to show the message when the user changes the value. So if the user changes cell B1 and the value of A1 is below ten I don't want the message to appear. Can anybody help me out? Best regards, Chris |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Specific cell
Here's another option that doesn't require coding.
From the Data Menu, select Validation. The resulting dialog box provides methods for establishing entered range values as well as a custom message box when the range has been exceeded. regards, mike |
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) |