Link a VBA scroll bar to a sheet and have it move data up and down a column?

[tonywatsonhelp]

Hi Everyone,

I want to set up a VBa scroll bar to move a value up and down rows in a column?

In Column Y I have the word "Start" now lets say its in cell Y25
I'd like to have a VBA scroll bar next to it and as I scroll up and down have the word "Start" move up and down the Column.
can this be done?
Any ideas how I could do it?

Thanks

Tony

 

[MickG]

Re: how can i link an VBA scrol bar to a sheet and have it move data up and down a column?

Perhaps this:-

Private [COLOR="Navy"]Sub[/COLOR] ScrollBar1_Change()
ScrollBar1.Max = 100
ScrollBar1.Min = 1
Range("Y1:Y100").ClearContents
Cells(ScrollBar1.Value, "Y") = "Start"
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]Sub[/COLOR]

Regards Mick

 

[tonywatsonhelp]

Re: how can i link an VBA scrol bar to a sheet and have it move data up and down a column?

Perfect, thank you mickG