Keyboard shortcut Alternative?

  • Thread starter Thread starter FuzzyDove
  • Start date Start date
F

FuzzyDove

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!
 
Also, are there any other shortcut keys that you can assign to macros
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.
 
Back
Top