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

In VB Editor, double-click on the sheet you want so that you can view its code window.

Change selection in box on upper left of code window from (General) to Worksheet.

In the box at upper right of code window choose Selection Change.

In the subroutine, call your macro.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Call myMacro
End Sub

Use the WorkSheet Change Event

see Chip Pearson's page on Events

http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy

"Alex" <[email protected]> wrote in message
news:[email protected]...
> 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