Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Event handling...
Excel Helper
I have a list of names in column A. What i want is program whereby if I enter a new name at the bottom of the column, if it is a duplicate (i.e. name appears elsehwere in list) then a msgbox appears telling em it is a duplicate. Now I can actauly ahcieve this in VBA but... I have to actaully execute the macro maually. How can i get the macro to run automatically i.e. I enter a new name, press enter, and the macro runs without me clicking a separate button to run it of pressing F5 etc. I have tried... Application.Volatile Application. OnKey Application. Onaction How do I get Excel to run a macro once an event has occurred. Any insights appreciated... Alex |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Event handling...
Use the WorkSheet Change Event
see Chip Pearson's page on Events http://www.cpearson.com/excel/events.htm -- Regards, Tom Ogilvy "Alex" wrote in message ... Excel Helper I have a list of names in column A. What i want is program whereby if I enter a new name at the bottom of the column, if it is a duplicate (i.e. name appears elsehwere in list) then a msgbox appears telling em it is a duplicate. Now I can actauly ahcieve this in VBA but... I have to actaully execute the macro maually. How can i get the macro to run automatically i.e. I enter a new name, press enter, and the macro runs without me clicking a separate button to run it of pressing F5 etc. I have tried... Application.Volatile Application. OnKey Application. Onaction How do I get Excel to run a macro once an event has occurred. Any insights appreciated... Alex |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
checkbox event handling function | Excel Worksheet Functions | |||
Handling of event raised in other class module | Excel Programming | |||
excel object event handling | Excel Programming | |||
user form-on open event? keydown event? | Excel Programming | |||
OnTime event not firing in Workbook_Open event procedure | Excel Programming |