multiple worksheet_change

  1. N

    combine multiple worksheet_Change events

    Hi there can someone help. I have a sheet where I want on a worksheet change event to..... 1) convert a range of cells to uppercase 2) allow the entry in a different range of cells of time in the format hhmm (without the colon) this is what I have now but here is the problem I can only get...
  2. B

    Auto Filtering all additional Sheets based on one cell value in Sheet 1

    I am looking for VBA code that will filter 30+ Excel tables starting with Sheet2. Each sheet will contain a table with a date range in column A starting with the header row being row 1. I am looking to enter a date into Sheet1 in cell B2. I'd like to add a Command Button to Sheet 1 to run...
  3. S

    Combine multiple "Private Sub Worksheet_Change(ByVal Target As Range)"

    Hi, I need to combine following codes which will change the attributes of the cell as well as worksheet. And I need it in single worksheet. Formula 1 Private Sub Worksheet_Change(ByVal Target As Range) If Range("I6").Value = "NO" Then Rows("52:55").EntireRow.Hidden = True...
  4. N

    Apply VBA Code to All Worksheets

    Hello, The help I've found on this subject has been great, but now I think my problem is more specific. I have the following code applied to one worksheet (right click sheet tab and click "view code") and it works very well: Private Sub Worksheet_Change(ByVal Target As Range) If...
  5. S

    Multiple "Worksheet_Change" routines

    here is my code, and I need help either combining the two Worksheet_Change routines or getting another way to do this. Thanks in advance Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address <> "$I$2" Then Exit Sub If Target = "GB" Then ActiveSheet.Unprotect...

Some videos you may like

This Week's Hot Topics