+ Reply to Thread
Results 1 to 9 of 9

Take CheckBox info, and put Y/N in corresponding box on next sheet

  1. #1
    Registered User
    Join Date
    01-30-2012
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    18

    Take CheckBox info, and put Y/N in corresponding box on next sheet

    Hello all, I appreciate any help. I'm looking for help to setup this workbook. there are two checkboxes on sheet 1, which need to transfer either a yes or a no to sheet 2, then reset. The Y/N needs to go in the corresponding column on sheet 2, which would be todays date. wasnt sure how to manage that. Book1.xlsx

  2. #2
    Forum Guru mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,207

    Re: Take CheckBox info, and put Y/N in corresponding box on next sheet

    The attached file has no checkboxes, dates or anything on sheet2
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  3. #3
    Registered User
    Join Date
    01-30-2012
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Take CheckBox info, and put Y/N in corresponding box on next sheet

    sorry, uploaded it before i saved it. here it is.Book2.xlsx

  4. #4
    Forum Guru
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Take CheckBox info, and put Y/N in corresponding box on next sheet

    Hi robnez,

    Try the attached file, to see if it does what you want.

    I had problems with your Controls, probably because I'm using Excel 2003. Because I'm using
    Excel 2003, you should not use my file, because some Excel features not available in Excel 2003
    may be lost.

    I deleted your controls on Sheet1, and replaced them using a Macro that should work in your version
    of Excel.

    Please note that cell 'F3' on 'Sheet2' is 'Y ' (Y space) and is not counted (from your original).


    ------------------------
    To enable Macros and to Run Macros see the following:
    http://office.microsoft.com/en-us/ex...010031071.aspx
    http://office.microsoft.com/en-us/ex...010014113.aspx
    If help is still needed do a google search for 'youtube excel enable macro' and/or 'youtube excel run macro'.

    To access Visual Basic (VBA) see:
    http://www.ablebits.com/office-addin...a-macro-excel/
    a. Click on any cell in the Excel Spreadsheet (may not be needed).
    b. ALT-F11 to get to VBA.
    c. CTRL-R to get project explorer (if it isn't already showing).
    d. Double Click on a 'Module Name' in 'Project Explorer' to see code for that module ('Sheet1').

    Macro Installation Insructions:
    a. Open this Workbook
    b. Open the Workbook that needs to have the Macro Installed (Target Workbook).
    c. In the Project Explorer, 'Right Click on ModYesNoCheckBoxes associated with this file.
    d. Export ModYesNoCheckBoxes
    e. 'Right Click' on any Module in Project Exlorer for the 'Target Workbook'
    f. Import Module ModYesNoCheckBoxes into the 'Target Workbook'.
    g. Save the 'Target Workbook'.

    Please let me know if you need any changes or help with anything.

    Lewis
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    01-30-2012
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Take CheckBox info, and put Y/N in corresponding box on next sheet

    I downloaded the file and followed your instructions. when I click submit though, it puts in a Y/N in the entire column on sheet 2.

  6. #6
    Registered User
    Join Date
    01-30-2012
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Take CheckBox info, and put Y/N in corresponding box on next sheet

    each box on sheet 2 is a call in essence, and i just need the checkbox to show whether the answer is yes or no on a per call basis.

  7. #7
    Forum Guru
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Take CheckBox info, and put Y/N in corresponding box on next sheet

    I thought you wanted 'Y' or 'N' on the entire column. How would I know which box on Sheet2 to put in the 'Y' or 'N', unless there is a check box for each row? A check box in each row is not difficult to do, if that is what you want.

  8. #8
    Registered User
    Join Date
    01-30-2012
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Take CheckBox info, and put Y/N in corresponding box on next sheet

    I apologize, I guess I should have explained it a little better. I definitely appreciate your help! I do not need an individual check box for each line. Simply when a call comes in, after the call I need to select yes or no. the sheet would then go to the day selected in the dropdown list, and in the next empty cell enter whether Y or N was selected. then reset for the next call. I think i can try to figure it out with what you've given me.

  9. #9
    Forum Guru
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Take CheckBox info, and put Y/N in corresponding box on next sheet

    Thanks for the kind words.

    Now I understand what you wanted. If you have any problems or any more questions please ask.

    Lewis

+ 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. Listbox+checkbox = show info
    By mastaliyev in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-22-2014, 02:52 AM
  2. [SOLVED] Adding Checkbox to populate info from one sheet to another sheet.
    By lenoir in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-10-2014, 10:07 AM
  3. Retrieve Checkbox info (true/false) and save to another file
    By BartDeHertogh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-18-2010, 09:00 AM
  4. Make a sheet with selectable info, send email using info selected
    By DwayneHeight in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2007, 12:18 PM
  5. checkbox on form reset from checkbox on sheet
    By raw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-03-2005, 01:15 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

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.07659 seconds
  • Memory Usage 9,112KB
  • Queries Executed 16 (?)
More Information
Template Usage (34):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (9)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (1)postbit_attachment
  • (9)postbit_legacy
  • (9)postbit_onlinestatus
  • (9)postbit_wrapper
  • (4)showthread_bookmarksite
  • (5)showthread_similarthreadbit
  • (1)showthread_similarthreads
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php 

Hooks Called (49):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • postbit_attachment
  • tag_fetchbit_complete
  • showthread_similarthread_query
  • showthread_similarthreadbit
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1