Keyboard shortcuts in VBA

**Yukio** · 04-10-2013, 04:22 AM

Hello everyone,

I would like to introduce a keyboard shortcut to a VBA function/macro, is that possible?

Example of what should happen:
I have a cell with a function name (COUNT) and I would like the function/macro to add the "=" in front of it and then recognize it as a function and automatically execute CTRL+SHIFT+A.

"COUNT" + "=" is =COUNT -> "=COUNT" + "CTRL+SHIFT+A" + "'" is '=COUNT(value1,value2,...)

Thanks in advance,
Rob

**AndyLitch** · 04-10-2013, 04:55 AM

Sub ConvertCalc()

    Range("A1").Value = "=" & Range("A1").Value
    ActiveSheet.Calculate
    
End Sub

**Yukio** · 04-10-2013, 06:14 AM

Awesome, but the CTRL+SHIFT+A part is sadly still missing.

Thanks in advance,
Rob

**AndyLitch** · 04-10-2013, 06:38 AM

Keyboard shortcuts tend to be a bit quirky... It's better to call directly whenever possible

**Yukio** · 04-10-2013, 07:14 AM

Quirky as in impossible or extremely difficult, but possible?
If it's the latter, do you or anyone else know how it could look like, I can test it on my own until I get what I want.

Thanks!

**AndyLitch** · 04-10-2013, 07:53 AM

SendKeys "^+{A}"
    DoEvents

**mnjofra** · 04-10-2013, 07:56 AM

HI,
you have to check format of this cell. If your format is "text", excel will not calculate nothing here. Change proper format to "general" or any kind of "numeric" and then call this macro.
Regards,