Unhide rows as VBA event trigger

[cbrown6305]

I have a text box that unhidden via a sub called "unHideTextBox". I want this sub triggered when unhiding a certain row. Practically, when a user opens the workbook, the row would be hidden, when they click the "+" to unhide the row, the text box becomes visible. When they hide the row, the text box goes back to being invisible.

This is what i have, but it is not triggering the text box...


Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Row = 35 Then
If Rows("35:35").EntireRow.Hidden = False Then
Call unHideTextBox
End If

End If

End Sub

 

[StephenCrump]

I'm not clear what you intend to happen, but your Sub will call unHideTextBox if:

- the user changes something on the worksheet, and
- the first row of the changed cell(s) is 35, and
- row 35 is not hidden.

When you say click the "+" to unhide the row, are you talking about grouped rows? While a grouped row doesn't show, that doesn't mean it's .Hidden

And grouping/ungrouping won't trigger a Worksheet_Change.

 

[RoryA]

Please take a minute to read the forum rules, especially on cross-posting, and then update your thread with the relevant links. Thanks.