I need a msgbox to appear if the named range DropDownDate is Not Null.
The msbgbox needs to state "Enter Drop Down Amount"
I have never used msgboxes and Excel. Not sure how to handle or maybe there is another way to do this. I dont know if there is a CurrentEvent of the form like there is for MS Access.