Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating an event of pressing 'enter' using VB
I would like to write a subroutine which should initiate after a value is
entered in a cell and enter is pressed. Can smbdy help me out? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating an event of pressing 'enter' using VB
Private Sub Worksheet_Change(ByVal Target As Range)
Const WS_RANGE As String = "H1:H10" '<=== change to suit On Error GoTo ws_exit: Application.EnableEvents = False If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then With Target 'do your stuff 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 (replace somewhere in email address with gmail if mailing direct) "Amit" wrote in message ... I would like to write a subroutine which should initiate after a value is entered in a cell and enter is pressed. Can smbdy help me out? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
creating an event of pressing 'enter' using VB
Thank You BOB. It solved my problem!
"Bob Phillips" wrote: Private Sub Worksheet_Change(ByVal Target As Range) Const WS_RANGE As String = "H1:H10" '<=== change to suit On Error GoTo ws_exit: Application.EnableEvents = False If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then With Target 'do your stuff 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 (replace somewhere in email address with gmail if mailing direct) "Amit" wrote in message ... I would like to write a subroutine which should initiate after a value is entered in a cell and enter is pressed. Can smbdy help me out? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change direction when pressing enter | Excel Discussion (Misc queries) | |||
WYA Converts to WAY after pressing enter ket | Excel Discussion (Misc queries) | |||
Pressing Enter Key | Setting up and Configuration of Excel | |||
select the first cell in the next row down after pressing enter o. | Setting up and Configuration of Excel | |||
How can a hyperlink be opened by pressing Enter. | Excel Discussion (Misc queries) |