Click all vba code assign buttons

  • I have vba code assigned buttons in my workbook
    i have 4-5 buttons
    My button name is Step 1 , Step 2, Step 3 and so on
    What i want is click the button 1 by 1 means click step 1 button after the work is over run Step2 button if its over run step3 button and so on
    These button are on different different sheets but we can make the code bcoz its in series
    step 1, Step 2 , Step 3, Step 4 and so on

  • Do you mean that whichever button is clicked all Steps should be run?

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • I will make a seperate button for ur code and i will assign ur code and after click this button all buttons in my workbook will run step by step
    step by step means first it will run step 1 button after its completed its work then step2 will run after its completed the work then step 3 will run and so on upto step 5

  • Make a new button and assign this code to it

    Code
    Sub RunAllSteps()
        Call Step1
        Call Step2
        Call Step3
        Call Step4
        Call Step5
    End Sub


    Where Step1 is the Sub Name for the code assigned to Button for Step 1, Step2 is the Sub Name for the code assigned to Button for Step 2 and so on.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • There is no code in the sample file for Step1, Step2 or Step3 buttons.


    I have added code for each button that just shows a message, change that message for your actual code.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!