How to run multiple VBA codes

Question

I am fairly new to using VBA in Excel but I was wondering is there a way to run multiple codes at the same time?

My goal is to do a few things, First I need to insert a column, then add a column header, then add a formula to the cell beneath and copy the formula for all rows.

so far I have this code to run to input the row and then the header, but it won't work unless i run them each separately. is there a text I need to input to combine them so when I run it it just runs the whole thing at once? Thank you!

Sub AddColumns()

Worksheets(1).Range("AH1").EntireColumn.Insert

End Sub

Sub AddHeader()

    Worksheets(1).Range("AH1").Formula = "Group A"

End Sub

Perhaps I'm misunderstanding, but you have shown two Subroutines. Couldn't you just call those subroutines from the main program? VBA might not have the notion of a main, but there is Call for chaining Subs. Maybe this is what you want. — user1531971
– user1531971, Commented Nov 16, 2018 at 20:18
Jumana, If i understand your question, you need to know how to combine each action under one sub. Well, that is the purpose of VBA. I would suggest that you complete a basic vba course on line, there are many and basic vba training is usually free; One course is here. You can also do Google searches for online excel vba courses and also search Google for what you are trying to accomplish and research how other people accomplish similar task. You can then try to combine your task and when/if you have a problem, ask a specific question on SO. — GMalc
– GMalc, Commented Nov 16, 2018 at 22:40
Additionally, In answer to your title; No, VBA is single-threaded (one task must complete before another can run); you can't have two macros running at the same time. The workaround is you will have to use DoEvents to allow another macro to run. VBA DoEvents yields execution of your macro, so your computer processor will be able to simultaneously run other tasks and events. — GMalc
– GMalc, Commented Nov 16, 2018 at 23:29

K.Dᴀᴠɪs · Accepted Answer · 2018-11-16 21:40:58Z

4

Another method is to simply call them both from another routine.

Sub Main()

    AddColumns
    AddHeader

End Sub

Sub AddColumns()

    Worksheets(1).Range("AH1").EntireColumn.Insert

End Sub

Sub AddHeader()

    Worksheets(1).Range("AH1").Formula = "Group A"

End Sub

edited Nov 16, 2018 at 21:40

answered Nov 16, 2018 at 20:39

K.Dᴀᴠɪs

10.1k13 gold badges36 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

cybernetic.nomad · Accepted Answer · 2018-11-16 20:16:58Z

3

What you are asking for (run multiple macros at the same time) is called multi-threading, but it's not what you want.

Try putting all your lines in one sub:

Sub AddColumnsAndHeaders()

Worksheets(1).Range("AH1").EntireColumn.Insert
Worksheets(1).Range("AH1").Formula = "Group A"

End Sub

answered Nov 16, 2018 at 20:16

cybernetic.nomad

6,5663 gold badges20 silver badges36 bronze badges

1 Comment

Jumana Over a year ago

Thank you, clearly I need to do more research into this but thanks for the help! :)

Collectives™ on Stack Overflow

How to run multiple VBA codes

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related