Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SpinButton Change Selection
Hi,
I would like to create a SpinButton with which I change from one cell to the next one (up and down). I tried this: Private Sub SpinButton1_Change() With SpinButton1 .Min = 1 .Max = 10 Cells(.Value, 1).Select Cells(.Value, 1) = .Value End With End Sub The problem is that the "Cells(.Value, 1).Select" doesn't work properly. But the values in the cells are like expected "Cells(.Value, 1) = .Value". If you use the code above you can see what I mean. Many thanks for help. Best regards, Marlon |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spinbutton | New Users to Excel | |||
Spinbutton | Excel Discussion (Misc queries) | |||
Change row selection | Excel Worksheet Functions | |||
spinbutton? | Excel Programming | |||
Using Spinbutton to change a date | Excel Programming |