pop up menu

[jiji]

hi
how can i set a function that gives me my members birthday whenever i open
excel. ex: like in outlook you have a pop up menu when you open it to tell
you happy birthday. does such a function exist in excel or access. thanks

jiana

[Dave Peterson]

I'd use an adjacent column--formatted in big red letters:

=if(a2=today(),"Happy Birthday to: " & b2,"")

With the bday in A2 and the name in B2.

It's not quite a popup message, but it's easier and maybe it'll suffice.

jiji wrote:
>
> hi
> how can i set a function that gives me my members birthday whenever i open
> excel. ex: like in outlook you have a pop up menu when you open it to tell
> you happy birthday. does such a function exist in excel or access. thanks
>
> jiana

--

Dave Peterson

[jiji]

thanks for answering. but something wrong with my formula becase it shows
False once it is today's date. this is my formula: if a1 = today();
b1="happy birthday" if not "". what is the & means?
"Dave Peterson" <petersod@verizonXSPAM.net> a écrit dans le message de news:
43E5F0C7.8EE569E1@verizonXSPAM.net...
> I'd use an adjacent column--formatted in big red letters:
>
> =if(a2=today(),"Happy Birthday to: " & b2,"")
>
> With the bday in A2 and the name in B2.
>
> It's not quite a popup message, but it's easier and maybe it'll suffice.
>
> jiji wrote:
>>
>> hi
>> how can i set a function that gives me my members birthday whenever i
>> open
>> excel. ex: like in outlook you have a pop up menu when you open it to
>> tell
>> you happy birthday. does such a function exist in excel or access. thanks
>>
>> jiana
>
> --
>
> Dave Peterson

[Dave Peterson]

I put the birthdate in A2. I put the person's name in B2.

=if(a2=today();"Happy Birthday to: " & b2; "")

If your birthday were today and you had "Jiji" in B2,
then you'd see:

Happy Birthday to: Jiji
in the cell with the formula.

If it wasn't your birthday, the cell would look blank ("").

The & operator is the concatenation symbol. It's used when you want to join
text:

="Hello" & " " & "There"
will look like:
Hello There

"" is just an empty string so that looks blank.


jiji wrote:
>
> thanks for answering. but something wrong with my formula becase it shows
> False once it is today's date. this is my formula: if a1 = today();
> b1="happy birthday" if not "". what is the & means?
> "Dave Peterson" <petersod@verizonXSPAM.net> a écrit dans le message de news:
> 43E5F0C7.8EE569E1@verizonXSPAM.net...
> > I'd use an adjacent column--formatted in big red letters:
> >
> > =if(a2=today(),"Happy Birthday to: " & b2,"")
> >
> > With the bday in A2 and the name in B2.
> >
> > It's not quite a popup message, but it's easier and maybe it'll suffice.
> >
> > jiji wrote:
> >>
> >> hi
> >> how can i set a function that gives me my members birthday whenever i
> >> open
> >> excel. ex: like in outlook you have a pop up menu when you open it to
> >> tell
> >> you happy birthday. does such a function exist in excel or access. thanks
> >>
> >> jiana
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson

[jiji]

thank you so much.
"Dave Peterson" <petersod@verizonXSPAM.net> a écrit dans le message de news:
43E7E9CA.E5627AC8@verizonXSPAM.net...
>I put the birthdate in A2. I put the person's name in B2.
>
> =if(a2=today();"Happy Birthday to: " & b2; "")
>
> If your birthday were today and you had "Jiji" in B2,
> then you'd see:
>
> Happy Birthday to: Jiji
> in the cell with the formula.
>
> If it wasn't your birthday, the cell would look blank ("").
>
> The & operator is the concatenation symbol. It's used when you want to
> join
> text:
>
> ="Hello" & " " & "There"
> will look like:
> Hello There
>
> "" is just an empty string so that looks blank.
>
>
> jiji wrote:
>>
>> thanks for answering. but something wrong with my formula becase it shows
>> False once it is today's date. this is my formula: if a1 = today();
>> b1="happy birthday" if not "". what is the & means?
>> "Dave Peterson" <petersod@verizonXSPAM.net> a écrit dans le message de
>> news:
>> 43E5F0C7.8EE569E1@verizonXSPAM.net...
>> > I'd use an adjacent column--formatted in big red letters:
>> >
>> > =if(a2=today(),"Happy Birthday to: " & b2,"")
>> >
>> > With the bday in A2 and the name in B2.
>> >
>> > It's not quite a popup message, but it's easier and maybe it'll
>> > suffice.
>> >
>> > jiji wrote:
>> >>
>> >> hi
>> >> how can i set a function that gives me my members birthday whenever i
>> >> open
>> >> excel. ex: like in outlook you have a pop up menu when you open it to
>> >> tell
>> >> you happy birthday. does such a function exist in excel or access.
>> >> thanks
>> >>
>> >> jiana
>> >
>> > --
>> >
>> > Dave Peterson
>
> --
>
> Dave Peterson