Hi Daniel Wow, works wonderfully well. Very much appreciated.
Regards Charlie On Sun, Sep 4, 2011 at 11:54 PM, Daniel <dcolarde...@free.fr> wrote: > See attached workbook.**** > > ** ** > > HTH**** > > ** ** > > Daniel**** > > ** ** > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* Cab Boose > *Envoyé :* dimanche 4 septembre 2011 03:05 > > *À :* excel-macros@googlegroups.com > *Objet :* Re: $$Excel-Macros$$ Counter in a Cell**** > > ** ** > > Hi Everbody**** > > **** > > Thanks for all your options.**** > > **** > > I would like to explain a little more. I want a small 5 pad keyboard to > plug usb into laptop. Operator will not necessary have access to screen. > The operator will just use up or down button to change the speed. So the > H11 will need to be frozen I guess and then count the ups and downs and show > a number in that cell.**** > > **** > > Daniel - your macro looks like doing as required, but I have tried with > cursor in H11 and press the up or down, message comes up with unable to find > macro. Now I have your second emailed macro in the Wookbook module. Do I > still need some of the macro in the first email in a module?**** > > **** > > Attached workbook as I have at the moment.**** > > **** > > Appreciate all your work everyone.**** > > **** > > thanks**** > > **** > > Charlie Harris**** > > On Sun, Sep 4, 2011 at 3:18 AM, Excel Inspiration < > xcel.inspirat...@gmail.com> wrote:**** > > Mr.Charlie,**** > > **** > > Please find the attached file. I have used Spin button (Form Control). It > can be used another sheet linked with sheet 1 – H11 as you requested.**** > > **** > > *- Xcel Inspiration***** > > **** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Cab Boose > *Sent:* 03 September 2011 05:13**** > > > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Counter in a Cell**** > > **** > > Hi**** > > **** > > In attached Sheet1, I want the cell to count from 0 to 16 up and down in > between. The count is of times up arrow and down arrow are pressed.**** > > **** > > To set speed from, 0 to 16 for model railroad project.**** > > **** > > Your advice appreciated.**** > > **** > > Thanks**** > > **** > > Charlie Harris**** > > -- > > ---------------------------------------------------------------------------------- > 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/discussexcel**** > > -- > > ---------------------------------------------------------------------------------- > 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/discussexcel**** > > ** ** > > -- > > ---------------------------------------------------------------------------------- > 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/discussexcel**** > > -- > > ---------------------------------------------------------------------------------- > 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/discussexcel > -- ---------------------------------------------------------------------------------- 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/discussexcel