Pause VBA Code until userform command button is clicked

[JeffGrant]

Hi all,

I set my userforms up to be Modal. No Drama.
On the userforms is usually a couple of command buttons.

Until recently, the vba code would pause until a command button is clicked.

The userform is shown via a called sub.

But this week, I find that the vba code continues without waiting for a command button to be clicked.

Do I need to add some code to make sure that the code pauses until a command button is clicked?

I see that there are several discussions about this using wait and sleep and Do Untils etc, but the solutions all seem far more complicated than what it needs to be.

I think I am missing the obvious solution.

Any direction would be greatly appreciated. Thanks

 

[Skyybot]

Can you post your code for inspection?

 

[JeffGrant]

Thanks Skyboy. Problem solved. I was calling and incorrect sub. was difficult to find. but i got