How to make a userform active

I have a userform in which the user has entered text.

The user then enters a data click on the Microstation screen (which removes the focus from the form).

After the VBA program completes a task, I want the form to become active again, and display the insertion point where it was last (in the text box). I don't seem to be able to do this.

The form itself doesn't seem to have an Activate or SetFocus method. When I tried to use the .SetFocus method of the text box, the form doesn't become active, and the textbox doesn't display the insertion point anymore.

Can anyone help?

Regards,
Graham

 

Parents
  • Graham said:
    After the VBA program completes a task, I want the form to become active again

    I'm guessing here because you want us to imagine what your code looks like.  Presumably the task and form are part of the same VBA project?

    How does a 'data click on the MicroStation screen' transfer text from your form to whatever happens next?  What happens in that task?  What happens when the task is complete?

     
    Regards, Jon Summers
    LA Solutions

Reply
  • Graham said:
    After the VBA program completes a task, I want the form to become active again

    I'm guessing here because you want us to imagine what your code looks like.  Presumably the task and form are part of the same VBA project?

    How does a 'data click on the MicroStation screen' transfer text from your form to whatever happens next?  What happens in that task?  What happens when the task is complete?

     
    Regards, Jon Summers
    LA Solutions

Children