VBA Prompt Messag Box with IF Function

[Keibri]

Hu guys,

I was wondering whether someone can please assist me with the below.

I have a vba code which prompts out a message box based on a value in cell A1 and which then activtes another Sheet," Sheet 2".

Please Login or Register  to view this content.

I would like to amend this slightly so that if the value in cell A1 is greater or equal than 1, a message box will still appear and as soon as the user hits 'OK', the VBA code will stop running.

Sheet 2 should only be activated, if the value in cell A1 is 0 (i.e. less than 1).



Would appreciate all your kind help

Many thanks

Keibri

[xladept]

Maybe:

Please Login or Register  to view this content.

[Keibri]

Cheers!!! Thanks a lot xladept. That did the trick much appreciated !

[xladept]

You're welcome and thanks for the rep!