MsgBox that has a message that comes from a dynamic cell (it changes)

How to use MsgBox that has a message that comes from a dynamic cell (its value is changing if we add new data)?

And how can I create a MsgBox with date that pops out when the file is open?

Thanks in advance!

Does this help?

Please Login or Register  to view this content.

It is the two things separate! And it didnīt work...

Maybe:

Please Login or Register  to view this content.

Not too sure what you're after this uses Cell A1 as the changing value cell. If you need further please explain.

Please Login or Register  to view this content.

That helped a lot!!! Thanks!

You're welcome. Glad to help out and thanks for the feedback. If that resolves the issue please mark this thread as solved.