+ Reply to Thread
Results 1 to 2 of 2

How to replicate the scrollbar feature on Excel Form using ActiveX controls and VBA

  1. #1
    Registered User
    Join Date
    07-26-2021
    Location
    Hamilton, Bermuda
    MS-Off Ver
    Office 365 E3
    Posts
    1

    How to replicate the scrollbar feature on Excel Form using ActiveX controls and VBA

    The Excel Form feature was not flexible enough for our purposes in building a database and so I created a custom data entry form using ActiveX controls and Excel's VBA. The data entry form has a Save function which saves the information entered into the ActiveX text boxes and combo boxes on the data entry form into a separate sheet (i.e. the "Database").

    I would like to add a "scroll" feature that loads information from the database back into the relevant ActiveX fields on the data entry form so that certain entries can be modified and the data can be easily scrolled through. The standard Form feature in Excel has the scrollbar feature I am describing - is it possible to replicate this manually using Excel VBA?

    Any tips or tutorial links would be very much appreciated!!

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,304

    Re: How to replicate the scrollbar feature on Excel Form using ActiveX controls and VBA

    I have attached the code below to an old file as a demo.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Torachan,

    Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.

+ 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. Form Controls and ActiveX Controls - Option Button
    By mmchaley in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-11-2021, 05:10 PM
  2. Bug: Excel 'resizes' Form/ActiveX controls
    By maestro88 in forum Excel General
    Replies: 1
    Last Post: 02-02-2018, 07:43 AM
  3. Form Controls v. ActiveX Controls
    By Richard Stringfellow in forum Excel General
    Replies: 2
    Last Post: 01-11-2016, 08:06 PM
  4. ActiveX Scrollbar Controls Problem
    By sameery in forum Excel General
    Replies: 3
    Last Post: 05-22-2014, 09:06 AM
  5. Form & ActiveX Controls
    By John Bates in forum Excel General
    Replies: 11
    Last Post: 03-05-2011, 03:59 PM
  6. Form controls vs. ActiveX controls
    By wmorrison49 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2008, 10:59 AM
  7. ActiveX Controls vs Form Controls
    By Alex in forum Excel General
    Replies: 1
    Last Post: 01-11-2006, 04:50 AM

Tags for this Thread

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