| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell change
I have the following code:
Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo stoppit Application.EnableEvents = False With Me.Range("drw1inforng") If .Value < "" Then MsgBox ("") End If End With stoppit: Application.EnableEvents = True End Sub 'drw1inforng' is a named range on my sheet. When I make a change in this range, nothing happens. What am I doing wrong here? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to trigger one cell change to change another cell using VB in excel? Please help! :) | Excel Programming | |||
| making copied cells change with change in original cell | Excel Worksheet Functions | |||
| Cell value change to trigger macro (worksheet change event?) | Excel Programming | |||
| Change workbook sheet reference using cell A1 to change a vairable | Excel Worksheet Functions | |||
| Change Cell from Validated List Not Firing Worksheet Change Event | Excel Programming | |||
Threaded Mode
