Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Event handler in a cell
How do I define some event in a cell ?
Like, after I entered a string in a cell and press ENTER, something need to be done like calculation, or fetch data from a file. Is it a macro ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Event handler in a cell
It is a procedure tied to the event. The example below shows the value you
have just entered, as an example Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ws_exit: Application.EnableEvents = False If Not Intersect(Target, Me.Range("A1:H10")) Is Nothing Then With Target Msgbox .Value End With End If ws_exit: Application.EnableEvents = True End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH Bob Phillips "Man Utd" wrote in message ... How do I define some event in a cell ? Like, after I entered a string in a cell and press ENTER, something need to be done like calculation, or fetch data from a file. Is it a macro ? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Event handler in a cell
I have 3 worksheet, how do I know which worksheet's cell is changed ?
"Bob Phillips" wrote in message ... It is a procedure tied to the event. The example below shows the value you have just entered, as an example Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ws_exit: Application.EnableEvents = False If Not Intersect(Target, Me.Range("A1:H10")) Is Nothing Then With Target Msgbox .Value End With End If ws_exit: Application.EnableEvents = True End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH Bob Phillips "Man Utd" wrote in message ... How do I define some event in a cell ? Like, after I entered a string in a cell and press ENTER, something need to be done like calculation, or fetch data from a file. Is it a macro ? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Event handler in a cell
By the way, can you tell me how to determine the position of the cell which
triggers this event please ? As I don't understand your code. "Man Utd" wrote in message ... I have 3 worksheet, how do I know which worksheet's cell is changed ? "Bob Phillips" wrote in message ... It is a procedure tied to the event. The example below shows the value you have just entered, as an example Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ws_exit: Application.EnableEvents = False If Not Intersect(Target, Me.Range("A1:H10")) Is Nothing Then With Target Msgbox .Value End With End If ws_exit: Application.EnableEvents = True End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH Bob Phillips "Man Utd" wrote in message ... How do I define some event in a cell ? Like, after I entered a string in a cell and press ENTER, something need to be done like calculation, or fetch data from a file. Is it a macro ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Global event handler?? | Excel Programming | |||
where is the workbook_open event handler??? | Excel Programming | |||
different IDispatch in event handler | Excel Programming | |||
Cell Event Handler | Excel Programming | |||
Re : Excel event handler Worksheet_SelectionChange | Excel Programming |