How can I find out what keystrokes will click buttons?

wardw · #1 05-09-2024, 11:23 AM

Thanks, Charles and Andrew. I've encountered a more fundamental problem, it seems. I tried to create a macro I called Test1 to simply open the Styles dialog. While the macro was recording, I opened Home, then clicked the arrow in Styles to open the dialog. Then I stopped recording. The macro that appeared in VBA looks like this:

Sub Test1()

'
'Test1 Macro
'
'
End Sub

So no commands were recorded. When I closed the Styles dialog, then tried to run the macro, nothing happened.

I suspect there's a problem with dialogs and VBA. Any ideas on why this didn't record?

Stefan Blom · #2 05-09-2024, 12:08 PM

To display the Styles pane with VBA, you can use the following line of code:

Code:

Application.TaskPanes(wdTaskPaneFormatting).Visible = True

Charles Kenyon · #3 05-10-2024, 02:30 PM

Quote:

Originally Posted by wardw

***
I tried to create a macro I called Test1 to simply open the Styles dialog. While the macro was recording, I opened Home, then clicked the arrow in Styles to open the dialog. Then I stopped recording. The macro that appeared in VBA looks like this:

Sub Test1()
'
'Test1 Macro
'
'
End Sub

So no commands were recorded. When I closed the Styles dialog, then tried to run the macro, nothing happened.

I suspect there's a problem with dialogs and VBA. Any ideas on why this didn't record?

This is how it works (or does not work). There are a number of things that the recorder will not pick up. Even those it does pick up often create poor coding.

See How to Modify a Recorded Macro by Jay Freedman.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do animate so: click on an image, then a larger image appears, then click again & text overlaid?	ship69	PowerPoint	1	09-30-2019 04:38 PM
Find drop down list entry with keystrokes	Empy	Excel Programming	3	06-09-2018 06:10 AM
Hyperlink object - change ctrl+click to click?	ld2x07	Word	5	10-10-2014 05:13 AM
Getting rid of para keystrokes at the end of every line	baudinot	Word	1	01-05-2012 03:37 PM
Slow (delayed) keystrokes	Jim Ogren	Word	0	07-23-2009 07:47 PM