Joffcom

If you make an excel user form and use the following code to load the form when Excel is opened you will run into a problem when the user clicks the x to close. 1 2 3 4 Private Sub workbook_open() Application.Visible = False FORM.Show End Sub The problem is Excel is still opened in [...]

I got very bored yesterday at work and decided to make a stopwatch using Excel and VBA it is a very simple thing to do and only took about 10 minutes to make so here is some more code for anyone who is interested. Open Excel and press Alt+F11 to open the VBA editor and [...]

I have spent today making an Excel form so that we can use multiple machines to post to one central workbook so that we don’t have to manually open up each workbook on the computers to collect the data. The code is very quick and simple and could be improved but it does the job [...]