auto command button

kitty77

Registered User.
Local time
Today, 03:45
Joined
May 27, 2019
Messages
717
How would I after update in a field press a command button with vba?

Basically, after the field is updated, I manually have to click the command button. Would like it to happen automatically.

Thanks...
 
Hi. You could just "call" it. For example:


Call ButtonName_Click()


Hope it helps...
 
Will give that a try. BTW, your website is VERY helpful. Lots of good stuff!
 
For myself, if I have code that will be called from more than one place, I put it in its own SUB. I then reference that SUB any place I need to. This helps avoid the "Well, this button presses that button, which pushes those buttons" issues and helps you keep track of where you have code.
 
Where can I learn about SUB's, examples, etc. I have not used them yet.

Thanks...
 

Users who are viewing this thread

Back
Top Bottom