+ Reply to Thread
Results 1 to 3 of 3

Toggle button inside userform

  1. #1
    Forum Contributor
    Join Date
    09-21-2016
    Location
    UK
    MS-Off Ver
    2016
    Posts
    131

    Toggle button inside userform

    Hello all,

    I have got a user form where a user can find a toggle button inside. There is macro assigned to that button when a user presses that button macro runs. And it is suppose to run until the user unpresses the button. But the problem is that when you close the user form toggle button goes to false value. Is there any idea how do I keep this button pressed in until its actualy unpressed by the user.

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor kasan's Avatar
    Join Date
    07-22-2009
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2010
    Posts
    680

    Re: Toggle button inside userform

    Hi,
    How do you suppose to unpress that button if UserForm is closed?

  3. #3
    Forum Contributor
    Join Date
    09-21-2016
    Location
    UK
    MS-Off Ver
    2016
    Posts
    131

    Re: Toggle button inside userform

    I mean when user closes the user form button turns into false value and I want it to keep keep being value as true. Because when user brings the user form back in front the button is unpressed and user needs to press it again to start running macro and then that means two macros are running at the same time. I want to maintain the button value even if user form is closed.

+ 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. Userform Toggle or Option button based on Listbox selections
    By KML1976 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-31-2016, 10:52 AM
  2. userform toggle button, 3 selection options? True, False and caption.
    By nvandyken in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-27-2015, 02:08 PM
  3. Toggle Button Does not Toggle OFF when Clicked
    By robbfamily in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-19-2014, 05:12 PM
  4. Replies: 1
    Last Post: 02-13-2014, 10:55 PM
  5. [SOLVED] UserForm Toggle Button Code
    By JasonRay in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-08-2013, 05:29 PM
  6. Place a Toggle Button Automatically on a UserForm
    By siamadu in forum Excel Programming / VBA / Macros
    Replies: 31
    Last Post: 02-16-2009, 10:11 PM
  7. TOGGLE BUTTON on userform problem
    By davidm in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-24-2005, 05:40 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