+ Reply to Thread
Results 1 to 9 of 9

Need Help with Triggering Checkboxes to Other Cells

  1. 03-09-2012, 12:18 PM #1
    Jen L
    Jen L is offline
    Registered User
    Join Date
    03-09-2012
    Location
    Massachusetts
    MS-Off Ver
    Excel 2007
    Posts
    9

    Need Help with Triggering Checkboxes to Other Cells

    Excel Help Needed.jpgHello, I created an Expense Report for my company and we want it to have checkboxes for Billable & Indirect at the top, and then when someone checks Billable, in a separate column "Expense Category," only the billable items come up in the dropdown list, and when someone checks Indirect, only the indirect items come up in the dropdown list. I know how to make the dropdown lists; I just need to figure out how to get the checkboxes to trigger to the expense category cells. I'm attaching a picture; hopefully it helps convey what I am trying to explain. I would really appreciate any help with this! Thank you!
    Last edited by Jen L; 03-09-2012 at 03:18 PM.
    Reply With QuoteRegister To Reply
  2. 03-09-2012, 12:27 PM #2
    icestationzbra
    icestationzbra is offline
    Forum Expert icestationzbra's Avatar
    Join Date
    01-07-2004
    MS-Off Ver
    2007, 2010
    Posts
    1,421

    Re: Need Help with Triggering Checkboxes to Other Cells

    attach a sample excel file with what you are needing to do...
    Reply With QuoteRegister To Reply
  3. 03-09-2012, 12:31 PM #3
    Jen L
    Jen L is offline
    Registered User
    Join Date
    03-09-2012
    Location
    Massachusetts
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Need Help with Triggering Checkboxes to Other Cells

    I am attaching the Expense Report. Thanks!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 03-09-2012, 01:20 PM #4
    mahju
    mahju is offline
    Valued Forum Contributor mahju's Avatar
    Join Date
    11-27-2010
    Location
    Pakistan, Faisalabad
    MS-Off Ver
    Excel 2010 plus
    Posts
    730

    Re: Need Help with Triggering Checkboxes to Other Cells

    Hi
    Check this code under the click event of checkbox1

    Please Login or Register  to view this content.
    See attached file also where both checkboxes works

    hope it helps

    Regards
    Attached Files Attached Files
    Mark the thread as solved if you are satisfied with the answer.


    In your first post under the thread tools.

    Mahju
    Reply With QuoteRegister To Reply
  5. 03-09-2012, 03:06 PM #5
    Jen L
    Jen L is offline
    Registered User
    Join Date
    03-09-2012
    Location
    Massachusetts
    MS-Off Ver
    Excel 2007
    Posts
    9

    Talking Re: Need Help with Triggering Checkboxes to Other Cells

    This is a huge help! Thank you so much!
    Reply With QuoteRegister To Reply
  6. 03-09-2012, 04:22 PM #6
    icestationzbra
    icestationzbra is offline
    Forum Expert icestationzbra's Avatar
    Join Date
    01-07-2004
    MS-Off Ver
    2007, 2010
    Posts
    1,421

    Re: Need Help with Triggering Checkboxes to Other Cells

    i realise that this issue is resolved, but i could not help but pipe in because i am not a big fan of VB macros...

    please find attached another attempt at this sans macros.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 03-13-2012, 11:28 AM #7
    archer09
    archer09 is offline
    Registered User
    Join Date
    03-11-2012
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Need Help with Triggering Checkboxes to Other Cells

    Quote Originally Posted by icestationzbra View Post
    i realise that this issue is resolved, but i could not help but pipe in because i am not a big fan of VB macros...

    please find attached another attempt at this sans macros.
    This is really helpful - just one question: how did you get cell L2 to toggle between "1" and "2" depending on which radio button is selected? Thanks.
    Reply With QuoteRegister To Reply
  8. 03-13-2012, 11:35 AM #8
    icestationzbra
    icestationzbra is offline
    Forum Expert icestationzbra's Avatar
    Join Date
    01-07-2004
    MS-Off Ver
    2007, 2010
    Posts
    1,421

    Re: Need Help with Triggering Checkboxes to Other Cells

    @archer09:

    when you insert a 'Form Controls' Option Button, it is automatically assigned a "Button ID". whenever an Option Button is selected, that particular button's ID gets set in the Linked Cell (Cell Link).
    Reply With QuoteRegister To Reply
  9. 03-15-2012, 07:19 PM #9
    archer09
    archer09 is offline
    Registered User
    Join Date
    03-11-2012
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Need Help with Triggering Checkboxes to Other Cells

    Got it. Thanks for clarifying.
    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)

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