Yup, presenting the code would help. Here it is, with proper indentation.
These are the workbook level events to start up and shut down frmDataEntry.
Private Sub Workbook_Open()
Load frmDataEntry
frmDataEntry.Show vbModal
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)...
Excel 2003...I created a form with nine textbox controls, wrote subs for keyboard events, even logged activity to an external file. I also created Workbook_Open and Workbook_BeforeClose subs to autoload and autounload the form.
Throughout the process, I was able to open the workbook and have...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.