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
