+ Reply to Thread
Results 1 to 4 of 4

Making a scrollbar visible when the toggle button is active

  1. #1
    Registered User
    Join Date
    02-26-2021
    Location
    Amsterdam
    MS-Off Ver
    2020
    Posts
    3

    Making a scrollbar visible when the toggle button is active

    Hi Guys,

    I have a question about making a scrollbar appear when a toggle button is pushed. The toggle button is used to hide and unhide rows. So when the rows are visible I would like to use a scrollbar for changing data in a graph. However when the toggle button is pushed again the rows hide, expect for the scrollbar..
    I thought by using the following code it would be easily solved, however the scrollbar is now hiden at any time. Not so sure what I did wrong?

    Private Sub ScrollBar1_Change()
    If ToggleButton4.Value = True Then
    ScrollBar1.Visible = False
    Else
    ScrollBar1.Visible = True
    End If

    End Sub

    Hopefully someone can help me

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Making a scrollbar visible when the toggle button is active

    Put the code in the toggle button _Change procedure.

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    02-26-2021
    Location
    Amsterdam
    MS-Off Ver
    2020
    Posts
    3

    Re: Making a scrollbar visible when the toggle button is active

    Oh thanks a lot!!

  4. #4
    Registered User
    Join Date
    02-26-2021
    Location
    Amsterdam
    MS-Off Ver
    2020
    Posts
    3

    Re: Making a scrollbar visible when the toggle button is active

    However, if I now use the toggle once, afterwards I cannot use the scrollbar any more... as it looks kind of stock?

+ 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] Toggle Button to work when making a copy of the tab
    By therealaccountant in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2021, 02:11 PM
  2. [SOLVED] Active X Toggle Button Nullifying Subsequent Clicks
    By cbrown6305 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-11-2020, 09:45 PM
  3. [SOLVED] Make Shape Behave Like Active X Toggle Button
    By fireguy7 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-18-2018, 03:49 AM
  4. Button to toggle visibility of all ovals on active sheet
    By apathetic in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 01-19-2013, 12:27 AM
  5. Toggle button that changes color (say between red & green) for Inactive / Active
    By TrippKnightly in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-11-2012, 11:10 AM
  6. Toggle Button to Start/Stop Scrollbar Progression
    By JP777 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-30-2012, 12:46 AM
  7. [SOLVED] making toggle button in xl menu
    By tom taol in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-13-2006, 08:10 PM

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