+ Reply to Thread
Results 1 to 7 of 7

Scroll to the top of an ActiveX List Box

Hybrid View

  1. #1
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Scroll to the top of an ActiveX List Box

    You're over-complicating things...
    ActiveSheet.listbox_serial_subtype.TopIndex = ActiveSheet.listbox_serial_subtype.listindex
    It would have helped if you had included your code in your initial post - would have saved 2 unnecessary replies...

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

    Re: Scroll to the top of an ActiveX List Box

    This gives the same error as above (438).

    I've also found that ActiveSheet.listbox_serial_subtype.Select gives the same error, whereas ActiveSheet.Shapes("listbox_serial_subtype").Select works.
    Last edited by Pedsdude; 01-28-2014 at 07:52 AM.

+ 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. [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