Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-01-2017, 10:47 AM
gmaxey gmaxey is offline Consolidate 25 Macros Into One, Too Many Hot Keys! Windows 7 32bit Consolidate 25 Macros Into One, Too Many Hot Keys! Office 2016
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,636
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default


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
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Consolidate 25 Macros Into One, Too Many Hot Keys! 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
Consolidate 25 Macros Into One, Too Many Hot Keys! How Find Out What Keys Trigger My Macros? peytontodd Word 1 10-28-2013 09:39 AM
Consolidate 25 Macros Into One, Too Many Hot Keys! 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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:37 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft