Run code if day of month is prior to specific day

rjmdc

Well-known Member
Joined
Apr 29, 2020
Messages
743
Office Version
  1. 365
Platform
  1. Windows
I want to add code that says Call Send Messages if the day of the month is <=23
this way i can add that peice of code to my main process only if it the 23rd or before
 
wow i just learned a lot
tahnk you
happy new year
 
Upvote 0

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
You too!
Glad I was able top help!
:)
 
Upvote 0
thank you everyone
i was surprised. i ran the reports today, obviously before the 23rd and the email messages worked as expected.
i wasnt ready for it
wow
thanks again!
 
Upvote 0
hi
i was so excited
i bumped into a glitch
i run the report first forex December expiratios and then for January complete
i run these reports back to back just entering my parameters onto a user form
that menas since its before the 23rd everyone will get 2 identicle messages
how can i add it to my user form
i will create the check box send expiration emails with check for yes and blank for no
how tdo i add that the check mark refers to the above boolean code?
 
Upvote 0
Even though you are working on the same project, that is really a new, different question that you originally asked.
As such, you should post your new question in its own thread, so that it appears in the "Unanswered threads" listing that many people use to look for new unanswered questions to reply to.
 
Upvote 0

Forum statistics

Threads
1,226,107
Messages
6,188,968
Members
453,515
Latest member
maccannix

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top