![]() |
|
#7
|
|||
|
|||
|
gmaxey, There's not that much difference between ctrl and shift. I can take that. Thanks.
I did not notice this in my reading in my book. I will go home and look for Shift in connection with InputBox. As for your logic where you subtract 64, I think I get it. In the ASCII table, there are 64 other symbols before the alphabet in the table. So I have to align my macro number with this in mind. Last evening I had given up trying to find HotKeys and Shortcut Keys in connection with an Input Box & Dialog Box Response. So I was reading about Dialog Boxes in my book, searching, searching for a way. And I found something. KEYPRESS. Ctrl can be used with KEYPRESS but only when using a User Form Object, my book says. Of course, this is way over my head right now. But I will work up to it. Fancy Dialog Boxes and User Form look very easy compared to trying to figure out VBA Syntax. |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Macros to move objects prevents moving same objects with arrow keys
|
BruceM | Word VBA | 1 | 03-10-2015 08:20 AM |
| Consolidate Pivots linked to SQL | mtayloripf | Excel | 0 | 02-11-2014 08:16 AM |
How Find Out What Keys Trigger My Macros?
|
peytontodd | Word | 1 | 10-28-2013 09:39 AM |
Consolidate names
|
jgross30 | Excel | 7 | 05-13-2013 08:36 PM |
| Is it possible to bind macros to keys not in the KeyCodeConstants class? | AlexR | Word VBA | 4 | 04-08-2013 10:15 AM |