Update formula on activation of scrollbar

[jeffreybrown]

I have a Sroll Bar(Form Control) on a worksheet which controls the dataset for a chart.

Is there a way to insert a formula in a particular cell when the user activates the scroll bar, but only on the first time they use the scroll bar?

 

[VoG]

Unfortunately (even with a linked cell designated) changing a Forms scrollbox does not fire an event.

With a controls toolbar try

Private Sub ScrollBar1_Change()
'your stuff here
End Sub

 

[jeffreybrown]

Thanks Peter this will work great.

 

[CWatts]

You could use an if statement to check if there is a formula in that cell, and if not, add one:

Sub ScrollBar()
    If [a3].Formula = "" Then [a3].Formula = "=A1*2"
End Sub

 

[jeffreybrown]

Thanks CWatts,

This sounds good, but I need the cell to update when the user activates the scroll bar. I've changed to the contols scroll bar as Peter suggested.