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

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