I need a msgbox to run on the last day and first day of the month. How can I do that through coding or macro?

That's not a lot to go on, but you can use the functions here to test for the appropriate date:

http://www.pacificdb.com.au/Support/code_date_monthfunctions.htm