Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine when Enter Key is pressed in a sheet??
I want to determine when Enter key is pressed in a sheet that is
active?? I would like then to run a macro when the Enter key is pressed ?? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine when Enter Key is pressed in a sheet??
The Enter Key is not a capturable event.
Worksheet change is This added to the individual worksheet in VBA will trigger when ever the sheet is changed. Private Sub Worksheet_Change(ByVal Target as Range) 'Do Stuff End Sub If you are going to make changes to the sheet using this event is is usually a good idea to turn off events at the start and then turn them back on at the end. Otherwise the changes trigger this macro again. Private Sub Worksheet_Change(ByVal Target as Range) Application.EnableEvents=False 'Do Stuff Application.EnableEvents=True End Sub -- If this helps, please remember to click yes. "Subodh" wrote: I want to determine when Enter key is pressed in a sheet that is active?? I would like then to run a macro when the Enter key is pressed ?? . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine when Enter Key is pressed in a sheet??
It is possible with application.onkey. Example is with HOME-Key, for
other keys check VBA help inside Excel or look for it on the web: Sub StartOnKey() 'Run this sub to make the HOME-key run the "SubHello" procedure Application.OnKey "{HOME}", "SubHello" End Sub Sub SubHello() 'Pressing HOME will run this procedure MsgBox "hallo" End Sub Sub StopOnKey() 'Run this sub to return HOME-Key to its normal meaning. Application.OnKey "{HOME}" End Sub You can use Workbook_Open() and run application.onkey to bind a procedure to a key as soon as the workbook is opened. Hubisan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting up an Excel sheet to automatically determine when an employeeshould enter a retirement plan, perhaps What-If Analysis would help? Anyother suggestions? | Links and Linking in Excel | |||
Select sheet, Pause till Enter pressed, return to previous sheet | Excel Programming | |||
How do I determine what key was pressed | Excel Programming | |||
how do I ensure enter is pressed | Excel Programming | |||
Enter pressed in Textbox | Excel Programming |