Multiple 'AfterUpdates' referring to single Function

[karmacable]

Hi All,

This is more of an efficiency in coding posting than an issue. I currently have a bunch of comboboxes with their 'AfterUpdate' control referencing the same public function, so the format of my coding (not the actual long code, swapped out names/number for ease of reading);

Public Function CalcTotals
CalcTotals = 1
End Function



Private Sub cbo1_AfterUpdate()
CalcTotals
End Sub

Private Sub cbo2_AfterUpdate()
CalcTotals
End Sub

etc., etc...............

So imagine the Private 'AfterUpdate' Subs littering my VB page. I'm just wondering if there was a way to re-write so there's only one area for CalcTotals and all 'AfterUpdate's are referenced, make my page look cleaner. I guess something that would look like;

CalcTotals()
--cbo1_AfterUpdate()
--cbo2_AfterUpdate()

I know that example wouldn't work, just wondering if there's a syntax or way to get it close to that.

Thanks for any advice!

[pbaldy]

Not really. You can put:

=CalcTotals()

directly into the after update property in the properties window, so it says that instead of "[Event procedure]". Same effect, but no "litter".

[karmacable]

That's really helpful to know! Thanks....

[pbaldy]

No problem!