Submitted by WayneK on 2016/07/20 17:18
This is minor issue that has taken on some importance because it happens so much.  I use both Excel and InfoQube grid to create lists within cells.  In both cases, you have to enter a keyboard shortcut to start a new line.
 
The problem is: in Excel, the shortcut is Alt-return;  in InfoQube it's Shift-return.  It's an annoyance because I can never remember which is which.  At the least I have to pause and think about it and it's gotten to the point that I have a mental block.
 
I'd like to change either keyboard shortcut to match the other but can't figure out how.  Neither shortcut is listed under InfoQube shortcuts.  In Excel 2007 it looks like you have to download additional software and learn how to use it to change shortcuts.
 
Any ideas on how I can resolve what should be a simple problem?
 
Wayne

Comments

Hi Wayne,
 
I don't know how familiar you are with AutoHotKey but it's definitely useful in situations like this.
 
I've written a short script that after Alt+Enter press (the Excel way) evaluates if the active window is InfoQube ("ahk_class ThunderRT6MDTForm") and then presses Shift+Enter instead (the InfoQube way). The "else" clause is supposed to handle all other cases where we just want Alt+Enter (what we have pressed in the first place). I am not 100% sure this is the way of proper AHK scripting, but seems to be working fine here.
 
The Code:
:
 
;----------------------Shortcut for InfoQube Alt+Enter becoming Shift+Enter
!ENTER::

if WinActive("ahk_class ThunderRT6MDIForm")
{
Send {Shift down}{Enter}{Shift up}
}

else
{
Send {Alt down}{Enter}{Alt up}
}

return
;----------------------Shortcut for InfoQube Alt+Enter becoming Shift+Enter
 
ethanrox

WayneK

2016/07/20 19:25

In reply to by ethanrox

Thank you, ethanrox.  I have Autohotkey but never made the commitment to learning how to use it.  Maybe it's time.
 
Wayne
 

ethanrox

2016/07/20 19:39

In reply to by WayneK

Same here. So thanks for the "exercise" :)