Spinner-requiring Spinner buttons

Hi
I have an Excel spreadsheet with about 100 cells requiring Spinner buttons. At present the workbook displays as a single view without the need to scroll left right. If I add Spinner buttons I will lose this view which is very inconvenient as most of the users use tablet PC's

Is there any way that when I select a cell that I have a spinner control available to that cell only. In much the same vein as a validation field using List

Thanks in anticipation

--
Message posted via http://www.officekb.com

Hi,

Technically, the Spinner Control is not part of any worksheet cell. Once you click the Spinner, you have activated the control not the cell beneath it. However, You can click on a particular cell and then activate one or more Spinner Controls on the worksheet.

To activate a specific Spinner when a particular cell is clicked, requires writing code in the Worksheet_ SelectionChange() event using VBA.
________________________________________________________________

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)

If Target.Address = "$C$1" Then
Spinner1.OnAction = "MyMacro"
End If

End Sub
________________________________________________________________

This event returns the user's selection whenever a cell or range of cells is selected. This check to see if cell "C1" was clicked on. If so, Spinner1 is set to execute MyMacro when clicked.

Hope this helps,
Leith Ross