View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Norbert[_4_] Norbert[_4_] is offline
external usenet poster
 
Posts: 52
Default Pop up message needed dependend on certain conditions

In cell range C7:C14 the cells can have different values (1, 2, 3, .....)
In case there is only 1 kind of value (only value 1, or only value 2) I'd like to get a message (pop up, or in a certain cell), which says "blablabla"
I'd like to get different messages for different values, though.

For example: C7 = 1
C8 = 1
C9 = 1
Message to pop up: "Please be aware that pattern repeat to be divisible by 4"

C7 = 2
C8 = 2
C9 = 2
C10 = 2
Message to pop up: "Please be aware that pattern repeat to be divisible by 12"

For example: C7 = 1
C8 = 2
C9 = 1
No message to pop up