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".
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.Please Login or Register to view this content.
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
Bookmarks