+ Reply to Thread
Results 1 to 5 of 5

[SOLVED] Userform Checkbox Controls Other Checkboxes in other sheets

  1. #1
    Registered User
    Join Date
    05-27-2021
    Location
    USA
    MS-Off Ver
    365
    Posts
    9

    Question [SOLVED] Userform Checkbox Controls Other Checkboxes in other sheets

    Hi
    I'm new here and i wanted to see if someone could possibly help me. I'm trying to create a userform with various questions and checkboxes. i need a way to store the answers and would like to store them as checkboxes on a different sheet as well. is it possible for a checkbox on a userform to check a checkbox in say sheet2? Also is there a way to enter text in the userform textbox and have that populate in sheet2 as well (not in a textbox but in an actual cell)? I know I have to do some vba coding but I cant seem to get the right combination to get it to work. Is this possible or is there a better way? Thank your or your help!
    Attached Images Attached Images
    Last edited by jester113; 06-04-2021 at 12:53 PM.

  2. #2
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: Userform Checkbox Controls Other Checkboxes in other sheets

    Userform Code
    Please Login or Register  to view this content.
    Sheet1 code
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Croweater; 05-28-2021 at 04:17 AM.

  3. #3
    Registered User
    Join Date
    05-27-2021
    Location
    USA
    MS-Off Ver
    365
    Posts
    9

    Re: Userform Checkbox Controls Other Checkboxes in other sheets

    Hi Croweater
    This is perfect! Thank you so much for this! IT's exactly what I need! :D

  4. #4
    Registered User
    Join Date
    05-27-2021
    Location
    USA
    MS-Off Ver
    365
    Posts
    9

    Re: Userform Checkbox Controls Other Checkboxes in other sheets

    Hi Croweater
    WHen i try to do that with other checkboxes it doesn't work. is there something I'm missing? I created a new checkbox, copy pasted the code and changed the name of the checkbox from 1 to 2 to 3 for the 3 boxes I had on screen. but when I check the userform boxes, it doesn't reflect on the sheet


    EDIT: nevermind I figured it out! its perfect thank you so much!
    Last edited by jester113; 05-28-2021 at 01:47 PM.

  5. #5
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: Userform Checkbox Controls Other Checkboxes in other sheets

    You're welcome jester. Glad you figured it out.

+ 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 Checkboxes Output to Multiple Sheets
    By bgriffin4316 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-04-2020, 01:26 PM
  2. [SOLVED] Userform Checkbox - Multiple Sheets
    By Frankinstyyn in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 06-13-2018, 07:58 AM
  3. [SOLVED] Checkboxes - How to check/uncheck other checkboxes based on another checkbox
    By brooklyn_87 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 10-27-2017, 01:20 PM
  4. Select All Checkboxes Checkbox That Also Calls Checkbox Macros
    By Intervigilium in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-23-2015, 06:41 PM
  5. Print Sheets based on checkboxes in UserForm, Checkboxes also control another macro
    By krackaberr in forum Excel Programming / VBA / Macros
    Replies: 34
    Last Post: 03-05-2013, 11:12 AM
  6. Replies: 2
    Last Post: 10-19-2011, 09:45 AM
  7. Dynamically create and Place Controls such as CheckBoxes,Text-Boxes in a UserForm
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 35
    Last Post: 05-11-2011, 11:34 AM

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