Auto created messages

[Manos]

Dear all,

There is anyway that i can create in the excel workbook to create a message
that will pop up automatically?

For example all the sheets include information of finance.
I want to pop up to a message to the user when there is a specific period of
time. In the cover sheet there is the month. So I want when he put March to
see a message that told him which sheets should be fill in.
There is anyway to do it with the help of comments or I have to use visual
basic?

Thanks in advance
Manos

 

[Don Guillett]

In a macro, something like

if ucase(range("a1"))="MARCH" then msgbox "Do This"

 

[James]

Answer 1: No. The only reason a message displays is
because the programmer anticipated an event to occur and
it did.

Answer 2: You will most likely have to learn or use VBA.
The only way I can see you using comments would be to
create a sheet with the 12 months of year in it with
embedded comments for each month. If you want the user to
input the month so the proper instructions for the input
month can be relayed to the user, you will have to use VBA.

HTH, James

 

[Katherine Coombs]

Hi Manos,

If you aren't comfortable using macros, then I'd suggest using
Data-->Validation and using the Input Message tab. This won't be in the
form of a pop-up, but it will appear almost like a comment whenever the user
moves to that cell. That might do the trick?

HTH,
katherine