1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel: Checkboxes

Discussion in 'Business Applications' started by sk0101, Jul 8, 2008.

Thread Status:
Not open for further replies.
Advertisement
  1. sk0101

    sk0101 Thread Starter

    Joined:
    Nov 8, 2007
    Messages:
    277
    Hi,

    Please see the attached file.

    In my Output Tab, I want to check mark a checkbox depending on the Data Tab.
    I want to write the code in VBA,

    Here is my VBA code:
    Sub Auto_Open()
    Dim wk As Excel.Workbook
    Set wk = Application.ActiveWorkbook
    'Not sure how to execute the checkboxes. Please advice, Thank you.
    Set wk = Nothing
    End Sub

    Thank you
     

    Attached Files:

  2. Aj_old

    Aj_old

    Joined:
    Sep 24, 2007
    Messages:
    869
    Try my uppload!
    I change a little your work book, it work for 0 and 1 not for empty and 1, I put data validation, so in the B2 cell user could input only 1 and 0!
    Each time you change the value in b2, on the second sheet it cheks the checkbox you need!
    i removed the check boxes you had on the cheet and changed them with others!
    Good luck!
     

    Attached Files:

  3. sk0101

    sk0101 Thread Starter

    Joined:
    Nov 8, 2007
    Messages:
    277
    Hi AJ,
    Thanks for your help,

    I wanted to see the propeties of the checkboxes, by right clicking on the cb using my mouse. But It doesn't let me.

    - I want to see where you named the cbxes. "cbxYes" & "cbxNo"
    - When Private Sub Worksheet_Change(ByVal Target As Range) gets executed? How does it know..
    - Could you also tell me how you created a dropdown list.

    Thank you
     
  4. Aj_old

    Aj_old

    Joined:
    Sep 24, 2007
    Messages:
    869
    What version of office do you use?
     
  5. sk0101

    sk0101 Thread Starter

    Joined:
    Nov 8, 2007
    Messages:
    277
    2007.
    Thanks,
     
  6. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/728542

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice