userform

[RobcPettit]

Hi, if I create a userform with 4 textboxes and run the form. Is it
possible to add data to the textboxes. I have live data streeming into
excel, which updates ok when the form is running. When certain
conditions are met Id like to update the userform text boxes. Is this
possible without putting a command button on the form.
Regards Robert

 

[Guest]

If the userform is shown as modeless, then worksheet events should be able to
fire and update its values.

 

[RobcPettit]

Thanks for your reply Tom, Ive made the form modeless and it updates
fine.
Regards Robert