+ Reply to Thread
Results 1 to 5 of 5

toggle button problem

  1. #1
    Registered User
    Join Date
    05-10-2015
    Location
    Ryton
    MS-Off Ver
    Office 2013
    Posts
    49

    toggle button problem

    Hi All

    I am building a naps table calculator for making entering data easier week by week and have come up against a wall

    I have 3 toggle buttons
    one for flat season
    one for Jumps season
    and a third for Festivals
    all on userform 2

    I have them all in frame 3

    I want to make frame 1 and frame 5 (still to be made) invisible and inactive which is for the jumps season and festivals when togglebutton 1 (Flat) is selected
    and show another frame lets say frame 4 (still to be made) active and visible

    Frames 1, 4 and 5 will all be the same size and "underneath" each other

    Is this possible

    regards
    Attached Files Attached Files

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: toggle button problem

    1) Adding Frame1 and Frame4 and Frame5 to your forms
    2) Set your form initialization to make those frames visible=false at the start
    3) Then your code for the toggles would look something like this:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    05-10-2015
    Location
    Ryton
    MS-Off Ver
    Office 2013
    Posts
    49

    Re: toggle button problem

    Thank you
    I was beginning to think of getting rid of toggle buttons and using tabbed frames
    I will do as you have wriiten and get back to you

    thanks again

  4. #4
    Registered User
    Join Date
    05-10-2015
    Location
    Ryton
    MS-Off Ver
    Office 2013
    Posts
    49

    Re: toggle button problem

    That worked a treat thankyou

    I wondered if there was a way of making the toggle buttons Green when in the clicked state

  5. #5
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: toggle button problem

    Untested but shooting from the hip I'd think as simple as:

    Please Login or Register  to view this content.
    Play around with that.

+ 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. Toggle Button on/off problem
    By D_N_L in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-28-2014, 05:40 AM
  2. 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
  3. Replies: 1
    Last Post: 02-13-2014, 10:55 PM
  4. [SOLVED] Toggle Button 'State' Problem on Workbook Open
    By HangMan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2012, 06:35 AM
  5. 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