General discussion

  • Creator
    Topic
  • #2332548

    EXCEL Checkbox 2

    Locked

    by ipctrain ·

    In EXCEL – ‘Sheet 1’, I create a 3 checkboxes using the checkbox tool from the toolbar. In the cell next to each checkbox, theres a corresponding value.

    Depending on which checkbox the user selects the corresponding value in the adjacent cell should be displayed automatically on ‘Sheet 2’.

    What is the VB code or macro that can accomplish this?

All Comments

  • Author
    Replies
    • #3515080

      EXCEL Checkbox 2

      by dklippert ·

      In reply to EXCEL Checkbox 2

      Use the controls on the Form toolbar. Right click and look at Format Control on the Control tab. You might have to use an if statement to display what you want. If you want the values to be exclusive, use Option buttons rather than check boxes.

      • #3498793

        EXCEL Checkbox 2

        by ipctrain ·

        In reply to EXCEL Checkbox 2

        THANKS…
        You got me in the right direction. Hence, I began playing with the ‘Cell Link’ Prompt within the Control Tab of the Properties Dialog box for the checkbox(es).

        Also THANKS for the tip on OPTION BUTTON versus Checkboxes. MuchBetter.

    • #3498792

      EXCEL Checkbox 2

      by ipctrain ·

      In reply to EXCEL Checkbox 2

      This question was closed by the author

Viewing 1 reply thread