Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keyboard shortcut Alternative?
Hi All, I have a sheet that has a set of data for each row. There are a large number of rows of data. We keep this data sorted alphabetically by the data in cells of the A column. I've written 26 nearly identical macros that allow users to hit Shft+Ctrl+"Letter" and it will take them to the first row that starts with that "Letter". Since the users do this a lot, it is very efficient to have only a single keystroke combo (ctrl+shft+letter). The problem is, I hate using up all of the Ctrl+Shft shortcuts available. Can anyone think of a way, with a single keystroke combination, to accomplish the same thing, preferably without having 26 separate macros and without using up all of the Ctrl+Shft shortcuts? Also, are there any other shortcut keys that you can assign to macros besides just "Ctrl+" or ""Ctrl+Shft+". Thanks heaps for any help! -- FuzzyDove ------------------------------------------------------------------------ FuzzyDove's Profile: http://www.excelforum.com/member.php...o&userid=16676 View this thread: http://www.excelforum.com/showthread...hreadid=320629 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keyboard shortcut Alternative?
Also, are there any other shortcut keys that you can assign to macros
besides just "Ctrl+" or ""Ctrl+Shft+". There is nothing magical about those two. Using the Application.Onkey method you can assign a macro to any keystroke. Doing things a bit differently than you, I think I'd assign an otherwise unused keystroke like F3 to a macro that in turn use InputBox to get a single letter from the user, that the macro could search on. -- Jim Rech Excel MVP "FuzzyDove" wrote in message ... Hi All, I have a sheet that has a set of data for each row. There are a large number of rows of data. We keep this data sorted alphabetically by the data in cells of the A column. I've written 26 nearly identical macros that allow users to hit Shft+Ctrl+"Letter" and it will take them to the first row that starts with that "Letter". Since the users do this a lot, it is very efficient to have only a single keystroke combo (ctrl+shft+letter). The problem is, I hate using up all of the Ctrl+Shft shortcuts available. Can anyone think of a way, with a single keystroke combination, to accomplish the same thing, preferably without having 26 separate macros and without using up all of the Ctrl+Shft shortcuts? Also, are there any other shortcut keys that you can assign to macros besides just "Ctrl+" or ""Ctrl+Shft+". Thanks heaps for any help! -- FuzzyDove ------------------------------------------------------------------------ FuzzyDove's Profile: http://www.excelforum.com/member.php...o&userid=16676 View this thread: http://www.excelforum.com/showthread...hreadid=320629 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keyboard Shortcut | Excel Discussion (Misc queries) | |||
Is there an alternative to F11 in excel for an apple keyboard? | Excel Worksheet Functions | |||
Keyboard Shortcut | New Users to Excel | |||
Quickest alternative for shortcut of PasteSpecial then Values | Excel Worksheet Functions | |||
keyboard shortcut | Excel Worksheet Functions |