Results 1 to 45 of 45

Help with VBA code spin buttons in my password record spreadsheet

Threaded View

  1. #1
    Registered User
    Join Date
    10-30-2013
    Location
    Broxbourne
    MS-Off Ver
    Excel 2007
    Posts
    22

    Help with VBA code spin buttons in my password record spreadsheet

    Hi, can anyone help please.

    I have created the attached spreadsheet, using several guides and examples on YouTube, to record all my password information and have a couple of problems with the VBA coding.

    All works OK for searching and updating but I have a problem with the spin buttons. They scroll through the data and populate the boxes OK but I would like the resultant searched for line in the list box and in Sheet1 to have a highlight bar across the selected text, would like the scroll to start at the resultant searched data line and would like the spin buttons to search in a rotational way i.e. when it gets to the last record to start again at the 1st if I am pressing down and visa versa if pressing up.

    I would also like the double click feature to select the resultant searched for line in the list box and highlight the same on the Sheet 1 data.

    I would appreciate any help with the code in SpinButton1 and ListBox1_DblClick subs as well as any other improvements anyone thinks would be useful.

    Thank you.
    David
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Spin buttons
    By Jehannum in forum Excel General
    Replies: 3
    Last Post: 03-10-2017, 02:30 PM
  2. [SOLVED] Previous / Next Record Buttons Code Question
    By oskar44 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-26-2015, 08:15 AM
  3. Spin buttons
    By Mick Hassell in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-06-2015, 12:59 PM
  4. Macros with buttons, spin buttons, scroll buttons, etc.
    By qqbbppdd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-12-2013, 09:34 AM
  5. Replies: 1
    Last Post: 11-16-2012, 09:25 AM
  6. Command Buttons for Viewing Record, Next Record and Previous Record
    By david1987 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-23-2012, 06:30 AM
  7. spin buttons
    By svay in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-01-2008, 01:48 PM

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