check box vba write value

  1. M

    True or False outcome to result in a certain cell.

    I'm trying to get a tick box via symbols in a certain cell based off the input sheet which has check boxes. The outcome is displayed in "T1" as True or False based on the check box being selected and what I'd like on another sheet depending on the output, is to add ü = True or û = False to a...
  2. D

    Check box Crosstab Query

    Hi, I am using a crosstab query to present an Master Production Schedule (MPS). I would like to be able to add check boxes into my form that would allow users to filter the data by Stage. There is 6 stages in the data. How do I go about this as I am a beginner at excel. Should I use VBA or...
  3. E

    Macro Help Regarding Check Boxes

    Hello all! I am currently creating a spreadsheet (excel 2010) where I have 2 recorded macros that are assigned to 1 checkbox1 in M6. The checkbox when clicked moves C6:L6 from "Warehouse to Rig" tab to "Rig to Well" tab and deletes when unclicked. How can I create multiple check boxes like the...
    • ExcelLost88
    • Thread
    • check box multiple check box vba write value macro - help vba & excel 2010
    • Replies: 2
    • Forum: Excel Questions
  4. E

    Macro code to show or hide cells by checking box

    Hi- I'm trying to show rows when a check box is clicked, otherwise the rows should be hidden. This is the code I have so far. Private Sub CheckBox1_Click() If CheckBox1.Value = True Then Rows("15:15").Select Selection.EntireRow.Hidden = False If CheckBox1.Value = False Then...
  5. B

    Check box VBA write a value

    Hello everyone, This is very basic, but just learning... I have a checkbox that hides a range of columns when deselected and unhides the range when checked. I also want the code to write a value (1) to a cell when hidden and change the value to another value (0) when unhidden. The range is...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top