Greetings, Yes.
The problem here is how you are launching the Userform - or more specifically the Modal setting being used. What is probably happening with the syntax you are using is that it's interpreting that as 0 - which causes the form to load modeless (what you are seeing now) For the Show method, Modal is the default setting actually. So to launch your form simply use: Userform1.Show Or to be specific Userform1.Show 1 And of course since the form is modal, you'll need the form to go away when the button is clicked. Unload UserForm1 Will "destroy" the form so if you have code in the form initiate event handler, this is probably what you want - unless you don't want this code firing each time the form is displayed J In that case, you'd use Me.hide which will hide it, but it stays in memory Regards, Thom Thom C. Blackwell Product Manager Boston Software Systems (866) 653-5105 ex 807 www.bossoft.com <http://www.bossoft.com/> Sign up for my weekly webinar! <http://www.bostonworkstation.com/customer_center/special_events.aspx> LEGAL NOTICE Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this E-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents of this E-mail or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately, then delete this message and empty from your trash. From: [email protected] [mailto:[email protected]] Sent: Wednesday, August 05, 2009 4:05 PM To: Talk Subject: [talkbws] User Forms. Hi All, IS there a way to halt the script till the User Interacts on the User Form? I need to collect some info from the user before the scripting into Meditech. Right now I created a UserForm and has a simple text box and Command Button. I am calling this UserForm (UserForm.Show=vbModal) in the first step. But as soon as the form is showing it is going to the next step, before the user has a chance to enter the data. Is there a way I can wait till the user hits the command button? How do we wire up Form Controls into Script Module?? thank you. Ranjit M Bendapudi Meditech Service Center CSC 5209 Linbar Dr., Nashville, TN 37211 P: +1-615.662-7775 |direct: +1- 615.493.9070 |[email protected] | www.csc.com This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. --- To post a message to this list, send mail to: [email protected] You are currently subscribed as: [email protected] Unsubscribe in the customer center on our website: http://www.bostonworkstation.com/customer_center/virtual_user_group_talk .aspx --- To post a message to this list, send mail to: [email protected] You are currently subscribed as: [email protected] Unsubscribe in the customer center on our website: http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx
