dictation macro

[GoodmanJim]

I would like to create a button to dictate to a cell. I know I can use window key + h key dictate, but for the non-excel users I have to use a button with a macro. Please Help Thank you

 

[Micron]

Don't know what you mean by 'non excel users'. You need a solution for when they're using something else, like Word or PowerPoint? Or you're saying they're not Excel savvy? If the former, I can't help. If the latter, I suggest you train them or at least put an instruction on a sheet, or use a message box to explain how to do it when they click that button you mention. I say this because while it is possible to programmatically press the Windows key, that only opens the Start menu. The only way to simulate the Windows key without opening the menu is to use an API as far as I know (and I've been down this road before). You can look for API code for this but I think you will decide it's not worth the hassle. Here's an example

Simulating Keyboard Keystroke Sequences

How to use the VBA keybd_event API to simulate/emulate keyboard keystrokes (similar to SendKeys) and a custom procedure to simplify this task event further.

www.devhut.net

 

[Logit]

Sorry what do you mean by :

dictate to a cell