Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically select entire rows on pressing down and up-arrow key
Dear Experts:
The following code snippets selects the entire row of the currently selected cell Rows(ActiveCell.Row).Select Is it possible to link this entire row selection command to the up and down arrows of the keyboard? For example: The currently selected cell is B5. Pressing the down-arrow-key brings me to B6. The entire sixth row is to be selected automatically without manually activating the selection macro. Is this feasible? Help is much appreciated. Thank you very much in advance. Regards, Andreas |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically select entire rows on pressing down and up-arrow key
Here is sheet event code which will select the entire row of any cell you arrow
to or mouse-click. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Rows(ActiveCell.Row).Select End Sub But, I don't think it is what you want. Do you also want to be able to select single cells or ranges which are not an entire row? How specific do you need your selection(s) to be? Gord Dibben MS Excel MVP On Tue, 9 Nov 2010 13:50:18 -0800 (PST), andreashermle wrote: Dear Experts: The following code snippets selects the entire row of the currently selected cell Rows(ActiveCell.Row).Select Is it possible to link this entire row selection command to the up and down arrows of the keyboard? For example: The currently selected cell is B5. Pressing the down-arrow-key brings me to B6. The entire sixth row is to be selected automatically without manually activating the selection macro. Is this feasible? Help is much appreciated. Thank you very much in advance. Regards, Andreas |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically select entire rows on pressing down and up-arrow key
On 9 Nov., 23:19, Gord Dibben wrote:
Here is sheet event code which will select the entire row of any cell you arrow to or mouse-click. Private Sub Worksheet_SelectionChange(ByVal Target As Range) * * Rows(ActiveCell.Row).Select End Sub But, I don't think it is what you want. Do you also want to be able to select single cells or ranges which are not an entire row? How specific do you need your selection(s) to be? Gord Dibben * * MS Excel MVP On Tue, 9 Nov 2010 13:50:18 -0800 (PST), andreashermle wrote: Dear Experts: The following code snippets selects the entire row of the currently selected cell Rows(ActiveCell.Row).Select Is it possible to link this entire row selection command to the up and down arrows of the keyboard? For example: The currently selected cell is B5. Pressing the down-arrow-key brings me to B6. The entire sixth row is to be selected automatically without manually activating the selection macro. Is this feasible? Help is much appreciated. Thank you very much in advance. Regards, Andreas Dear Gord, thank you very much for your professional support. This is exactly what I wanted. This is great support. Regards, Andreas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How move arrow keys from cell to cell and NOT entire col/rows | New Users to Excel | |||
in excel, pressing shift+ctrl+arrow no longer works? any idea why | Excel Worksheet Functions | |||
select entire rows using a contains comparison - an example | Excel Programming | |||
How to do the following by pressing the down arrow or up arrow key? | Excel Discussion (Misc queries) | |||
How to do the following by pressing the down arrow or up arrow key? | Excel Programming |