Slider Bar vba

[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?

I tried:
Range("A1") = Slider1.Value

but that did not work. What am I doing wrong? What am I missing? This is driving me nuts!

 

[hatman]

What about

Private Sub Slider1_Change()

    Range("a1").Value = Me.Slider1.Value

End Sub

 

[sneel3]

Hatman rules!

 

[sneel3]

Hatman rules!

 

[sneel3]

Hatman rules!

 

[mrattana]

Hello,

For Outlook 2003 VBA...

Have a quick question about this vba slider bar thingy. This may sound a bit funny and impossible, but is there a way to have a vba controls your outlook signature - have it move from left to right or vise versa? - or have it dissolved automatically after they open the mail and certain times passed? - I've seen some people's outlook emails with that kind of cool stuff you know...

Thanks people...

Let me know...