Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I wrote code intended to evaluate and reassign the value of a named
range based on an "on change" worksheet event. The code changes the named range value when run as a separate routine in a module, but doesn't run from the worksheet trigger. Can anyone correct this code, or tell me what I've done wrong? Thanks. Code follows: Private Sub Worksheet_Change(ByVal Target As Range) Dim Response As String If Evaluate(Names("DatesUpdated").Value) = False Then Application.Undo Response = MsgBox("Have you updated the dates?", vbYesNo) If Response = vbYes Then Names("DatesUpdated").Value = True End If End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can't chart dynamic named range?? | Charts and Charting in Excel | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
Need formula to lookup a named range | Excel Discussion (Misc queries) | |||
Macro for changing text to Proper Case | Excel Worksheet Functions | |||
Make Change Case in Excel a format rather than formula | Excel Worksheet Functions |