+ Reply to Thread
Results 1 to 2 of 2

Insert scrollbar at cell position

  1. #1
    Forum Contributor
    Join Date
    06-17-2012
    Location
    USA
    MS-Off Ver
    Excel 2016
    Posts
    150

    Insert scrollbar at cell position

    Good day to all,

    I am trying to insert a scrollbar at a specific cell position using VBA.

    A macro recorder would usually insert a scrollbar using this code
    Please Login or Register  to view this content.
    However, I would like to define the top, left, width and height of the scroll bar. I tried defining the scrollbar as an object, create it using the default, and then selecting it to modify its properties (see code below). But this did not work.
    Please Login or Register  to view this content.
    This scrollbar is not inside a userform or frame. It is located on a spreadsheet to control a dynamic cell scrolling.

    Thanks.

  2. #2
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Insert scrollbar at cell position

    Perhaps This
    Please Login or Register  to view this content.

+ 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. Replies: 2
    Last Post: 03-09-2012, 04:27 PM
  2. Set Vertical Scrollbar Position In User Form Listbox
    By Spencer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-28-2011, 11:27 AM
  3. Returning Scrollbar to Initial Position
    By Mordred in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-04-2011, 03:11 PM
  4. [SOLVED] insert scrollbar into a cell in Excel
    By Nick in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-19-2005, 01:05 PM
  5. [SOLVED] Keep the scrollbar at position
    By Man Utd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-14-2005, 05:05 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