Results 1 to 3 of 3

Thread: Create a check box macro

  1. #1
    Seeker hlaur's Avatar
    Join Date
    Feb 2019
    Posts
    7
    Articles
    0
    Excel Version
    2016

    Create a check box macro



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I'm not sure this is the right category to post this in, and I'm a bit new to excel so please be patient.

    At my last work place, they had a spreadsheet to log the information from work permits. I am trying to recreate this system for another project and am unsure how to do it.

    Let's say there are 3 work categories:
    (1) Hot work
    (2) Diving
    (3) Excavation

    There is a button on the screen labeled "input".
    When you click on the button, a check box appears with all 3 work categories listed.
    You check "diving" and click "enter"
    The check box closes, and the value of the "diving" column increases by one.

    One or more categories can be checked at a time.

    Any help would be appreciated!
    Thanks so much

  2. #2
    Conjurer alansidman's Avatar
    Join Date
    Oct 2018
    Location
    Steamboat Springs
    Posts
    193
    Articles
    0
    Excel Version
    2019
    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.


    Remember to desensitize the data.

  3. #3
    Seeker hlaur's Avatar
    Join Date
    Feb 2019
    Posts
    7
    Articles
    0
    Excel Version
    2016
    Quote Originally Posted by alansidman View Post
    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.


    Remember to desensitize the data.
    ExcelGuru1.xlsx

    Sample file is attached.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •