Pop up message box


New Member
Jun 20, 2019
Hello all,
I have a workbook that uses multiple command buttons to get to the user forms and writes data to multiple sheets. I was wondering if there is a way to get a message box to pop up when I click on my midnight command button and "01" is displayed in cell "C4" on the main page where the command buttons are? The only thing is I have 6 different times a day I enter data and I don't want this to pop up all day long on the 1st. ("01" being the first of every month). Also is it possible to have the message box not allow the user to enter data for the new month until they save and delete the previous month? I have the workbook as a template and the save button will save it to 2 different drives and then they delete the template for the new month. Each user form will send data to a specific row based on the date. If anyone have different ideas on what I should do, I'm just looking for a way to send them a message to save and delete on the 1st without it popping up 5 other times through out the day when they did the first time it popped up. If anyone could help me that would be great.
Thanks Kevin

Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...