Creating an Input form to set Work/Units/Duration

[Vasu Srinivasan]

How do I create a form with an "OK" button and get the control to return to
the next statement when the OK button is pressed, so that I can calculate and
then store the vlues myself?

 

[Jan De Messemaeker]

Hi,

Suppose you mean in VBA?
Make the form and give it a name say Myform
In your code Myform.show
In the code for the OK button myform.hide
That returns control afte rthe line .show
HTH

 

[Vasu Srinivasan]

Thanks for your response. Yes, I mean in VBA. I will try it.