Prompt if statement

[Aliw267]

Hi,

I want to be able to run a continuous piece of code that is cell h5 is greater than h4 a prompt is shown.

h4 is constant however h5 takes values from other cells so using data validation does not work as if does not refresh every time new data is entered.

All I need is something like if h5>h4 then prompt... else nothing but I have no experience on VBA.

Thanks,
Ali

[royUK]

Can't you use Conditional Formatting?

[Aliw267]

Conditional formatting will only allow me to change the format of the cell, I want a prompt to come up on the screen warning the user that the data entered takes the value of the cell over the allowed value.

[royUK]

Conditional formatting will only allow me to change the format of the cell, I want a prompt to come up on the screen warning the user that the data entered takes the value of the cell over the allowed value.

Which would only work if the user enabled macros, so you would need to ensure that this happens

A warning message would interrupt any calculating, macros etc until OK is pressed.

Please Login or Register  to view this content.

[Aliw267]

Thanks for this.

[royUK]

No problem