Run Private Subs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I rerun all of my private subs? If I make a different slection in my
combo box it changes the base rate in my form so I need to rerun all of the
subs again. Does anyone have a clue on how to do this because I am out of
ideas.

Thank You in advance

Mal
 
Well, keep in mind it's all event driven, right? So some event of the
combo-box needs to trigger a public event, which in turn needs to trigger
your set of private subs.
 
Thank you for responding
I agree with you .
I am somewhat new at this so I am not sure I understand what you mean by
using a Public to call a private.

Mal
 
Ooops, my head is in the wrong group...

Forget Private, Public...all subs within the form should be private.

The combo-box would trigger an event, in this case likely AfterUpdate (User
selected a new value from list)...in that event, just run the various subs

Private Sub cmbMyCombo_AfterUpdate()
Sub1()
Sub2()
Sub3()
End Sub
 
Thank You Steve

Steve Schroeder said:
Ooops, my head is in the wrong group...

Forget Private, Public...all subs within the form should be private.

The combo-box would trigger an event, in this case likely AfterUpdate (User
selected a new value from list)...in that event, just run the various subs

Private Sub cmbMyCombo_AfterUpdate()
Sub1()
Sub2()
Sub3()
End Sub
Click to expand...
 
Back
Top