+ Reply to Thread
Results 1 to 5 of 5

ActiveX CheckBox True or false send value to other sheet cell value and add data

  1. #1
    Registered User
    Join Date
    01-15-2016
    Location
    Oslo, Norway
    MS-Off Ver
    2013
    Posts
    3

    ActiveX CheckBox True or false send value to other sheet cell value and add data

    Hi you all,
    First time posting on a forum so have that in mind

    I really need som help with a VBA code.

    I have a Woorkbook that includes an overview tab and a Create New button (this works ok), when creating new a ne Sheet is added to the workbook with a specific value as sheet name and that value is also added to first empty sell in column C on sheet "Overview" and to cell "C:4" in the new sheet.

    The new sheet is a copy from a Template (Sheet called Datasheet) and have a list of checkboxes on it.
    The name of these text boxes are also headlines on the overview tab and are supose to show the value true or false.

    So to my question:
    When I click one of the textboxes in the sheet i want to add the value to the same row as were the data in cell C:4 is and to the cell with the headline of the checkbox.

    I`m adding a word doc trying to explain the problem. I can send the workbook if needed, nothing secret.

    Thank you all so much for helping me out Checkboxproblem1.docx

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: ActiveX CheckBox True or false send value to other sheet cell value and add data

    You could send the workbook instead of a word doc.

  3. #3
    Registered User
    Join Date
    01-15-2016
    Location
    Oslo, Norway
    MS-Off Ver
    2013
    Posts
    3

    Re: ActiveX CheckBox True or false send value to other sheet cell value and add data

    Hi again

    Lucky me, I found a good forum, that tells me what to do so that you can help me. I attached the original doc.

    Thank you all
    Attached Files Attached Files

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: ActiveX CheckBox True or false send value to other sheet cell value and add data

    You can copy & paste this in your Datasheet module
    Right click on the sheet tab and select View Code
    1-18-2016 6-40-56 AM.jpg

    Copy the sheet then change C4 to activate the code.



    Please Login or Register  to view this content.
    In a regular module you could use this code to copy your sheet.
    Please Login or Register  to view this content.
    When you copy the sheet, the code goes with it.

    As far as your check boxes go, I am not sure what you want.
    Last edited by davesexcel; 01-18-2016 at 08:49 AM.

  5. #5
    Registered User
    Join Date
    01-15-2016
    Location
    Oslo, Norway
    MS-Off Ver
    2013
    Posts
    3

    Re: ActiveX CheckBox True or false send value to other sheet cell value and add data

    Thank you so much daveexcel,

    I totaly understand that you don`t get my swedish/norwegian drabbel so don`t worry

    Thank you for the help so far, I will attach a small video for what I want to do and the new code, after I put your code in.

    New info, video was not allowed to attach (MP4 file). So it`s in a Zip file (that was allowed, but don`t know if you want to open zip files).

    So I will try to explain.
    when I have created the new tab, with all the checkboxes on it. I want to tick them on/off and I want the result to show on the oerwiev tab on the same row as the Property code and in the same column named as the checkbox in the new tab.

    Again, thank you
    Attached Files Attached Files

+ 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. Replies: 3
    Last Post: 09-28-2014, 08:14 PM
  2. [SOLVED] Easy Macro needed to change some, not all, activeX checkbox to False or True
    By caliskier in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-07-2014, 12:51 PM
  3. [SOLVED] Use checkbox on sheet ('true' or 'false') to decide if run macro
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-01-2013, 09:12 PM
  4. [SOLVED] Removing the True/False within cell when linked to Checkbox
    By MadelynL in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-20-2013, 03:04 PM
  5. ActiveX Checkbox = True then Copy 2 cells to other Sheet
    By kyros in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-31-2012, 07:49 AM
  6. Filling in a cell based on Checkbox true/false
    By Rivalwon in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-10-2007, 07:07 PM
  7. Checkbox: If true all others are false?
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-03-2007, 11:57 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