Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Update in excel
I need to know how to have my validation macro run everytime i change
the contents of a cell. I've tried putting the macro name in the Worksheet_Change Source but it seems to be stuck in a loop. Any help? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Update in excel
Try This, just change the address between the quotes to suit your
needs. Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo DoNothing If Target.Address = "$A$1" Then MsgBox "This works" End If Exit Sub DoNothing: End Sub This will avoid running into a continuos loop |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Update in excel
before the end of your macro,
a1=11 or something €ç¼–写: I need to know how to have my validation macro run everytime i change the contents of a cell. I've tried putting the macro name in the Worksheet_Change Source but it seems to be stuck in a loop. Any help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-update in Excel 2007 | Excel Discussion (Misc queries) | |||
Auto Update in Excel | Excel Worksheet Functions | |||
how to update data on sheet1 and have it auto update on sheet2 | Excel Programming | |||
How to auto update Excel Web Page | Excel Programming | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions |