 |
 | 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 / Word / Programming / November 2004Timed userform with active command button?
I'm having a rough time creating a userform that presents a userform with an active command button and that times out after about 2 seconds, w/ the macro then continuing to execute. I have tried UserForm_click() but then I can't get the form to unload. I tried Unload <formname> as well as Unload Me, I also have tried UserForm_Activate(), and th eform times out properly, but, while the form is displayed, the command button in the form is not actiive, i.e., it fails to respond to user clicks. I have tried SendKeys combined with an accelerator key and many other possibilities.Today, I spent hours on this problem, including searching Usenet groups and mvp Faqss . Here's the bigger picture. This macro saves the active Word document to 3 different folders. It defaults to 3 locations in which to save. But, in the first second or 2 of execution, I want to give the user the option of stopping the macro to change the default locations, via another form that is otherwise ready to go. 1. Is there a way to get the job done in my current direction, that is, using a useform that provides an active command button but that times out after a second or 2? 2. Are there other avenues I should consider to gett this functiomnality? Because I have so much time invested in #1, I'd like to make it work, other things being equal. Thx much! xxxBogus-email-address@oblivion.com was telling us: xxxBogus-email-address@oblivion.com nous racontait que : > 1. Is there a way to get the job done in my current direction, that > is, using a useform that provides an active command button but that > times out after a second or 2? Probably, but that is not really user friendly, IMHO (See below). > 2. Are there other avenues I should consider to gett this > functiomnality? Why not have two commanf buttons on the main userform? Labeled Default Save Custom Save ??? This way you can still user your second userform. Also, timing out is not a good idea, I think, from a user perspective. What if something catches their attention (in their environment) just during the time for custom saving and they miss it? Once they get used to it, they will have to be ready to catch your 2 second chance to custom save... Let's say they are ready, then the phone rings? If you give a longer delay, it will just annoy them when they just want to do a default save... So, let the user decide what he/she want to do from the outset, this way everyone is happy.  SignatureSalut! _______________________________________ Jean-Guy Marcil - Word MVP jmarcilREMOVE@CAPSsympatico.caTHISTOO Word MVP site: http://www.word.mvps.org I'll think about it some more, but I'm still inclined to go with it cause it would enable the user to run the macro and execute the 3 default saves with one command ("fire and forget") but provide the capacity to change the defaults with user intervention. This is a macro that some users might use 20 times a day, so, once they have the default paths where they want, saving a keystroke or click X 20 X 5days/we x ~50 weeks X ~20 users. I found the technical solution at http://word.mvps.org/FAQs/Userforms/CreateASplashScreen.htm in the section titled "If you want the user to be able to cancel out of the splash screen ." I was able to adapt a few of the ideas there and it worked. Thx anyways. Until my next problem... ===== >xxxBogus-email-address@oblivion.com was telling us: >xxxBogus-email-address@oblivion.com nous racontait que : [quoted text clipped - 23 lines] >So, let the user decide what he/she want to do from the outset, this way >everyone is happy. > I'll think about it some more, but I'm still inclined to go with it > cause it would enable the user to run the macro and execute the 3 > default saves with one command ("fire and forget") but provide the > capacity to change the defaults with user intervention. But this what I was suggesting. *One* click to save to the default location OR *One* click to save to a custom location. This is why I mentioned 2 buttons on the initial userform. > This is a macro that some users might use 20 times a day, so, once > they have the default paths where they want, saving a keystroke or [quoted text clipped - 6 lines] > > I was able to adapt a few of the ideas there and it worked. Glad you worked it out. But, personally, as a user, I would not like the idea of the "x-second chance" to change the default. If I get distracted, I might miss my opportunity. OTOH, I do not know your users... SignatureSalut! _______________________________________ Jean-Guy Marcil - Word MVP jmarcilREMOVE@CAPSsympatico.caTHISTOO Word MVP site: http://www.word.mvps.org Naw, One click to fire up the macro and you're done if you let it use the default. ===== >> I'll think about it some more, but I'm still inclined to go with it >> cause it would enable the user to run the macro and execute the 3 [quoted text clipped - 23 lines] >opportunity. >OTOH, I do not know your users... xxxBogus-email-address@oblivion.com was telling us: xxxBogus-email-address@oblivion.com nous racontait que : > Naw, One click to fire up the macro and you're done if you let it use > the default. LOL This is exactly what I have been saying all along... With a an autoclose pop-up userform, if the user does not want to use the default, the user needs a second click that is timed within the time frame you allow within the macro, which might not be sufficient under some circumstances. All I wrote was: Two buttons side by side, the user clicks on the appropriate button only once - one click in both cases. User either clicks on "Save Default" *OR* user clicks on "Save Custom." That's it... one click! Cheers. SignatureSalut! _______________________________________ Jean-Guy Marcil - Word MVP jmarcilREMOVE@CAPSsympatico.caTHISTOO Word MVP site: http://www.word.mvps.org
|
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.