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 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
Timer.xls
Description: Binary data
