Results 1 to 7 of 7

Scroll to the top of an ActiveX List Box

Threaded View

  1. #1
    Registered User
    Join Date
    11-07-2012
    Location
    Newcastle, UK
    MS-Off Ver
    2010
    Posts
    31

    Scroll to the top of an ActiveX List Box

    I've had a lengthy online search for this, but haven't managed to find a solution, so I'm not getting my hopes up here

    Within a worksheet, I have a list box, created exactly as in steps 1 & 2 of this link
    EDIT: I used a Form control, not an ActiveX control

    There are a large number of options in the list box, and so there is a scroll bar to the right hand side.

    Elsewhere on the same worksheet, I have a "Reset Inputs" button, which runs a macro which sets all checkboxes, radio buttons, list boxes etc. to the top/default values.

    I am able to automatically select the 1st choice in the list box by changing the cell link value to '1'.

    If the list box is scrolled down at all (i.e. you cannot see the top choice), then selecting the 1st choice using this macro will not scroll the list box back up to the top.

    In other words, the top value will be selected, but you cannot see that it is selected, as the scroll position itself does not change.

    I have named the list box, and can select it in VBA by using:
    ActiveSheet.Shapes("listbox_serial_subtype").Select

    At this time I don't have an example document I can provide - the one I'm using is confidential - but I will create an example one from scratch if required.
    Last edited by Pedsdude; 01-28-2014 at 09:09 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Scroll down through ActiveX for dates but turns into values - how to change to date
    By Johfra in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-29-2014, 09:28 PM
  2. Drop Down List ActiveX
    By yching in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2013, 06:16 AM
  3. Fomula in ActiveX List Box
    By sick stigma in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-14-2011, 02:20 PM
  4. ActiveX List Box Drop Down Box Count
    By farzyness in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-11-2011, 10:46 AM
  5. activeX scroll bars
    By joop.broekman@guar.danisco.com.nospam in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-22-2006, 06:10 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