Reference VBA code in new event

[tjdickinson]

Hi, all, I'm new to VBA coding and, of course, trying an ambitious project (creating my own gradebook in Excel). I haven't got the time to go through an entire VBA course, so I'm turning to the experts for help. While I have a bit of general coding experience (mostly HTML), I'm an absolute novice at VBA, so please forgive my inaccuracies.

The first question is this:
I have a userform with three buttons: 'Add_Eval_Add' (adds the evaluation, then clears the form so a new evaluation can be added), 'Add_Eval_Close' (adds the evaluation, then closes the form), 'Cancel_New_Eval' (closes the form without adding an evaluation). The buttons are coded and working as expected.

The code for 'Add_Eval_Close' is, however, copied and pasted from 'Add_Eval_Add', with the additional line 'Unload Me' tacked on the bottom. I would like, instead, to have this button reference the code for 'Add_Eval_Add', and then run the 'Unload Me' command, so that I only need to make changes in one part of the code. So, something like:

Private Sub Add_Eval_Close_Click ()
Run Add_Eval_Add_Click ()
Unload Me
End Sub

Any ideas?

 

[EFANYoutube]

Try

Private Sub Add_Eval_Close_Click ()
Me.Add_Eval_Add_Click ()
Unload Me
End Sub

 

[tjdickinson]

Try

Private Sub Add_Eval_Close_Click ()
Me.Add_Eval_Add_Click ()
Unload Me
End Sub

Thanks! But I get this error message:
Compile error: Syntax error

When I click OK, it highlights the line "Private Sub Add_Eval_Close_Click ()" in yellow with a little yellow arrow next to it, and the line "Me.Add_Eval_Add_Click ()" has red text.

 

[dmt32]

Hi,
try

Private Sub Add_Eval_Close_Click()
    Call Add_Eval_Add_Click
    Unload Me
End Sub

Dave

 

[tjdickinson]

Hi,
try

Private Sub Add_Eval_Close_Click()
    Call Add_Eval_Add_Click
    Unload Me
End Sub

Dave

Brilliant, Dave! That did it! Thanks!

 

[dmt32]

Brilliant, Dave! That did it! Thanks!

welcome - glad we could help - appreciate feedback

Dave