![]() |
|
#2
|
|||
|
|||
|
Something like this perhaps:
Code:
Sub ScratchMacro() 'A basic Word macro coded by Greg Maxey, http://gregmaxey.com/word_tips.html, 8/1/2017 Dim lngIndex As Long Dim strMacro As String lngIndex = 1 Do Select Case lngIndex Case 1: Macro_1 Case 2: Macro_2 Case 3: Macro_3 Case 4: Macro_4 'This is the last macro Exit Do End Select strMacro = InputBox("Macro " & lngIndex & " complete. Enter the next macro number or click ok", "Next Macro", "Ok") If strMacro = "Ok" Then lngIndex = lngIndex + 1 Else lngIndex = CLng(strMacro) End If Loop lbl_Exit: Exit Sub End Sub Sub Macro_1() 'Whatever End Sub Sub Macro_2() 'Whatever End Sub Sub Macro_3() 'Whatever End Sub Sub Macro_4() 'Whatever End Sub |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Macros to move objects prevents moving same objects with arrow keys
|
BruceM | Word VBA | 1 | 03-10-2015 08:20 AM |
| Consolidate Pivots linked to SQL | mtayloripf | Excel | 0 | 02-11-2014 08:16 AM |
How Find Out What Keys Trigger My Macros?
|
peytontodd | Word | 1 | 10-28-2013 09:39 AM |
Consolidate names
|
jgross30 | Excel | 7 | 05-13-2013 08:36 PM |
| Is it possible to bind macros to keys not in the KeyCodeConstants class? | AlexR | Word VBA | 4 | 04-08-2013 10:15 AM |