You're welcome. Regards - Dave. > Date: Sun, 7 Nov 2010 06:25:05 -0800 > Subject: Re: $$Excel-Macros$$ playing with several timers with vba excel 2000 > ... > From: jos...@gmail.com > To: excel-macros@googlegroups.com > > Hi Dave ! > first of all, thanks a lot for your response and your example, it > works like a charme ! > > I'm sorry about the month for responding to you ! > > again : thanks a lot, it will a super example to learn more about > timers ! > > José > > On 11 oct, 11:29, Dave Bonallack <davebonall...@hotmail.com> wrote: > > Hi Alfred, > > > > Please don't apologise for your English. We are quite tolerant here. > > > > Have a look at the attached. First click on the 'Subject' buttons. You will > > notice that clicking any one of them puts a "Yes" in it's Row, and changes > > the other Rows to "No". > > > > Use these buttons to select which subject is the first to be discussed. > > > > I have used seconds, not minutes, for test purposes. But you can change > > back to minutes later. > > > > You can enter whatever values you want in Cells B3, B4 and B5, but I > > suggest you leave them as they are for now. > > > > The value in Cell B2 is the entire length of the meeting, and is just the > > sum of B3, B4 and B5 > > > > Click the Start button. and watch what happens. > > > > You can click on a different Subject button at any time to change which > > Subject is being timed, despite the fact the cursor has changed. > > > > The bar graph effect is done by Conditional Formatting. Each colour cell > > represents 1/20 of the subjects allotted time. > > > > One small problem - if you want the main timer to stop it before the end of > > the meeting, select any unused cell and type something (eg: 1) > > > > Thanks for the interesting question, and let us know how it goes. > > > > Regards - Dave. > > > > > Date: Sun, 10 Oct 2010 17:14:40 -0700 > > > Subject: $$Excel-Macros$$ playing with several timers with vba excel 2000 > > > ... > > > From: jos...@gmail.com > > > To: excel-macros@googlegroups.com > > > > > Hi to all ! > > > first of all, sorry for my so poor english, i'm a poor poor poor > > > frenchy guy ! > > > > > i'm trying to dev à "meeting time manager" ... > > > > > here is my project : > > > > > in e meeting, you have several subjects, and, of course > > > each subjects have there own time... > > > And, of course, one meeting have his global time. > > > > > for exemple > > > > > meeting EXCEL 3 houres. > > > > > and for example > > > subject 1 : macros : 1 houre > > > subject 2 : cells : 30 minutes > > > subject 3 : automation : 1h30 > > > > > well, I write those lines in a sheet.... > > > > > for each line (meeting EXCEL, subj 1, subj 2 subj 3) i would like > > > to créate a sort of buton tu start à timer, AND, créate a sort of > > > progress bar (for each line) with a label, and the width propriety > > > to show the time progress.... > > > > > of course, the general time meeting (first line) can't be stopped. > > > > > and, for all the subjects, the "pilot" of the meeting can decide wich > > > subject will be treated or not.... and purhaps another order ... > > > > > If a "excel guru" can help me, it will be fantastic for me. > > > > > of course, I must dev on my own that little app, but, if > > > i can read some examples on : > > > - using timers > > > - using progress bar with timers. > > > - creating labels if a cell is not blank (for exemple if > > > I put "tatatatat" column A line 6, then I love to know > > > how to create à buton on line 6 column B, and some Label maned > > > like the content of line6 colA.) > > > > > well..... very very very thanks for having read my horrible english > > > problem, without google translate ! lol > > > > > José from France > > > > > -- > > > ---------------------------------------------------------------------------------- > > > Some important links for excel users: > > > 1. Follow us on TWITTER for tips tricks and links > > > :http://twitter.com/exceldailytip > > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > > > To post to this group, send email to excel-macros@googlegroups.com > > > > > <><><><><><><><><><><><><><><><><><><><><><> > > > Like our page on facebook , Just follow below link > > >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&... > > > > > > > > Timer.xls > > 39KAfficherTélécharger > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts