 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / January 2007Pressing a CommandButton on a Userform via Code
I want to have a user click a Commandbutton on Userform5 that will Show Userform8. This is OK, Userform8 has a CommandButton1 to View a Sheet in PrintPreview. How can i get the Userform8 CommandButton to to Coded to Run to the Preview with out having to press it ? I tried: Call Userform8.Commandbutton1 but get an error also tried: Call CommandButton1 but still get an error. How can this be done? Corey.... Corey, CommandButton1.Value = True NickHK > I want to have a user click a Commandbutton on Userform5 that will Show > Userform8. [quoted text clipped - 11 lines] > How can this be done? > Corey.... Hmm. Still a bit puzzled. So how would I : Using Commandbutton3 on Userform5 i copied the code that i normally use to unload the uersorm data into a sheet. i want to add at the end of this code the following: Userform4.Show & use the value that was in Userform5.Textbox195 as the selected value in Userform4.Combobox1.value, then Press the CommandButton1 of Userform4(CommandButton1.Value = True), then this Button inputs data from the sheet that Userform5 also add data to, thendisplays a 1 page sheet with the data placed in the relative cells in Print Preview mode. I am having trouble carrying the value from Userform5 through to Userform4, and getting each of the Userforms no longer require to Close off correctly. Any idea's of the most efective way to do this? I tried copying ALL code into the CommandButton3 code on Userform5 but it took forever and stalled at stages with errors. Corey.... >I want to have a user click a Commandbutton on Userform5 that will Show >Userform8. [quoted text clipped - 11 lines] > How can this be done? > Corey.... Corey, Not sure about everything you're after, but.... with Userform4 .load 'but not show yet .Combobox1.value=userform5.textbox195.text userform5.hide 'or unload userform5 .show 'vbmodal or vbmodeless end with NickHK > Hmm. > Still a bit puzzled. [quoted text clipped - 36 lines] > > How can this be done? > > Corey.... What does this do: 'vbmodal or vbmodeless ?? > Corey, > Not sure about everything you're after, but.... [quoted text clipped - 53 lines] >> > How can this be done? >> > Corey.... > What does this do: > 'vbmodal or vbmodeless It indicates that either the vbModal or the vbModeless constant value should be provided to the Show command. With vbModal, you can interact only with the form until the form is hidden or unloaded. You can't access anything outside the form, and code execution pauses on the Show statement until the form is dismissed. With vbModeless, the form is shown and execution proceeds past the Show statement. With a modeless form, you can interact with the Excel environment while the form is still visible. If neither vbModal or vbModeless parameter is omitted the form is show modal unless the ShowModal property is set to False.  SignatureCordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) > What does this do: > 'vbmodal or vbmodeless [quoted text clipped - 60 lines] >>> > How can this be done? >>> > Corey.... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.