Display formula result in a popup.

[vizmeister]

Hello,
I would like to know how do I popa result, when I put some data any
where in the sheet and when I run a macrom it will run a formula n
display the result in a popup.

Current process is I put the date in C6 column and the result is
displayed in a cell.
I want to remove the dependant on those two cell, such that when I
type the date any where and run the macro, it must give me a popup.

Here is the formula: -
=(IF(MOD((WEEKNUM(C6,1)),4)=0,(QUOTIENT((WEEKNUM(C6,1)),4)),
((QUOTIENT((WEEKNUM(C6,1)),4)+1))))&"X"&(IF((MOD((WEEKNUM(C6,1)),
4))<>0,(MOD((WEEKNUM(C6,1)),4)),(MOD((WEEKNUM(C6,1)),4)+4)))

if I type 1/15/2008 in anycell and run a macro, it must give me 1X3 as
a popup.

Thanks