View Single Post
 
Old 08-04-2017, 05:52 AM
StephenRay StephenRay is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
 
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