Private Sub Slider1_Click() End Sub...What next???

[sneel3]

My vba reads like this for a "slider bar" found in the "Control Toolbox" by clicking the "More Controls" icon. I chose "Microsoft Slider Control, version 6.0"

Private Sub Slider1_Click()

End Sub

How do I link this to a cell in a spreadsheet?

 

[Norie]

Wouldn't it be something like this?

Range("A1") = Slider1.Value

 

[sneel3]

That sounds right, but it is not working, it must be something really simple I am missing.

Here is my vba:

Sub Slider1Value()
Range("A1") = Slider1.Value
End Sub

Any ideas?

Does something need to be in cell A1?