InputMsgon/Off for ALL worksheets?

  • Below are two codes, they TURN ON and TURN OFF the Data Validation Messages.


    I have each one attached to a button on one worksheet. It is only working for the current worksheet, I would like this for all worksheets.


    Thank you.


  • Re: InputMsgon/Off for ALL worksheets?


    Try this




    Kieran

  • Re: InputMsgon/Off for ALL worksheets?


    Yes this works. Thanks You...However I am getting a pop up of the "Red-X 400" after I enable each one. Other than the pop up everthing is great.

  • Re: InputMsgon/Off for ALL worksheets?


    Could be a bit tidier, I would suggest just using the same code and pass a true/false parameter to turn on/off:



    Just call the code like so:


    Code
    Private Sub CommandButton1_Click()
        InputMsgShow True '// Or 'False' to turn off message
    End Sub
  • Re: InputMsgon/Off for ALL worksheets?


    Try this

    Code
    Private Sub ToggleButton1_Click()   
    If ToggleButton1.Value = True Then
          'do something     
       ElseIf ToggleButton1.Value = False Then
          'do something     
       End If
    End Sub
  • Re: InputMsgon/Off for ALL worksheets?


    maybe just

  • Re: InputMsgon/Off for ALL worksheets?


    You don't need to loop through the cells


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!