TextBox value to hide a row in another worksheet

G

Guest

I am trying to use a TextBox value to determine if a row on another
spreadsheet should be visible or not. I have the following:

Private Sub Worksheet_Change(ByVal Target As Range)

If Worksheets("Input Page").TB21.Value = 0 Then
Worksheets("Summary Report").Rows(19).EntireRow.Hidden = True
Else
Worksheets("Summary Report").Rows(19).EntireRow.Hidden = False
End If
End Sub

It works if I manually override the value in the TextBox's linked cell; say
AC49, but will not if I simply change the value in the TextBox itself like I
would like the user to do.

Any suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text Box value to hide a row in another worksheet 4
Hide Next row based on Cell Value 3
Macro to Hide Rows 5
macro 2
Hide/Show Rows based on Cell Value with Data Validation 3
create a loop so i don't have to keep retyping? 4
conditional row hide 2
Hide rows issue 3

Top