Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 08-04-2017, 05:52 AM
StephenRay StephenRay is offline Consolidate 25 Macros Into One, Too Many Hot Keys! Windows 7 64bit Consolidate 25 Macros Into One, Too Many Hot Keys! Office 2010 64bit
Advanced Beginner
Consolidate 25 Macros Into One, Too Many Hot Keys!
 
Join Date: Jan 2012
Location: Overland Park, Kansas
Posts: 53
StephenRay is on a distinguished road
Default

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.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Consolidate 25 Macros Into One, Too Many Hot Keys! 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
Consolidate 25 Macros Into One, Too Many Hot Keys! How Find Out What Keys Trigger My Macros? peytontodd Word 1 10-28-2013 09:39 AM
Consolidate 25 Macros Into One, Too Many Hot Keys! 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:22 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft