Featured post
vba - Visual Basic - how to force event to fire -
i'm new vb (using vba, actually) , force event fire. specifically, updating value in textbox , call textbox's afterupdate() event.
private sub cmdcreateinvoice_click() me.txtinvdate = '11/01/10' me.txtinvdate.afterupdate end sub
during run time, error says "compile error: invalid use of property". if try similar, click event (ex: cmdcreateinvoice.click), not have property shares name, error says "compile error: method or data member not found".
know there must way fire 1 event another. proper syntax? thanks!
afaik, there no way "fire event manually" in vb(a). can call event handler manually, , this, rdkleine has given answer already:
call txtinvdate_afterupdate()
this have same effect if event had fired (though not give whole chain of events may fire along it--unless call
handlers well).
igorm has valid point, in comments on answer--it's "cleaner" write different sub work want done, call both event handler & wherever you're trying (button click?). so:
private sub txtinvdate_afterupdate() dowhatever end sub private sub button_click() dowhatever end sub private sub dowhatever 'your desired effect end sub
you make dowhatever
public sub in module.
edit
and no, in vb(a) doesn't matter order define sub (or function) routines.
- Get link
- X
- Other Apps
Comments
Post a Comment