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
