kevinc1973
New Member
- Joined
- Jun 20, 2019
- Messages
- 22
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
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
