Stop a Macro if Criteria not met and Show Error Message

[m3hool]

Hello!

I'm fairly new to VBA and have a question, something probably quite simple to fix

I am trying to work a simple Macro which looks at the item selected on a dropdown (through data validation) for acceptance of Terms and Conditions. If agreed, I want to unhide another tab, if disagree selected, then an error message should be shown and the tab should not be unhidden.

I have managed to get the error message for disagree, however it still unhides the tab any advice here will be greatly appreciated.

Please Login or Register  to view this content.

Many thanks,
Mez

[AB33]

Mez,
Please code tags with your code.

You have Sub Worksheet_Change, but where is the target?

You need to call Sub unhide() from Sub Worksheet_Change

[JasperD]

Of course, unhiding a tab before you check if they actually agreed is never a good idea...
Try this :

Please Login or Register  to view this content.

Please click the * below if this helps

[m3hool]

Brilliant thank you so much it worked!

[zbor]

Again:
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code in [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

[zbor]

JasperD:
Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction then send a private message to them asking for clarification. Do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc

[m3hool]

Apologies, now corrected.
Mez