calling a public sub does nothing

pvg1975
pvg1975 used Ask the Experts™
on
Hi All, I have a public sub on a module as follows:

Public Sub UpdateTables()
...
...
End sub

When I call the sub from a button, nothing is happening.

Im calling the sub like this:

Call UpdateTables()

Any suggestions?

Thanks!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
kaufmedGlanced up at my screen and thought I had coded the Matrix...  Turns out, I just fell asleep on the keyboard.
Most Valuable Expert 2011
Top Expert 2015

Commented:
What is is supposed to do?
just
UpdateTables()
will do
u can set a break point (or msgbox("i'm here") in the button.click function and UpdateTable sub to track whether the statement has been executed

Author

Commented:
Working now. Thanks!!!
kaufmedGlanced up at my screen and thought I had coded the Matrix...  Turns out, I just fell asleep on the keyboard.
Most Valuable Expert 2011
Top Expert 2015

Commented:
There is no difference in functionality between:

    Call UpdateTables()

or

    UpdateTables()

The "Call" version is just the old VB6-style function calling mechanism.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial