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

Thread: Link a VBA scroll bar to a sheet and have it move data up and down a column?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Feb 2014
    Posts
    2,283
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

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

    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

  2. #2
    MrExcel MVP
    Join Date
    Jan 2008
    Posts
    14,834
    Post Thanks / Like
    Mentioned
    26 Post(s)
    Tagged
    12 Thread(s)

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

    Perhaps this:-
    Code:
    Private Sub ScrollBar1_Change()
    ScrollBar1.Max = 100
    ScrollBar1.Min = 1
    Range("Y1:Y100").ClearContents
    Cells(ScrollBar1.Value, "Y") = "Start"
    End Sub
    Regards Mick

  3. #3
    Board Regular
    Join Date
    Feb 2014
    Posts
    2,283
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default 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

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •