show hide row if

Wanna Learn

Guest

Posts: n/a

15th May 2009

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

« Text - pull a text cell where if cell a=cell b | Fill in Blanks with immediately above cell value »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to hide "Image1" when you hide Row	Alex St-Pierre	Microsoft Excel Programming	0	2nd Oct 2009 02:56 PM
Clicking Show/Hide Button still can't hide the arrows-formatting m	=?Utf-8?B?Y3V0ZSBtb3VzZQ==?=	Microsoft Word Document Management	1	10th Jun 2007 04:27 AM
TOC field codes will not hide when commanded by HIDE/SHOW tile.	=?Utf-8?B?UkVDT05TTUlUSA==?=	Microsoft Word Document Management	1	22nd Feb 2007 10:24 PM
Hide/Show a row based on data entry in another row	=?Utf-8?B?aXZvcnlfa2l0dGVu?=	Microsoft Excel Programming	7	17th May 2006 12:08 PM
Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B	Hannes Heckner	Microsoft Excel Programming	1	5th Mar 2004 10:10 AM