Helluva question...

  • Thread starter brownti via OfficeKB.com
  • Start date
B

brownti via OfficeKB.com

So here is my question. No idea if its possible, but is there a way to
create a macro that can be turned on and off that when it is on it can make a
certain key (lets say the Q key) actually work like the equals key? I am
going back and forth between the tab key and equals key a whole lot and would
be easier if i could just leave my hand in one place. I hope it can be done..
 
B

brownti via OfficeKB.com

I like the idea, but doesnt work...just wishful thinking i guess


T. Valko said:
Maybe you could *temporarily* set AutoCorrect to replace q with =.

Biff
So here is my question. No idea if its possible, but is there a way to
create a macro that can be turned on and off that when it is on it can
Click to expand...
[quoted text clipped - 4 lines]
be easier if i could just leave my hand in one place. I hope it can be
done..
Click to expand...
Click to expand...
 
J

John Bundy

I recorded a macro quick and set it to come on with ctrl-q, it then sets auto
correct to change q to =, then another with ctrl-w to change it back, it
looks like this

Sub Macro1()
'
'
' Keyboard Shortcut: Ctrl+q
'
Application.AutoCorrect.AddReplacement What:="q", Replacement:="="
With Application.AutoCorrect
.TwoInitialCapitals = True
.CorrectSentenceCap = True
.CapitalizeNamesOfDays = True
.CorrectCapsLock = True
.ReplaceText = True
.DisplayAutoCorrectOptions = True
End With

End Sub
Sub Macro2()

'
' Keyboard Shortcut: Ctrl+w
'
Application.AutoCorrect.DeleteReplacement What:="q"
With Application.AutoCorrect
.TwoInitialCapitals = True
.CorrectSentenceCap = True
.CapitalizeNamesOfDays = True
.CorrectCapsLock = True
.ReplaceText = True
.DisplayAutoCorrectOptions = True
End With
End Sub
 
Top