Msgbox only on non-monday

[EXLent]

Could someone help me with this?
I want MSGBOX if current day is NOT Monday.
Somethingn like this.

Please Login or Register  to view this content.

[FDibbins]

Not sure how you would build this into your code (my VBA sucks), but this will tell you if the date is not monday....
=WEEKDAY(A15,2)>1

[ag273n]

try edit this:

Please Login or Register  to view this content.

so probably it'll be like this:

Please Login or Register  to view this content.

[EXLent]

Here's little bit more of it.

Please Login or Register  to view this content.

I can't get it to put X on B27.

[ag273n]

change that to this:

Please Login or Register  to view this content.

[EXLent]

What's the difference, beside the mispell of TWONE?
Anyway, it didn't work.
It's this part it doesn't like.

Please Login or Register  to view this content.

[ag273n]

gota be the mispelled part...

it should be

Please Login or Register  to view this content.

and no need to put the else statement if you have nothing else... :D

[EXLent]

Well, once YES is confirmed, it go straight to second end if

gota be the mispelled part...
it should be

It's just for myself, still learning

and no need to put the else statement if you have nothing else... :D

[EXLent]

I got it.

Please Login or Register  to view this content.

[ag273n]

you could make it like...

Please Login or Register  to view this content.

if there's nothing else in the else statement then the above code should be fine

[EXLent]

Ok, I guess I need help understanding this weekday stuff.
The code above is one I got from internet.
Trying to understand their explanation but not getting it.
I get Sunday = 1 thru Saturday = 7
this part i just dont understand.

Please Login or Register  to view this content.

Could someone show me a sample code?
If it's Monday,
msgbox "IT IS MONDAY"

If it NOT Monday
msgbox "today is NOT Monday"

[ag273n]

Microsoft office's explanation of that function can be found on the help too in the VB editor.
you don't have to use all 4 examples, at least 1 can work for your purpose,

Syntax
WeekdayName(weekday, abbreviate, firstdayofweek)


example:

Please Login or Register  to view this content.

would return "Monday"

Day of the week
First day of the week you consider

(i believe)the above function cannot discriminate the current date if its monday or not since it doesn't take a variable like a date

[EXLent]

Ok, someone just told me this and I like it a lot and easy to understand.

Please Login or Register  to view this content.