+ Reply to Thread
Results 1 to 5 of 5

Toggle button value on userform saved to a sheet

  1. 05-21-2020, 04:16 AM #1
    danny25
    danny25 is offline
    Registered User
    Join Date
    07-02-2018
    Location
    australia
    MS-Off Ver
    2016
    Posts
    60

    Toggle button value on userform saved to a sheet

    Good afternoon all
    I have a toggle button next to a question on a user form i would like to save the status of the button (pressed/unpressed) to the corresponding sheet "NSFCORNER"
    This will form part of a check list
    The toggle button give a nice visual indication to the answer
    TEST1.JPG
    Last edited by danny25; 05-21-2020 at 04:18 PM. Reason: solved
    Reply With QuoteRegister To Reply
  2. 05-21-2020, 04:35 AM #2
    torachan
    torachan is offline
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,302

    Re: Toggle button value on userform saved to a sheet

    see big yellow banner at head of page - instructions, how to upload your workbook.
    cannot manipulate a picture very well with Excel - far simpler to answer with the code.
    torachan.
    Reply With QuoteRegister To Reply
  3. 05-21-2020, 04:47 AM #3
    danny25
    danny25 is offline
    Registered User
    Join Date
    07-02-2018
    Location
    australia
    MS-Off Ver
    2016
    Posts
    60

    Re: Toggle button value on userform saved to a sheet

    Thanks Torachan
    Please find attached a copy of the work book

    Please Login or Register  to view this content.
    Last edited by danny25; 05-21-2020 at 04:52 AM.
    Reply With QuoteRegister To Reply
  4. 05-21-2020, 06:08 AM #4
    zzzeddy
    zzzeddy is offline
    Valued Forum Contributor
    Join Date
    08-03-2012
    Location
    Newcastle
    MS-Off Ver
    Excel 2007, 2010, 2013, 2016, Office 365
    Posts
    467

    Re: Toggle button value on userform saved to a sheet

    Hi

    Perhaps this will help guide you..
    Please Login or Register  to view this content.
    ..I didn't do all of them, but you should get the idea..

    zeddy
    Reply With QuoteRegister To Reply
  5. 05-21-2020, 04:15 PM #5
    danny25
    danny25 is offline
    Registered User
    Join Date
    07-02-2018
    Location
    australia
    MS-Off Ver
    2016
    Posts
    60

    Re: Toggle button value on userform saved to a sheet

    Thanks worked
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to hide and show userform and werksheet with Toggle Nutton and Command Button
    By DawidV in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-26-2017, 07:22 AM
  2. Toggle button inside userform
    By ChipsSlave in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-13-2017, 11:16 AM
  3. 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
  4. 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
  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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1