VBA Hide if cell value = TEXT not working

[carlandtina02]

Hi There,

Im trying to hide and unhide certain rows depending on what value is in cell F8, but cant seem to get the below code to fire
The code is in the the sheet i want it to work in.

Could someone tell me what I'm doing wrong?

Cheers Folks

Please Login or Register  to view this content.

[Akuini]

You put End If in the wrong place.
And you can remove the 'select' part.
Try this:

Please Login or Register  to view this content.

[carlandtina02]

Hi Akuini,

Thanks for that

The code only seems to work when I run it from the developer, it doesn't fire automatically when I change the value from the drop down list in cell F8?

Regards
Carl

[sourabhg98]

Right click on your sheet name >> view code >> paste the following code there-

Please Login or Register  to view this content.

This should fire automatically when F8 changes.

[Akuini]

Ah, Sourabh already got the answer. I deleted my post.

[carlandtina02]

Hi Guys,

Thanks for your efforts with this,

The code doesn't seem to be working, I've attached a sample for a some clarity.


Thanks
Carl

[carlandtina02]

Hi sourabhg98,

I cant seem to get the code to work, can you see if i'm doing something wrong

Thanks
Carl

[sourabhg98]

Hi

You cant add a new macro with the name Worksheet_Change1.
Only macro named with Worksheet_Change is triggered when value is changed.
Combine both the codes and use only one like this-

Please Login or Register  to view this content.

[carlandtina02]

Hi sourabhg98,

That's great, it works like a treat

Thanks Again
Carl