Multiple Private Sub - vb code

[Ver101]

Guys,


How to combine two separate code (private Subs) into one private subs under click event button?

Ex. Button 1 (private sub) - to open forecast table
Button 2 (private sub) - to open Actual table

how can i combine it to have button 3 which is (to open forecast table then actual table)


I need help on this guys.....

 

[jeffreybrown]

Assign to button #3

Sub Button3_Click()
    Call sub1
    Call sub2
End Sub

 

[Ver101]

Assign to button #3

Sub Button3_Click()
    Call sub1
    Call sub2
End Sub

Hi Jeff, Thanks it works!!!!!

 

[jeffreybrown]

You are very welcome. Glad it worked for you and thanks for the feedback

 

[Ver101]

Assign to button #3

Sub Button3_Click()
    Call sub1
    Call sub2
End Sub

Hi Jeff, Thanks it works!!!!!