Hide or unhide a cell base on text in a different cell - Either VBA or formula solution.

[Liam_1988]

Hi,

I've been using VBA for about 6 months or so (hobbyist). I'm currently working on a workbook for my job and I'm completely stuck.

X	A	B	C	D
1​	Sent By:
2​	Date Sent:
3​	Method:		Tracking #:

I have the above in place. I'm trying to have it so that C3 & D3 are hidden unless B3 (which has a Data Validation list assigned to it) says "Postal".

I don't mind if this achieved with a Formula or VBA.

Please Please help it's driving me crazy!

 

[Fluff]

In what way doesn't that 1st bit of code work?

 

[Liam_1988]

I'm getting this:

In what way doesn't that 1st bit of code work?

 

[Fluff]

Did you put that code into the relevant sheet module?

 

[Liam_1988]

Yeah this will be he only macro that I'll be running so it's Module 1.

Did you put that code into the relevant sheet module

 

[Fluff]

It needs to go in the sheet module, not a standard module.
Right click the tab of the sheet you want it to work on & click view code.
Paste the code into the window that opens. The code will run automatically when B83 is changed manually

 

[Liam_1988]

It needs to go in the sheet module, not a standard module.
Right click the tab of the sheet you want it to work on & click view code.
Paste the code into the window that opens. The code will run automatically when B83 is changed manually

Right ok sorry yes that makes sense. Sorry like I said I'm a hobbyist.

Just a quick question. Is there a run condition other than the content of D84? I was hoping it was automatic.

 

[Fluff]

With the code you showed in post#10

Private Sub Worksheet_Change(ByVal Target As Range)
  If Target.CountLarge > 1 Then Exit Sub
  If Target.Address(0, 0) = "D83" Then
     Rows(87).Hidden = Not Target.Value = "Postal"
  End If
End Sub

Row 87 will automatically hide/unhide when the value in D83 is changed.

Is that not what you want?

 

[Liam_1988]

I wanted row 87 to be hidden at all times unless D83 contains the term "Postal" whihc would trigger row 87 to become unhidden.

 

[Fluff]

In that case just hide row 87, then if D83 is changed to Postal it will unhide & if D83 is then changed to anything other than Postal it will hide again.

 

[Liam_1988]

That's not worked Fluff but thanks for your help anyway.