+ Reply to Thread
Results 1 to 2 of 2

Macro for a form control button to reset scroll bars to a static column of numbers

Hybrid View

  1. #1
    Registered User
    Join Date
    05-08-2014
    MS-Off Ver
    Excel 2003
    Posts
    1

    Macro for a form control button to reset scroll bars to a static column of numbers

    I have never written or used a macro before and I have a simple macro task to complete:


    I have Column L (L4:L10) of seven scroll bars that move according to number changes in column F (F4:F10). I want to create a form control command button that resets the changes on the scroll bars according to static column of numbers in Column E (E4:E10).


    I don’t know if it matters, but I’ll add that I plan to add a second button that does the same thing with a different column of data. I assume I’ll simply replicate whatever procedure I use in the first button—is this okay?


    This is quite simple, right? Can anybody help me or point me in the right direction? I have no experience writing code or macros. Thank you.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,651

    Re: Macro for a form control button to reset scroll bars to a static column of numbers

    I think this is all you need.

    Sub Reset_Sliders()
        Range("F4:F10").Value = Range("E4:E10").Value
    End Sub
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Scroll bar (Form Control) - Resetting the scroll bar to particular values
    By Vishb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-29-2011, 04:10 AM
  2. Replies: 3
    Last Post: 01-07-2010, 04:55 AM
  3. Scroll Bars in a form
    By dextras in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-04-2009, 06:30 AM
  4. [SOLVED] Scroll bars without control tabs
    By CJ in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-22-2006, 07:55 PM
  5. Is there any way to reset scroll down menus using a button?
    By Excelishard in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-03-2006, 12:33 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1