Ok, Newbie question again-tried to figure it out myself but no luck so far.

I type a date in cell Fx and check its value in Qx and if it's egual to a
1(Sunday) then I return a message in cell Kx, "Don't use Sunday start date".
I don't want to write my message in Kx any longer, I want to have a msg box
where the user clicks ok, and it returns user to cell Fx to try again.

I have no clue but do I want a string like the one below (except one that
actually works) and where do I put it - in Kx?


=IF(Q63=1, Msgbox (title:="Don't use Sunday Start"),(Type:=vbOKonly)

Thank you!

I think you need Data Validation, which can do most if not all you describe.
See http://www.contextures.com/xlDataVal01.html

--
HTH

Bob Phillips

"Janet H" wrote in message
...
Ok, Newbie question again-tried to figure it out myself but no luck so
far.

I type a date in cell Fx and check its value in Qx and if it's egual to a
1(Sunday) then I return a message in cell Kx, "Don't use Sunday start
date".
I don't want to write my message in Kx any longer, I want to have a msg
box
where the user clicks ok, and it returns user to cell Fx to try again.

I have no clue but do I want a string like the one below (except one that
actually works) and where do I put it - in Kx?


=IF(Q63=1, Msgbox (title:="Don't use Sunday Start"),(Type:=vbOKonly)

Thank you!

Bob, Looks like exactly what I need. Thank you again.

"Bob Phillips" wrote:

I think you need Data Validation, which can do most if not all you describe.
See http://www.contextures.com/xlDataVal01.html

--
HTH

Bob Phillips

"Janet H" wrote in message
...
Ok, Newbie question again-tried to figure it out myself but no luck so
far.

I type a date in cell Fx and check its value in Qx and if it's egual to a
1(Sunday) then I return a message in cell Kx, "Don't use Sunday start
date".
I don't want to write my message in Kx any longer, I want to have a msg
box
where the user clicks ok, and it returns user to cell Fx to try again.

I have no clue but do I want a string like the one below (except one that
actually works) and where do I put it - in Kx?


=IF(Q63=1, Msgbox (title:="Don't use Sunday Start"),(Type:=vbOKonly)

Thank you!