Welcome Guest.

3Answers

Excel form three how to write code. . .

Asked by: Amy Wright 172 views IT September 15, 2018

Excel form three how to write code. . .

3 Answers

  1. +3Votes  

    Double-click the command button on the form and insert the following code.
    Private Sub CommandButton1_Click()
    If OptionButton1.Value = True Then
    Range("Name1").Select
    ElseIf OptionButton2.Value = True Then
    Range("Name 2").Select
    ElseIf OptionButton3.Value = True Then
    Range("Name3").Select
    End If
    End Sub

    Thomas Martin- September 15, 2018 |

  2. +1Votes  

    3, enter one In the month, how many days of the month are output.
    Not desirable. If it is February, you must bring the year! Otherwise the result can only be: 28 or 29 days in February.

    Amanda Roberts- September 16, 2018 |

  3. +2Votes  

    Nothing written upstairs

    Elizabeth- September 16, 2018 |