Hi guys,
I'm new to VBA and so spend all day yesterday making a user form that effectively works as a register/roll call. So that a manager would be able to select where each of their member of staff was that day and what they were doing. Once finished they pressed 'submit' and the data went into a list in Excel. It worked a treat. But then this morning I tried it and the following happens... every time:
The form pops up when you open the sheet (as intended) but when you fill it in and press submit it freezes, just showing that windows little blue hollow circle going round and round. Then when you open task manager to shut excel down, as soon as you press end task the usual windows asking if you are sure you want to end task pops up, as well as another window from Excel saying ‘Cannot quit Microsoft Excel’ (with a blue exclamation point and an 'OK' button).
If you select end task, Excel closes, but if you press cancel and then click ‘OK’ on the Excel message then the message I programmed into visual basic pops up (the one that pops up when you have successfully inserted and submitted the data)… you click OK on that and all of a sudden the userform has worked.
Can anyone tell me what on earth is going on? Thank you so much in advance.
Cheers
Will Register 2.xlsm
Bookmarks