+ Reply to Thread
Results 1 to 3 of 3

Unable to get Toggle Button to function

  1. #1
    Registered User
    Join Date
    04-26-2014
    Location
    Utah
    MS-Off Ver
    Excel 2311 Build 16.0.17029.20028 64 bit
    Posts
    52

    Unable to get Toggle Button to function

    This is what I want:
    Toggle Button on top of cell G440
    Non-depressed button label is "Not Included" and cell content = "N" (This cell value is used in a formula)
    When depressed, button label changes to "Included" and cell content = "Y" (This cell value is used in a formula)

    I clicked the toggle button in the Active X area and inserted it over cell 440

    In Design mode, I selected the toggle button and right clicked and selected the View Code and entered this code:

    If ToggleButton1.Value = True Then
    'G440="No"
    Else
    'G440 = "Yes"
    End If

    Selected 'Run' Sub/user form and closed the code box
    When I selected the toggle button, it showed as depressed, but here was no change in cell 440

    1. What code should I use?

    2. how do I get the toggle button show a different label when depressed?

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,361

    Re: Unable to get Toggle Button to function

    Try

    Please Login or Register  to view this content.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Registered User
    Join Date
    04-26-2014
    Location
    Utah
    MS-Off Ver
    Excel 2311 Build 16.0.17029.20028 64 bit
    Posts
    52

    Re: Unable to get Toggle Button to function

    Thank you!

+ 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] Out Of Stack Space Error With Toggle Button Clicks - One Problem Button
    By Jenn68 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-11-2019, 10:05 AM
  2. [SOLVED] how do i make a toggle button change other toggle buttons value to false
    By kevinu in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-10-2018, 04:19 PM
  3. Combining separate button functions into one toggle button 2011 office for mac
    By voidcreativ in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-18-2015, 09:28 AM
  4. Toggle Button on Workbook Open - value is True but button not pressed?
    By excelnat in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 07-03-2014, 11:23 AM
  5. 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
  6. Replies: 1
    Last Post: 02-13-2014, 10:55 PM
  7. [SOLVED] Adding .xla button for Toggle Calculation Button
    By Mike in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-19-2005, 09:05 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