|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 15th, 2009, 05:01 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
show hide row if
Hello Scenario - Form - when the form is opened F6 is Blank and is a
dropdown Row 17 is not hidden now if F6 says Distributor I want to hide Row 17 otherwise row 17 show not be hidden Below is my code- but it does not work Private Sub Worksheet_Change(ByVal Target As Range) With Target If .Address "$F$6" Then Exit Sub If .Value = "Distributor " Then Rows(17).Hidden = True ElseIf .Value = "Customer" Then Rows(17).Hidden = False ElseIf .Value = " Office" Then Rows(17).Hidden = False ElseIf .Value = "Demo " Then Rows(17).Hidden = False End If End With End Sub thanks in advance 
|
|
#2
May 15th, 2009, 05:23 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
show hide row if
In your code there is a space after Distributor ("Distributor "). Remove the
space or TRIM() the value If this post helps click Yes --------------- Jacob Skaria "Wanna Learn" wrote: Hello Scenario - Form - when the form is opened F6 is Blank and is a dropdown Row 17 is not hidden now if F6 says Distributor I want to hide Row 17 otherwise row 17 show not be hidden Below is my code- but it does not work Private Sub Worksheet_Change(ByVal Target As Range) With Target If .Address "$F$6" Then Exit Sub If .Value = "Distributor " Then Rows(17).Hidden = True ElseIf .Value = "Customer" Then Rows(17).Hidden = False ElseIf .Value = " Office" Then Rows(17).Hidden = False ElseIf .Value = "Demo " Then Rows(17).Hidden = False End If End With End Sub thanks in advance
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
