m [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
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
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 Septe
Use a SPIN button from the control toolbox. See atttached
From: Cab Boose
Sent: Friday, September 02, 2011 8:12 PM
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
Sorry,
In ThisWorkbook, change for :
Private Sub Workbook_Open()
Sheets("Sheet1").Activate
Application.OnKey "{UP}", "Plus"
Application.OnKey "{DOWN}", "Moins"
End Sub
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
If Sh.Name = "Sheet1" Then
Applica
Hi,
Paste the below macro in the ThisWorkbook module :
Private Sub Workbook_Open()
Application.OnKey "{UP}", "Plus"
Application.OnKey "{DOWN}", "Minus"
End Sub
Paste the bellows macros in a standard module :
Sub Plus()
With Sheets("Sheet1")
If ActiveSheet.Na
