| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
TextBox value to hide a row in another worksheet
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
TextBox value to hide a row in another worksheet
hi,
see your post under gen question for reply Regards FSt1 "TDC" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to hide/show a textbox depending on cell value | Excel Programming | |||
| How to hide a textbox | Excel Programming | |||
| VBA to show or hide columns in one worksheet conditioned on value in other worksheet | Excel Programming | |||
| How do I hide a worksheet in Excel and use a password to un-hide . | Excel Discussion (Misc queries) | |||
| hide a textbox on a userform? | Excel Programming | |||
Hybrid Mode
